Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 ordering in MDX

Author  Topic 

Posting Yak Master

193 Posts

Posted - 2009-08-18 : 06:45:15
I have one MDX query like this.............

SELECT {[Measures].[Rolling Work History Costs]} ON COLUMNS,
{Order({[Functional Location ID].[Level 02].AllMembers},[Measures].[Total Rolling Costs],DESC)} ON ROWS
FROM "Cost Metrics

which is giving me correct result.

but i need Rolling Work History Costs to sorted in descending values.
like highest max value ,then second max,then third max etc.

pls help me on this.

Most Valuable Yak

15732 Posts

Posted - 2009-08-18 : 08:07:19
Dupe of
Go to Top of Page

- Advertisement -