Hello Everybody:

Somebody know how I can create a nested ranking from a analysis services
cube, for two intermediate levels of one dimension, using MDX?.. i mean, sort
a intermediate level using a measure and then sort a child level using the
same measure... but that the parent level do not be sorted in turn by his
parent

Something like:

Dimension
Location: Country->Region->City
Measures: Sales Amount

I need get the next results:
Location Sales Amount
Region1 25
City1 20
City2 3
City3 2
Region2 10
City4 6
City5 4
Region 3 5
City6 3
City7 2

I need this result independently of the "Sales Amount" values in the Country
level's order.

Thanks in advance

Rodrigo

SELECT
{[Sales Amount]} ON 0,
Generate(Order(Location.Region.Members, [Sales Amount], BDESC),
{Location.CurrentMember, Order(Location.CurrentMember.Children,
[Sales Amount], DESC)}
) ON 1
FROM Sales

Ohjoo Kwon


"Rodrigo" <Rodrigo (AT) discussions (DOT) microsoft.com> wrote

Thanks Ohjoo!!! Work fine!!

Regards
Rodrigo

"Ohjoo Kwon" wrote: