Skip to Content
0
Jun 14, 2011 at 12:53 PM

Sorting Time dimension in EVDRE

35 Views

Hi all,

This is probably an easy question that for some reason I fail to answer.

I have an EVDRE with Time dimension in the columns.

I have defined my Time dimension as 2011.Jan, 2011.Feb, 2011.Mar etc.

One line below the key I have placed a description (in Hebrew) and I have indicated to hide the column keys.

During the expansion the dimension is not sorted properly. The order (by month number) is:

2011.Feb 2011.Jan 2011.Mar

2011.Apr 2011.Jun 2011.May

2011.Aug 2011.Jul 2011.Sep

2011.Dec 2011.Nov 2011.Oct

It seems that the system sorts it first by querter and then by alphabetic order.

Any ideas how can I control the sorting of columns in EVDRE?

I have also upgraded to 7.5 SP06. I last saved the template in SP05. When I open the template I can see that the dimension is sorted properly and then during the expansion it changes the sorting order. Did any one tackle this in SP06?

Thanks,

Avihay