Account Hierarchy Sorting Issue During ERP to EPM Integration
Above is the issue identified during the integration of the Account Hierarchy from ERP to EPM. In ERP, the hierarchy is maintained in a specific (non-alphabetical) order. However, during integration with the EPM application, the hierarchy is being converted to alphabetical order.
Based on my testing, it appears that the extraction job in ERP i.e., "Extracts General Ledger Cubes Members" is changing the order of the hierarchy to alphabetical. If this is the case, I would like to know how we can restrict or control the sorting order at the extraction stage to preserve the original hierarchy structure.
Please advise on the available options or configurations to address this.