Efficient way for handling large parent child hierarchies
Hi, I am looking for an efficient way to handle undetermined parent-child hierarchies coming from an ERP system.
This is the challenge: I have about 35 local cost center hierarchies from different ERP systems, all with different number of levels, and extracted with parent-child-IDs.
How can I bring this efficiently to Anaplan?
Following the Anaplan Data Hub model, I would first transform them (externally) into level-based hierarchies, load all of them in separate lists, then recreate the views in a separate target workspace.
Beside the fact that this is quite cumbersome, it brings new questions, such as how to handle changes in the amount of hierarchy-levels year on year.
Is there a better way to do this?