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.
Read more...
Environment
- SAP Analytics Cloud(Enterprise)
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
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview