SAP Knowledge Base Article - Public

2594760 - MIN and MAX aggregation calculations does not work correctly in SAP Analytics Cloud

Symptom

  • MIN and MAX aggregation calculations does not work correctly in SAP Analytics Cloud.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

  • SAP Analytics Cloud 2019.08.11

Reproducing the Issue

  1. Create a model from a simple excel file, for example:
    MM1.jpg
  2. Create a Story.
  3. Add a chart based on the above created model.
    • The requirement is to see the max/min for all the managers.
      • Min/max should be the same for all the Managers except Jon.
      • Max John=3, Min John =1
  4. Add Managers to the dimensions of the chart.
  5. Create a new calculation:
    MM2.jpg
  6. Notice that the value for John seems wrong (the expected value would be 3):
    MM+.jpg

Cause

  • An aggregation is applied for the Manager dimension (in the calculation), so even if adding the Manager dimension to the chart dimensions, the values for each dimension member will be aggregated.
  • There is no option to use disaggregation.

Resolution

  1. Delete the Manager from the chart dimensions.
  2. Notice that the chart works correctly.
  3. The Max Manager calculation aggregates all the managers and show the largest value across the dimension members.
    • In this example it is 5 (for Andy):
      MM3.jpg

See Also

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

Keywords

Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, value, wrong, min/max, minimum, maximum, calculation, aggregation , 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 , Problem

Product

SAP Analytics Cloud 1.0