I am just getting members from Jan to Dec.

Jan , Feb , March , April , ..... Dec

Problem :
Can i get them in Reverse order ?

Dec, Nov, Oct , .... Jan

I want to ask that using Order Funtion in MDX can i get these members
in reverse order . For this prupose what criteria i should provide in
the Order Function.


Thanks in advance.

Faraz

I;m not sure if there is an MDX command for this, there may be, but i can
think of a different way for this.
You could create your own SORTORDER column in your dimension and then order
by that?
i.e.
Month SortOrder
December 1
November 2
....
Regards
Immy

"Faraz" <ahmed.faraz1 (AT) gmail (DOT) com> wrote

This Foodmart Sales sample uses the Rank() function:

'Descendants([Time].[1997], [Time].[Month])'
select {[Measures].[Unit Sales]} on columns,
Order([MonthRange],
Rank([Time].CurrentMember,[MonthRange]),
BDESC) on rows
from Sales

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***