Symptom
- In a story table, different items display identical summation values.
- The issue appears when analyzing a blended table in a story.
- When specific row dimensions (for example, item code or item description) are added, calculated totals/quantities become incorrect.
- Warning displayed: “Blended data caused some values to be duplicated for these measures”.
- Warning displayed: “Blending caused some values to be aggregated for these measures”.
- It would be very beneficial to have support for a more flexible model relationship behaviour similar to a “left outer join” approach.
Where measures from one model can still be displayed while preserving all related dimension members from another model, even if matching records are missing.
Environment
- SAP Analytics Cloud(Enterprise)
Reproducing the Issue
- Create a blended table that links dimensions across two models.
- Configure the table to use measures from one model.
- Add a row dimension that primarily exists in the other (linked) model (for example, item-related dimensions).
- Observe that multiple items show identical summation values and that blend warnings about duplicated/aggregated measures appear.
Cause
- Currently there is a limitation in place that does not support this since:
- Measures are taken from a model that does not contain all required row-dimension members; blended tables cannot display members that have no corresponding data in the measures’ model.
- Non-unique/ambiguous blend links (for example, linking on descriptions rather than unique IDs) can create many-to-many matches, causing duplicated rows and aggregated measures, which leads to identical summations.
Resolution
- There is already a product enhancement request that has been created for this specific request,please consider voting for the influence idea Enable Left Outer Join Behavior Across SAC Models for Incomplete Related Data.
Voting on this idea helps to highlight the idea to product management and it can be prioritised. - As a workaround please consider the following approaches:
- Use measures from the same model that contains the row-dimension members you need to display.
- In the blended table, add the linked dimension (or the dimension itself) from the same model as the measures to the Rows.
- Where possible, define blend links on stable, unique IDs rather than descriptions to avoid many-to-many matches that duplicate or aggregate measures.
- If totals are required, verify they are supported for the measures/accounts used in blended queries; redesign if necessary.
See Also
- Create Blended Tables (New Table Build Experience)
- 3466556 - Blended data caused some values to be duplicated for these measures warning happens in story
- 2636067 - Blending Aggregate: Blending caused some values to be aggregated for these measures
- 3629549 - Blend Query Support for Totals
- SAP Analytics Cloud community best practices expert page
- 2511489 Troubleshooting performance issues in SAP Analytics Cloud
- 2413393 How to record timelines in Chrome Developer Tools in case of SAP Analytics Cloud performance issues
- Performance Analysis Reference
- Wikipedia - .har files
- 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?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://me.sap.com/servicessupport/search#?q=SAP%20Analytics%20Cloud%20OR%20SAC&tab=All
- https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
Keywords
blended table, duplicate values, identical summation, aggregated measures, blend warning, blending duplication, blending aggregation, link on description, link on id, many-to-many blending, row dimension mismatch, missing members, totals in blend, story table, analytics cloud , KBA , LOD-ANA-TAB-BLE , Table Blending , Problem
Product
SAP Analytics Cloud all versions
SAP Knowledge Base Article - Public