SAP Knowledge Base Article - Preview

3780970 - Incorrect aggregation in Analytic Model when adding attributes from associated composite-key dimension in Datasphere Data Preview

Symptom

  • In an Analytical Model, measures are aggregated incorrectly when an attribute from an associated dimension is added to the preview.
  • When fields from a dimension defined by composite keys are used, measures values are multiplied even though the dimension contains no duplicate key combinations.
  • The issue occurs only when adding the compound key dimension to drilldown in Datasphere Analytic Model Data Preview.


Read more...

Environment

  • SAP Datasphere

Product

SAP Datasphere all versions

Keywords

analytical model, incorrect aggregation, composite key, association, dimension join, measures multiplied, nc_code, plant, many-to-many, inflated measures, re-insert dimension, key change, datasphere modeling, association predicate, aggregation issue , KBA , DS-MD-AM , Analytic Model , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.