Sorting by calculated measure possible?

[ThomasK]

Environment: SAC live-connection on BW 7.50 SP11 on HANA

I´ve created a bar chart to visualize efforts (as measure) per status (as dimension).

Then I changed sorting by measure effort from highest to lowest with the following result as expected.

Then I created a calculated restricted measure based on the same measure as following:

If I try now to sort again from highest to lowest the chart is not showing the correct sort order.

Somebody having the same issue?

Is this a restriction or a bug?

Regards,

Thomas

[ThomasK]

Hi, SAP Notes 2621795 and 2669271 needs to be applied.

First one is included in BW 7.50 SP12, which let it obviously work for you, because you´re using SP12.

Second one is included in SP14. Maybe not necessary in my case.

BR Thomas

[JohnL · Accepted solution]

Hi Thomas,

Have you seen this article:

2666019 - Calculated Measures cannot be sorted in SAP Analytics Cloud
https://apps.support.sap.com/sap/support/knowledge/public/en/2666019

FYI most of our knowledge and KBA's are available publicly via google / bing:

See the section "5. Troubleshooting Already Performed" for some example google / bing queries at https://apps.support.sap.com/sap/support/knowledge/public/en/2487011

Thanks

John

[ThomasK]

Hi John, this is exactly the problem I have. Thanks for your answer & solution.

Regards,

Thomas

[john_hawk]

Hi Thomas,

My guess is that the problem is you are grouping by two characteristics (states and the characteristic of the restricted key figure) but displaying only one (status). Consider adding a filter for the characteristic of the restricted key figure in the source query, or adding the characteristic of the restricted key figure to the display, sorting characteristic of the restricted key figure then status. You could also hide the display of output of characteristic of the restricted key figure.

John Hawk