Symptom
Measures are getting doubled/tripled after adding dimension in the drilldown.
Environment
- Product: SAP Datasphere
Reproducing the Issue
- Open the relevant Analytic Model in Data Builder.
- Go to the Data Preview tab.
- Set required variables (for example, a specific date).
- Optionally filter to a single product to simplify results.
- In Columns, keep only the relevant measure(s).
- Add the dimension to Rows.
- Observe that the measure values become duplicated or tripled.
Cause
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).
Resolution
- Identify the text association used by the impacted dimension in the Analytic Model.
- Preview the associated text table and check for duplicates: ensure each key has at most one row per language.
- Clean up the text table by removing or consolidating duplicate entries so that key + language is unique.
- Revalidate the Analytic Model in Data Preview by adding the dimension to rows and confirm that key figures no longer duplicate.
See Also
Support Content - How to maintain description for a dimension in Analytic Model
Keywords
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
SAP Knowledge Base Article - Public