Issue applying Hierarchy on a non key column in Dimension table in SAP Datasphere

[MayuraNalawade]

Hello SAP Community,

I am currently working in SAP Datasphere and need assistance regarding applying a hierarchy on a non-key attribute in a dimension table.

Objective:
I would like to apply a hierarchy on the ECONOMIC ACTIVITY attribute (which contains NACE codes) in the PARTY dimension table.

My Setup:

• I have a local table named PARTY, where:

  • PARTY_ID is the primary key

  • ECONOMIC ACTIVITY (technical name: ECNMC_ACTVTY) is a regular attribute (not a key)

• I have created a separate NACE Code Hierarchy table, with semantic usage set as "Dimension with Hierarchy Directory"

  • The hierarchy is defined using standard parent-child relationships

• I also created a hierarchy directory dimension to represent the NACE code levels, and associated it with the ECONOMIC ACTIVITY field in the PARTY table via a text/association mapping

In the Analytic Model:

• The Analytic Model is built on top of a FACT table

• The FACT table is joined to the PARTY table using RELEVANT BUSINESS PARTNER ID → PARTY_ID

• The join is working as expected, and the RELEVANT BUSINESS PARTNER ID node exposes dimensions from the PARTY table, including ECONOMIC ACTIVITY

• However, the hierarchy is only available or shown on RELEVANT BUSINESS PARTNER ID, and not on ECONOMIC ACTIVITY

Question:
Why is the hierarchy not appearing for ECONOMIC ACTIVITY in the Analytic Model? Am I missing a step in exposing or enabling the hierarchy on a non-key attribute? Or is it the case that hierarchies in SAP Datasphere are only supported for primary key fields in dimension tables?

Any clarification or guidance would be greatly appreciated.

Thanks,

Mayura