SSRS and calculated measures. - social.msdn.microsoft.com
Jul 26, 2011 · I think you can achieve this requirement in reporting services by creating a Calculated Member, at Graphical MDX Query Designer in Design Mode, we can click button …
MDX for powerpivot - social.msdn.microsoft.com
Oct 10, 2016 · Do you mean writing MDX queries to get data from SSAS multidimension mode cube into Power Pivot data model? Power Pivot engine itself supports DAX queries but not MDX.
YTD Calculated Members - social.msdn.microsoft.com
Jun 18, 2008 · To do that you would add something like the following to the end of your MDX Script ALTER CUBE CURRENTCUBE UPDATE DIMENSION Time, …
Grand Total in MDX query - social.msdn.microsoft.com
Jul 21, 2011 · You could use the VisualTotals MDX function to accomplish what you're trying to do. At least on the AdventureWorks example I tried, there was some quirkiness where the …
MDX - getting value of the first field in key collection Properties ...
Jul 10, 2009 · I came accross a problem recently. I would like to extract the value of the key [KeyColumns] property. I done this without any problem when the collection just contains one …
Limitations on CustomData property of ConnectionString
Mar 19, 2015 · This property can be captured by CUSTOMDATA () function MDX, it can be processed in the MDX query. You can also pass some string (like username) in the …
Weird Error: Unable to read data from the transport connection: …
Jul 2, 2015 · Since your query has a lot of crossjoin, it may also killed if you enable Kerberos. Please refer to articles below: Windows Server 2008 Kerberos Bug – Transport Connection …
Continue run MDX Query - social.msdn.microsoft.com
May 11, 2014 · I want to execute a query which can continue run till 2 minutes .
Cannot call Excel functions from within SSAS (ExcelMDX com …
Dec 3, 2015 · 1. Yes, the Round call is just an example. Eventually I want to be able to execute Excel's IRR function from within SSAS MDX. 2. I configured SSAS to run from a local admin …
Join two tables together in a Set with MDX
Jun 17, 2012 · I want to be able to run pivot tables and charts off this data as if it were all one big dataset. How do i go about joining these two together to drive pivot tables and charts? MDX …