3620301 - Hierarchy nodes preview are out of sequence in SAP Datasphere

• Analytic Model Preview does not reflect the hierarchy order like in the source (S/4HANA CDS View).
• The order of nodes is not matching what is expected from source.

• SAP Datasphere

1. Access the Analytic Model
2. Set the variables (if necessary)
3. Add the dimension which has the Hierarchy association to the Rows
4. Activate Hierarchy on that dimension
5. Observe that the hierarchy node sequence is not the expected one, compared to the source system

In SAP Datasphere, siblings order can be configured using a Custom CSN Annotation, if the SAP S/4HANA Hierarchy CDS Views extracted via Replication Flows. 
Please follow Order Siblings in a Hierarchy with Directory with SAP Datasphere | SAP Community.

• Create a Hierarchy with Directory | SAP Help Portal
• Modeling a basic Hierarchy with Directory in SAP Datasphere | SAP Community
• An Introduction to Hierarchy with Directory in SAP Datasphere | SAP Community
• Order Siblings in a Hierarchy with Directory with SAP Datasphere | SAP Community

hierarchy node sequence, sap datasphere, AM model, hierarchy order, error 2120042, unexpected error, sequence number, PL reporting model, analytical model, data builder, hierarchy activation, hierarchy node expansion, wrong order, out of order, scrambled, mixed, shuffled , KBA , DS-MD-VIW , Views , DS-MD-AM , Analytic Model , Problem