MDX query (was "syntax error")

" ORDER ( [Accounting Date].[Account Week].Members , DESC ) ON ROWS "
what is wrong with this line?1. the BY keyword is missing
2. the database/table/column names appear mixed up
3. the comma shouldn't be there
4. the parentheses shouldn't be there
5. the ON ROWS shouldn't be there|||im using MDX not sql yeah?

any ideas for my date sorting query

THANKS 4 REPLYIN!|||what's MDX?|||when using cubes in analysis manager??|||yeah, sorry, i had never heard of it, but a quick search on google showed some interesting results

for example, i don't see an ORDER clause

http://msdn.microsoft.com/library/en-us/olapdmad/agmdxbasics_0v7d.asp|||thanks mate...
order is introduced when you wnat to sort teh result!!!

Thanks enyway!!! : )|||I am creating a OLAP system, where a result table row is a time property. They have options of year, quarter, month or week.

It is all working fine, and actually creates the MDX query depending on the users choice of time property!!! problem is if they choose month or week, the result is in no order... I want the system to display the results in order eg week 1 - week 52

any ideas??|||I am creating a system, where the result table has a row with time in it The user has the option of seeing the data on year, quarter, month or week.

It is all working fine, and actually creates the MDX query depending on the users choice is of teh above!!! problem is if they choose month or week, the result is in no order... I want the system to display the results in order eg week 1 - week 52

any ideas??|||[ moderator note: merging this thread with your other one that is essentially the same question ]