When I return data from a MDX statement, I want the levels of the
dimension to be returned in inverted sequence, e.g. months, then
quarters then years instead of year, months, quarters.

My statement is:
SELECT {Descendants([Dates].[2004])} ON COLUMNS,
{[Customer].[All Customers[} ON ROWS
FROM [Performance]
WHERE ([Measures.Total Sales])

Thank you.

Hi,

SELECT

hierarchize({Descendants([Dates].[2004])}, post) ON COLUMNS,

{[Customer].[All Customers[} ON ROWS
FROM [Performance]
WHERE ([Measures.Total Sales])

Cheers,
Matthias

"zee" <zelda.calitz (AT) bmw (DOT) com.au> schrieb im Newsbeitrag
news:c726d6d2.0409302200.7e61941d (AT) posting (DOT) google.com...