Symptom
- In the SAP Datasphere Analytic Model, the text is not visible in the lower level of a level-based hierarchy with a compounded key.
- This issue is observed when previewing the hierarchy in the Analytic Model.
- The hierarchy displays the ID correctly, but the text is missing at the lowest level.
Environment
SAP Datasphere
Reproducing the Issue
- Go to the Analytic Model.
- Move dimension into the rows.
- Select the hierarchy.
- Expand the nodes.
- Lower nodes do not display the text information.
Cause
The cause of the issue is that level-based hierarchies are not supported for dimensions with more than one key column.
Resolution
- Use a parent-child hierarchy: In the case of a compounded dimension, for the text to work correctly in the hierarchy, the hierarchy definition must match the same number of parent-child pairs as used for compounding.
- Alternatively, use a hierarchy with directory.
See Also
Help Portal - Add a Hierarchy to Dimension
Keywords
Analytic Model, level-based hierarchy, compounded key, dimension, text not visible, parent-child hierarchy, hierarchy with directory. , KBA , DS-MD-VIW , Views , DS-MD-AM , Analytic Model , Problem
Product
SAP Datasphere all versions