Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Sorting Time dimension in EVDRE

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?




SAP released a SAP Note regarding this issue:

1581331 - Time dimension is not sorted correctly in Excel Client


0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question