Symptom
Aggregation doesn't work on "Aggregation Dimensions" when creating calculation measure in SAP Analytics Cloud
Environment
- SAP Analytics Cloud (SAC)
Reproducing the Issue
- Create a story.
- Add a Table into canvas using sample model "BestRunJuice_SampleModel".
- Add "Location" & "Product" as Rows.
- "Gross Margin" of Account in Columns.
- Create a new Calculation Measure. Select Type Aggregation; Select Location as Aggregation Dimension.
- 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
- 2569847 - Where can you find user assistance (help) for SAP Analytics Cloud to use, configure and operate it more effectively?
- Have a question? Ask it here on the SAP Community. Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
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