SAP Knowledge Base Article - Public

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

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

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

Product

SAP Analytics Cloud 1.0