SAP Knowledge Base Article - Public

2803258 - Measure object cannot display correct value after merge dimensions in SAP Analytics Cloud story

Symptom

  •  Measure object cannot display correct value after merge dimensions in SAP Analytics Cloud story
  •  Measure object shows sum value instead of actual value when using linked models

Environment

  • SAP Analytics Cloud 
  • Import Data Connection

Reproducing the Issue

  1. Create model M01 with 1 dimension "A01"  and 1 measure object "m01"
  2. Create model M02 with 3 dimensions "A01" , "B01", "C01" and 1 measure object "m02".
  3. Create story page with M01 in table structure.
  4. Create story page 2 with M02  in table structure.
  5. Create story page 3 with Linked M02 & M01 on dimension "A01".
    >>Measure object"m01" displays sum value for all rows.

Cause

The problem here stems from the fact that the acquired data has an empty string value for the linked dimensions' Description attribute which is used by default in blending scenarios.

Resolution

The fix in this case is to explicitly give the application a hint to use the ID attribute.

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

merge, merging, linked model, linked dimension, Link Dimension, incorrectly, sum, aggregation, total, Data, Story, Models, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0