SAP Knowledge Base Article - Public

2741494 - Unstable sorting of Restricted / Calculated measures in SAC - 2019.1.1

Symptom

The following behavior occurs in SAP Analytics Cloud (SAC):

  • When more than 11 restricted or calculated measures are added to an input form, the order of Measures becomes very unstable and one of newly created measure is sorted without any logic to the middle position of all columns. 

Environment

  • SAP Analytics Cloud 2019.1.1+

Reproducing the Issue

  1. Create multiple calculation on the form
  2. After large number of them (>10) the default order becomes unstable.

Resolution

This has been a long standing limitation in the product for acquired/imported data models.

Depending on the maximum number of calculation members setting for an SAC tenant, the number of calculations in a Table, and the order they were created in, it is quite predictable how many calculations will be out of order and which calculations they would be. With default settings calculations will start appearing out of order on the 13th calculation.

Update: As of SAP Analytics Cloud 2020, it is now possible to sort members within a Table using a "Custom Order". Please see the guide below for more information;

Sorting Measures and Dimensions - https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/86fe68c5004d4a63b42db9f490c59b75.html

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 (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Product Enhancement

Product

SAP Analytics Cloud 1.0