3500847 - How to restore the dimension hierarchy with a custom member order in BPC

In system A, the hierarchy of a dimension is maintained with a custom order for the members in the same level. For example:

TOP_ENTITY
--ENTITY_B
----Z123
----A123
----B123
--ENTITY_A
----C5
----C3
----C1

It is expected to have the exact same hierarchy in another system B.

Note that if you only copy paste the values of the PARENTH1 column from system A to system B, the hierarchy of this dimension in system B would follow the alphabetical order as below:

TOP_ENTITY
--ENTITY_A
----C1
----C3
----C5
--ENTITY_B
----A123
----B123
----Z123

Read more...

• SAP Business Planning and Consolidation, version for SAP BW/4HANA
• SAP Business Planning and Consolidation, version for SAP NetWeaver

SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver ; SAP Business Planning and Consolidation 11.0, version for SAP BW/4HANA ; SAP Business Planning and Consolidation 11.1, version for SAP BW/4HANA ; SAP Business Planning and Consolidation 2021, version for SAP BW/4HANA

EPM, BPC  NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, BPCNW, Embedded, standard, classic, unified, BOPC, sequences, sequence, hierarchies, recover, BW, alphabet, customized ordering, backup, pre-defined order, predefined, defined , KBA , EPM-BPC-BW4-MOD , BPC/4 - Modeling , EPM-BPC-NW-ADM-DIM , Dimension Management , Problem