how can i user ORDER

[olli_d]

i have this mdx code:

select {warengruppe.allmembers, segment.allmember} on Rows,
{1,2,3,4} on colums


the result is this:

01 Artikel1 2 2 2 2
02 Artikel2 3 4 4 2
03 Artikel3 3 2 1 2

011 Artikel1sub 2 2 2 2
012 Artikel1sub 2 3 2 2
.
.


But i want to show the data like this:
01 Artikel1 2 2 2 2
011 Artikel1sub 2 2 2 2
012 Artikel1sub 2 3 2 2
02 Artikel2 3 4 4 2
03 Artikel3 3 2 1 2

But how can i do this? Normaly i need to use an order statement. But how ?

[Island1]

Hi:

I invite you to read the following article I wrote on the subject:

http://www.databasejournal.com/featu...le.php/3088161

In doing so, you save us both some time.

If you have further, specific questions, however, please advise. I will respond as time is available.

Good Luck!

Bill