SAP Knowledge Base Article - Public

3226765 - SAC Blending causing duplicated values

Symptom

  • Have used blending in a Story Table but the Measure is getting duplicated again and again (I have used ID to link dimensions).

  • Table shows values duplicated when blending two data-sources;

  • After swapping axis on 'Builder > Table Structure > 'Swap axis' button, the data is showing accordingly;

  • 'Only transposing the table should not influence the result, since in this case the relation between the dimensions stays the same '.

 

Environment

SAP Analytics Cloud 2022.8.14

Reproducing the Issue

  1. access a story;
  2. blend two data-sources on a table;
  3. you will see duplicated data;
  4. click on Builder > Table Structure > Swap axis;
  5. no more duplicated data;

Cause

Cause under investigation by our development team.

Resolution

Issue under investigation by our development team.

Keywords

KBA , LOD-ANA-DES-COR , SAC Core story functionality - widgets, geo, design, etc , Problem

Product

SAP Analytics Cloud 1.0