Hi there,

Im pretty new to MDX queries and am trying to create a query that i can use
in reporting services to drill down into my data.

SELECT { Descendants ([Time].[All Time].[2003], [Time].[Month], LEAVES),
Descendants ([Time].[All Time].[2004], [Time].[Month], LEAVES)} ON COLUMNS, {
Descendants ([Customer].[All Customer], [Customer].[PostcodeArea], LEAVES) }
ON ROWS FROM Joiners

This currently shows the correct information, the ability to view joiners by
their location (country -> region -> postcodeArea) and by year, quarter and
month.

However, when the postcodearea is reached, the postcodes seem to be in a
random order. Is there a way to order the dimensions? Or am i confusing a
simple issue.

Thanks.

Ben Mann

You have to use the clause ORDER (<set>, <value_expression>) search for it
in the help on line or see

http://doc.ddart.net/mssql/sql2000/h...tions_7diq.htm

Bye
Andrea
"Ben Mann" <BenMann (AT) discussions (DOT) microsoft.com> ha scritto nel messaggio
news:40BD9064-F2EB-4F8E-B5B1-B373431FEEFD (AT) microsoft (DOT) com...