mdx-problem: how can i get 2 levels from 1 dimension

[mikeG77]

Hi,
this is my problem: On rows i got a dimension with 3 levels, for example: year, month and day and on columns a measure like 'quantity'. now i´d like to write an mdx-query with a result like this:

|quantity|
|2001| January | 7|
|2001|February| 5|
...
|2002| January | 33|
...

years and month must both be in the result,
NEST is not working because it only allows different
dimensions and UNION just allows to get year and month
in one column.
Please help!

 

[Guest_imported]

Have you tried concatenation

 

[ashortnacy]

You could make the parent tag a property of the child.