Hi to all,
I have the classical "date" virtual dimension, hooked to a date field in the
fact table.
I run a MDX query that lists my results by year, and it's ok. Now, I want
exactly the same thing, but ordered by year descending. The order
specification is the year itself, that is, 2004, 2003, 2002 ......


How can I write an MDX expression where Years are in descending order? I
tried this:

ORDER( { [Date].Children }, ([Date].Children), DESC ) ON AXIS (1)

but I get a "token is not valid: ..... ^,^ DESC" error.

Any help greatly appreciated.
Bye