SAP Knowledge Base Article - Public

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

Symptom

In the analytic model preview, leaf member texts are displayed correctly, but hierarchy node texts are shown as IDs when using a hierarchy with directory.

Environment

SAP Datasphere

Reproducing the Issue

  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.

Cause

  • 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.

Resolution

  1. Open the Hierarchy with Directory view used by the analytic model.
  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.

Keywords

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 , KBA , DS-MD-DS , Deployment Service , Problem

Product

SAP Datasphere 1.0