SAP Knowledge Base Article - Public

2636067 - Blending Aggregate: Blending caused some values to be aggregated for these measures in SAP Analytics Cloud

Symptom

You created a new chart or table using measures and dimensions from two different models linked by certain dimensions.

When you try to display that chart or table, you see a warning sign:

Blending Aggregate: Blending caused some values to be aggregated for these measures

Environment

  • SAP Analytics Cloud

Cause

By default, the linked dimensions will link by description. If the descriptions are empty, that will cause some measures to be counted multiple times.

Resolution

You can resolve this loop making sure that the linked dimension has values for all the records.

Option 1 - Link dimensions by ID:

Linking_by_ID.png

Option 2 - In the model, complete the descriptions for the linked dimensions

Empty_Description.png

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

linking, blending, loop, aggregate, SAP Cloud for Planning, sc4p, c4p, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0