Symptom
- Qualifications (prefix/suffix) configured for dimensions in a source Analytic Model are not inherited when creating a new Analytic Model based on it.
- In the derived model, the Qualified Business Name reverts to none (no suffix).
- In the derived model, the Qualified Technical Name receives an auto-generated default suffix (for example, “_Dim5”).
- Expected behavior from users: qualifications maintained in the source Analytic Model should be passed through to derived models.
Environment
- SAP Datasphere
Reproducing the Issue
- Go to SAP Datasphere.
- Open Data Builder.
- Select your Space.
- Open the relevant Analytic Model.
- Make sure the Properties / Details side panel is visible.
- If you do not see it, click Details in the toolbar.
- In the Analytic Model canvas, click the dimension node whose attributes you want to qualify.
- Do not click the fact source or just an attribute in the list.
- In the right-hand Properties panel, look for the section related to the dimension’s attributes / technical names.
- Choose the Edit / pencil icon for the prefix or suffix for the technical name of attributes.
- Enter the required prefix or suffix.
- Example:
SOLD_TO_,SHIP_TO_, or_SOLD_TO. - Note: according to the documentation, prefixes cannot start with an underscore.
- Example:
- Save and deploy the Analytic Model.
- Create a new Analytic Model based on the source Analytic Model.
- Open the corresponding dimension in the new model and review the Qualified Business Name and Qualified Technical Name.
- Observe that the qualifications revert to defaults (no business suffix; technical name uses an auto-generated default suffix)
Cause
Current product behavior: prefix/suffix qualifications are maintained per dimension instance within an Analytic Model and are not inherited to derived models.
Resolution
- Maintain required prefixes/suffixes per dimension instance in each Analytic Model where they are needed.
- If inheritance of qualifications is required, submit an enhancement request via the influence channel (refer to: How to create an enhancement request for Datasphere).
See Also
Keywords
prefixes, suffixes, qualification, Analytic Model, dimension, inheritance, derived model, qualified business name, qualified technical name, default suffix, _Dim, not inherited, per-instance maintenance, naming conventions, Datasphere , KBA , DS-MD-AM , Analytic Model , Problem
Product
SAP Datasphere all versions
SAP Knowledge Base Article - Public