Symptom
Upon creating an analytical model based on the fact view, validation errors occur:
- Dimension source has no representative key
- Dimension source has no compound key sequence
The expectation is to reuse a single association for multiple fields in the Analytical Model.
Environment
SAP Datasphere
Cause
The current design requires associations to be configured in a 1-to-1 field mapping. Multiple associations must be created for multiple fields, as reuse of a single association for multiple fields is not supported.
Resolution
- Configure associations in a 1-to-1 field mapping for each field.
- Create separate associations for each field to ensure proper functionality in the analytical model.
For enhancement requests to support association reuse for multiple fields, submit a request via the SAP Influence portal.
See Also
- SAP Help Portal - Dimensions in the Analytic Model
- SAP Help Portal - Set Key Columns to Uniquely Identify Records
Keywords
reuse association, analytical model, multiple fields, validation errors, representative key, compound key sequence, fact view, association mapping, field mapping. , KBA , DS-MD-AM , Analytic Model , DS-MD-VIW , Views , How To
SAP Knowledge Base Article - Public