SAP Knowledge Base Article - Public

2610601 - This value is the result of aggregating multiple matching values due to blending warning in SAP Analytics Cloud

Symptom

  • Measure / account values from second model are duplicated in SAP Analytics Cloud (SAC) when two models are linked by dimensions in SAP Analytics Cloud (SAC).
  • A warning is displayed:
    • This value is the result of aggregating multiple matching values due to blending.

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Create a new Chart in a story on a primary model.
  2. Click Add Linked Models and then select a secondary model.
  3. Choose one or more dimensions from both primary model and secondary model to create link dimension.
  4. Create a blended chart, select one measure from primary model and one measure from the secondary model.
  5. Notice the values from the secondary model are getting accumulated based on the relationship of the dimensions.

Cause

  • The warning is due to the relationship between the model attributes or dimensions referenced in the blending scenario and the type of relationship is one-to-many.

Resolution

Linking Models Links.PNG

 

See Also

 Your feedback is important to help us improve our knowledge base.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, linked model, link model, linked dimension, link dimension, dimension, measure, primary, secondary, second, blended, blend, chart, The value is the result of aggregating multiples matching value due to blending , KBA , 2636067 , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , How To

Product

SAP Analytics Cloud 1.0