MDX - Sum on nested dimensions - social.msdn.microsoft.com
Mar 23, 2017 · Is there a nice way of writing the mdx query without having to repeat the dozen of product names in the member declaration? Something that could be easier to maintain, so …
How to get the MDX query output in different format
Sep 8, 2011 · 2. If Source is having data as 100.00 the MDX query output would always display as 100? or whatever values I am getting from MDX query output are exactly same with the …
Can we create Stored Procedure from SSAS MDX Query
Nov 8, 2010 · Is this possible to create STORED PROCEDURE TO FROM MDX QUERY,if yes please tell me how and also can we use that STORE PROCESDURE in SSRS report.
mdx query and composite key - social.msdn.microsoft.com
Nov 29, 2011 · I have a dimension (let's say Products) with an attribute defined with a composite key. How can I write a MDX query on this attribute using the key and not the name ? With a …
Calculate percentage based on total - social.msdn.microsoft.com
Sep 10, 2012 · The MDX provided also didn't work. Terminology? Maybe you were refering to the parent of current member, the one above the current member? Your last two posts describe …
member ID in MDX - social.msdn.microsoft.com
May 24, 2014 · MDX question: In SSAS 2005 I have a dimension. this dimension has several members.
MDX 2 Time Bomb - social.msdn.microsoft.com
Dec 6, 2006 · The MDX/XNA thing is an anomaly, they really screwed the pooch by pulling the MDX 2 rug out from under developers while XNA is still basically unusable as an alternative.
MDX Scope Calculation, Parent total equal to Matching Child value
Feb 17, 2017 · I would like my parent (not a structure) total line be equal to matching child value The meausre agg = Max, in total line or without the dim "Item Base" the measure value must …
Will OLAP Cube and MDX expire? - social.msdn.microsoft.com
May 7, 2013 · after release SQL Server 2012, i have seen in few forums that MDX and Cube will not get any enhancements from Microsoft and in very future it will be expired.
MDX statement to Excel Fomula to go against an OLAP cube
Jul 9, 2014 · I am familiar with MDX, and can really swim good in Excel, but combining the two seems kind of hard. I have done some formulas using the cube formulas, but have all been …