Hi

I need to create a set that returns the parallelperiods for a number of
time members. I create this set like this:

{{[Time].[All Time].[2004].[Q 1 04], [Time].[All Time].[2004].[Q 2 04],
[Time].[All Time].[2004].[Q 3 04]},
GENERATE({[Time].[All Time].[2004].[Q 1 04], [Time].[All
Time].[2004].[Q 2 04], [Time].[All Time].[2004].[Q 3 04]},
{parallelperiod([Tid].[Years], 1)})}

Which gives me:
Q1 04, Q2 04, Q3 04, Q1 03, Q2 03, Q3 03

I need this set to be ordered like this:
Q1 04, Q1 03, Q2 04, Q2 03, ...
Anyone got any ideas how i can accomplish this?

Try:

{GENERATE({[Time].[All Time].[2004].[Q 1 04], [Time].[All
Time].[2004].[Q 2 04], [Time].[All Time].[2004].[Q 3 04]},
{Time.Currentmember,parallelperiod([Tid].[Years], 1)})}

HTH,
Brian
www.geocities.com/brianaltmann/olap.html

"arcticpuppy (AT) gmail (DOT) com" wrote: