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
Keywords
AM, Compound Key Error, representative key, dimension, dwc , KBA , DS-MD-AM , Analytic Model , Problem