Sorting Time dimension in EVDRE
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?