Skip to Content

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

Sorting months in Design Studio

Dear all,

Sorting period names on basis of month date is a very critical and normal requirement.

I have to get month names sorted as(Jan,Feb,...).But the tool takes it alphabetically only.

Do the next version resolve this big?When will be the next version released?Is there any alternative that I can do at my backend HANA view?



Former Member
Former Member replied

Hi Archana,

This is possible with a minor modification in your HANA view, Add an extra display attribute to the dimension , this should contain the KEY for the months , this can be either be (1 to 12) or in the format (yyyymm).

In the initial view of the data source in DS, Set display attribute as KEY for the dimension and sort the members in ascending order.Now change the display attribute as Text. The sorting order remains the same and the Text is displayed as JAN FEB MAR etc..

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