ordering in MDX - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. 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

qutesanju
Posting Yak Master

193 Posts

Posted - 2009-08-18 : 06:41:23

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.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-08-18 : 06:49:37

Duplicate post
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=131349

N 56°04'39.26"
E 12°55'05.63"

qutesanju
Posting Yak Master

193 Posts

Posted - 2009-08-18 : 06:59:53

yeah...due to improper webpage loading it got posted double

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources