My collection of how to use MDX in a SSAS 2012 / 2014 environment.
Tuesday, July 29, 2014
Ascendants
The Ascendants functionality gives back all levels from and including the current level.
SELECT Measures.[Sales Amount] ON COLUMNS, Order( Ascendants( [Product].[Product Categories].[Product].&[448] ), DESC ) ON ROWS FROM [Adventure Works] where ([Date].[Calendar Year].&[2012]) Will give us:
Have Fun And Till Next Time
No comments:
Post a Comment