Hi,

I have the following MDX Query:

Select
crossjoin(
{[Products].[Product Name].Members},
{[ProductionEndTime].[2003].[January] : [ProductionEndTime].[2004].[January] }
)
on rows,
{ [Measures].[Produced Units], [Measures].[Rejected Units] }
on columns from Production
-----------------------------

It gives me something like this:

Product1 January
February
...
Product2 January
February


As you can see, ProductionEndTime is a date dimension.
The months are children of Year and Month obviously and i would like to see the month ordered by the year and month like this:


Product1 2002 January
February
...
2003 January
Frbruary
...
Product2 2002 January
February
...
2003 January
Frbruary
...

Any suggestion on how i could achieve this?

Thank you
Frank