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
- Create a new Chart in a story on a primary model.
- Click Add Linked Models and then select a secondary model.
- Choose one or more dimensions from both primary model and secondary model to create link dimension.
- Create a blended chart, select one measure from primary model and one measure from the secondary model.
- 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
- The type of relationship created depends on how related columns or attributes are defined.
- Change the relationship using the type of link for the second model in the Builder tab menu as the link below explains more:
https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/5e46baa7575f47cfab8fba9b98f51fbf.html
See Also
- 2636067 - Blending Aggregate: Blending caused some values to be aggregated for these measures 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
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