Hello Everybody:

Somebody know how I can create a nested ranking from a analysis services
cube, using MDX?.. i mean, sort a parent level using a measure and then sort
a child level using the same measure... 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

Thanks in advance

Rodrigo

Here's an example from Foodmart Sales, using Order():

Order(DrillDownLevel(
[Customers].[All Customers].[USA].Children),
[Measures].[Unit Sales], DESC) on rows
from Sales

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!