Skip to Content

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

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

img1.png (130.2 kB)
img2.png (94.3 kB)
img3.png (256.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 10 at 01:28 PM

    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

    Add comment
    10|10000 characters needed characters exceeded