SAP Knowledge Base Article - Public

3426430 - Compound key column(s) must be defined either in Dimensions or in Filter in order to make a consistent

Symptom

Analytic Model preview fails with: 
"The query executed with errors. The query is inconsistent : Following compound key column(s): '[XXX]' must be defined either in Dimensions or in Filter in order to make a consistent."

Environment

SAP Datasphere

Cause

All compounding parents need to be added to the rows or filtered on a constant value during the Analytic Model preview.

Resolution

The functionality is not supported. Therefore, a remodeling approach is recommended. 
If the functionality of being able to see the information without all the keys being specific to the dimension is required, add a new attribute (which is not key) that duplicates the information. 

See Also

Set a Compound Key

Define a Key

Keywords

AM, Compound Key Error, representative key, dimension, dwc , KBA , DS-MD-AM , Analytic Model , Problem

Product

SAP Datasphere all versions