3785409 - Hierarchy with directory: hierarchy node texts shown as ids in the analytic model preview in SAP Datasphere

In the analytic model preview,

• leaf member texts are displayed correctly, but hierarchy node texts are shown as IDs,
• hierarchy node text are not visible when using a hierarchy with directory.

SAP Datasphere

1. Open the analytic model.
2. Add the relevant dimension to the rows.
3. Select the hierarchy for the dimension.
4. Observe that leaf member texts display, but hierarchy node texts are shown as IDs.

• The hierarchy view’s dimension association uses a composite join key (for example, HIEID and the node ID), but the Node Type Values configuration for the non-data node type is only selected as one of these key columns. Because not all join key columns were included, the system could not match the association to the node type, and the node text lookup for those nodes was skipped.

1. Open the Hierarchy with Directory view used by the analytic model. Review each hierarchy view: compare the columns used in the node text association join with the columns defined in Node Type Values for the non-data node types (for example, R and N). They must match exactly.
2. Identify the dimension association that supplies hierarchy nodes and note its full join key (for example, 2 columns HIEID and NodeID).
3. In the Hierarchy with Directory Settings of this Hierarchy with Directory view, open Node Type Values and select the non-data node type.
4. Ensure the Node Type Value column includes all columns of the association’s join key and in the correct order. Add any missing column(s) (for example, column 1 = HIEID and column 2 = NodeID).
5. Save and redeploy the Hierarchy with Directory view.
6. Redeploy the analytic model so it picks up the updated hierarchy definition.
7. Preview the model again and verify that hierarchy node texts are displayed.

hierarchy with directory, hierarchy node text, node texts as the ID, analytic model preview, composite key, node type values, HIEID, 0HIER_NODE, external hierarchy, directory hierarchy, text association, missing node text, hierarchy node id, datasphere hierarchy, node text lookup, parent node, parent member, HwD, short description, long description, medium description, parent member, dimension, master data,  text is not visible, text is not displayed , KBA , DS-MD-VIW , Views , DS-MD-AM , Analytic Model , Problem