Skip to Content

SAP Design Studio 1.6 – Months are not displayed chronologically in the dashboard

Jan 10 at 01:26 PM


avatar image

Hello all,

I have an issue regarding displaying the months in chronological order in the dashboard when changing the view from weekly view to monthly view. Please see below:

-> For the year/week is displayed correctly:

->when switching to monthly view, the months are not displayed in chronological order:


  • -SAP NETWEAVER 7.4 on HANA Database
  • - SAP BusinessObjects Design Studio 1.6 SP4 Patch

I’m using a bex query as a Datasource. In the Initial view the calendar year/week dimension is added to the rows with the following selections:

Member display ->Key

Member in result set: Only posted values

Sort by ->by member ->by key -> ascending

The following script on click event is used when switching from weekly view to monthly view:

datasorce1.removeDimension("Calendar year/week");


datasource1.sortByMember("month", true);

Could you please let me know why the month are not displayed in chronological order inthe dashboard? Should I add the monthly dimension to rows in the Initial view as well, with the same settings as Calendar year/week dimension?

Thank you and best regards,


img1.png (130.2 kB)
img2.png (94.3 kB)
img3.png (256.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Tammy Powlas
Jan 10 at 01:28 PM

Hi Cristina - please search, this question has been asked before. Here is a good thread to review:

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hello Tammy,

Thank you for sharing this thread, I had fixed the issue.

Best regards,