Symptom
- Create a new chart or table using measures / accounts and dimensions from two different models linked by dimensions in SAP Analytics Cloud (SAC).
- When viewing chart or table, the following warning is displayed:
- Blending Aggregate: Blending caused some values to be aggregated for these measures.
Environment
- SAP Analytics Cloud
Cause
- Linked dimensions will link by ("link on") the dimension description by default.
- Measures / accounts may be counted multiple times if the dimension descriptions are empty / null.
Resolution
Option 1 - Link dimensions by ID:
To create an explicit link on dimension ID, update the "Matched Dimensions" to "Link On" ID by clicking the ellipsis (...) on the dimension tokens for each side (of the Link Dimensions dialogue) and select the ID radio button.
Option 2 - Update dimension descriptions:
In the dimension (in the models area), update all the descriptions with non-blank string values for the linked dimensions.
See Also
- 2610601 - This value is the result of aggregating multiple matching values due to blending warning in SAP Analytics Cloud
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! 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
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
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, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, SAC - Model blending issues, blending, blended, Measure object cannot display correct value after merge dimensions in SAP Analytics Cloud story, , KBA , this value is the result , of aggregating multiple , matching values due to , blending. , 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