SAP Knowledge Base Article - Public

3065220 - Aggregation doesn't work on "Aggregation Dimensions" when creating calculation measure

Symptom

Aggregation doesn't work on "Aggregation Dimensions" when creating calculation measure in SAP Analytics Cloud

Environment

  • SAP Analytics Cloud  (SAC) 

Reproducing the Issue

  1. Create a story.
  2. Add a Table into canvas using sample model "BestRunJuice_SampleModel".
  3. Add "Location" & "Product" as Rows.
  4. "Gross Margin" of Account in Columns.
  5. Create a new Calculation Measure. Select Type Aggregation; Select Location as Aggregation Dimension.
  6. Check the result of the table, the Calculation measure value should be aggregated based on "Location", however it's based on "Product".

Cause

  • Aggregation Calculation works based on the dimensions and conditions selected in the Calculation Editor and in the Builder panel. 
  • If you have "Product" and "Location" in the builder panel as selected dimensions, then the calculation will aggregate the values for the Locations but based on each Products.

Resolution

  • If you would like to see only the Location based aggregation, use only the Location dimension in the builder panel.

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-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0