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

[crisitna_botea]

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:

Environment:

• -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.moveDimensionToRows("month");

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,

Cristina

[TammyPowlas · Accepted solution]

Hi Cristina - please search, this question has been asked before. Here is a good thread to review: https://archive.sap.com/discussions/message/14809525#14809525

[crisitna_botea · Accepted solution]

Hello Tammy,

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

Best regards,

Cristina