SSAS / MDX Query - Sort a CellSet

Question

I have an MDX query where I am returning a list of products and the total sales value for that item from my SSAS cube, like so:

 SELECT  
 NON EMPTY   
 { [Item].Children } ON COLUMNS,
 { [Total Line Value] } ON ROWS
 FROM        [Sales Analysis]

What I would like to do is sort the results in a descending fashion (ie the part that has sold the most will be at the top, and so forth). Is this possible? Any help would be appreciated, thanks.

Max Max · Accepted Answer · 2011-12-19T14:44:23

Try this

SELECT  
 NON EMPTY   
 Order([Item].Children, Measures.[Total Line Value], DESC) ON COLUMNS,
 { [Total Line Value] } ON ROWS
 FROM        [Sales Analysis]

SSAS / MDX Query - Sort a CellSet

1 Answers