SAP Knowledge Base Article - Public

2766028 - Custom sorting of calculated measures not working properly in stories in SAP Analytics Cloud (SAC) - 2019.4.4

Symptom

Custom sorting of accounts and calculated measures has been introduced in wave 2019.4.
While it seems to be working for accounts, calculated measures sorting is behaving erratically. The issue seems to be not really with custom sorting but rather with calculated measures creation itself.

When we create calculated measures they are sorted in order of creation by default. But when we start referencing other calculated measures in the calculation formula
the sorting begins to change.

Environment

  • SAP Analytics Cloud 2019.4.4

Reproducing the Issue

  1. Create a story
  2. In the Columns select a dimension Indicateur for example and create four calculations
  3. Call them: 1, 2, 3, 4
  4. Under the dimension Indicateur in the Builder select on : 4Calculations you will find them not sorted as in the story, you will find: 2, 3, 4, 1
  5. Go back to the story, click on the dimension and select option: Add Customer Order...
  6. In the right, change the order of the Calculated measures and select Preview button 
  7. You will find that the order is not reflected in the story table...

Resolution

This issue is planned to be fixed on 2019.06 wave for bi-weekly releases and for Q2 and on systems on QRC (Quarterly release cycle).

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0