3509763 - Unable to View GL Hierarchy data in Analytical Model

While trying to build an Analytical Model, which includes GL hierarchy data, "Data Preview" fails after selecting the Hierarchy value with the error:

"The query executed with errors. The hierarchy doesn't exist".

Following external blogs were followed while building the Analytic Model:

• https://community.sap.com/t5/technology-blogs-by-members/create-sap-s-4hana-external-gl-account-hierarchy-within-sap-datasphere/ba-p/13692445
• https://community.sap.com/t5/technology-blogs-by-sap/guide-create-sap-s-4hana-external-gl-account-hierarchy-within-sap/ba-p/13574648

SAP Datasphere

The Hierarchy is inconsistent. "Data Validation" for this Hierarchy with Directory entity fails due to invalid Keys and Hierarchies settings.

Hierarchy has been violated below rules:

• For Keys: Unique Key Values
• For Hierarchies: No Multiple Parents

Identify and delete inconsistent duplicate records as well as records referencing nodes with multiple parents.

analytic model, hierarchy, duplicates, keys, rules, multiple parents, data validation , KBA , DS-MD-AM , Analytic Model , Problem