SAP Knowledge Base Article - Public

3689345 - Hierarchy not working in analytic model when using reserved technical name (NODE_ID)

Symptom

The hierarchy cannot be selected or displayed in an analytic model when the association technical name is set to NODE_ID or another reserved identifier.

Environment

SAP Datasphere

Cause

Some technical names are reserved internally for hierarchy processing. Identifiers such as NODE_ID and PARENT_ID are used by the hierarchy_leveled generator function.
If one of these reserved names is used as a technical name in the analytic model, a naming conflict occurs and the hierarchy cannot be processed.

Resolution

  1. Use a different technical name for the association or attribute. For example, instead of NODE_ID, rename it to STR_NODE_ID (or any non-reserved name).
  2. After renaming, redeploy the analytic model. The hierarchy will then be available in the preview.

See Also

HIERARCHY_LEVELED Generator Function

Keywords

Hierarchy, analytic model, technical name,  node_id,  parent_id,  reserved , KBA , DS-MD-DS , Deployment Service , Problem

Product

SAP Datasphere all versions