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

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.

Environment

  • SAP Analytics Cloud 2018.1.7

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

  • The aggregation has 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 are aggregated.

Resolution

  • Delete the Manager from the chart dimensions.
  • Notice that the chart works correctly. 
  • 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

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 , 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