SAP Knowledge Base Article - Public

2666019 - Calculated Measures cannot be sorted in SAP Analytics Cloud

Symptom

Value sorting is not working for Calculated Measures in SAP Analytics Cloud.

Environment

  • SAP Analytics Cloud 2018.11
  • Live Data Connection
  • SAP Business Warehouse

Reproducing the Issue

  1. Create a model based on Live Data Connection to SAP BW.
  2. Create a Story based on this model. 
  3. Create a simple Calculated Measure in the Story. 
  4. Try to apply sorting on this Calculated Measure (e.g: Lowest to Highest).
  5. Notice that the values are not being sorted. 

Resolution

Fix has been only done for 7.50 above:

  • Please implement the SAP Note 2621795  and 2669271 in the SAP BW backend system.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Sort, Value, Measure, Calculated, Sorting, Highest, Lowest, Ascending, Descending , 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 Predicitive , Problem

Product

SAP Analytics Cloud 1.0