3797504 - Measures doubled or tripled after adding a dimension to drill-down - SAP datasphere

Measures are getting doubled/tripled after adding dimension in the drilldown.

• Product: SAP Datasphere

1. Open the relevant Analytic Model in Data Builder.
2. Go to the Data Preview tab.
3. Set required variables (for example, a specific date).
4. Optionally filter to a single product to simplify results.
5. In Columns, keep only the relevant measure(s).
6. Add the dimension to Rows.
7. Observe that the measure values become duplicated or tripled.

The dimension’s text association points to a text table that contains multiple rows for the same key and language, which multiplies rows when the dimension is added (especially for users whose data access language matches the duplicated language entries).

1. Identify the text association used by the impacted dimension in the Analytic Model.
2. Preview the associated text table and check for duplicates: ensure each key has at most one row per language.
3. Clean up the text table by removing or consolidating duplicate entries so that key + language is unique.
4. Revalidate the Analytic Model in Data Preview by adding the dimension to rows and confirm that key figures no longer duplicate.

Support Content - How to maintain description for a dimension in Analytic Model

datasphere, analytic model, duplicate rows, duplicated measures, tripled measures, cost center, drill-down, data preview, text association, text table, duplicate texts, language, data access language, dimension join, aggregation , KBA , DS-MD-VIW , Views , DS-MD-AM , Analytic Model , Problem