SAP Knowledge Base Article - Public

2651926 - Data is not displayed correctly when selecting Intersecting data only for the linked model type

Symptom

Data is not displayed correctly when selecting Intersecting data only for the linked model type

Environment

  • SAP Analytics Cloud 2018.9.5

Reproducing the Issue

  1. Create a story based on Model A.
  2. Add another model B to the existing story and make A linked to B.
  3. Select Intersecting data only for the linked model type.
  4. The data displayed is all the data from Model A which is the primary model.
  5. According to SAC guide, Intersecting data only allows only linked data to appear in the table.

Cause

On that chart, the two models are not blended. All measure/dimensions are from the primary model .
So the chart would ignore the linked model B and behave like if there's only one model A(primary), which was why all data from primary model was shown.

Resolution

Add a measure or dimension from the secondary model B, then the chart will be blended.
Only then would the rule of blending/linking come into play

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

, KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud all versions