Efficient way for handling large parent child hierarchies

Highlighted
Occasional Contributor

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?

1 REPLY 1
Highlighted
Master Anaplanner/Community Boss

Re: Efficient way for handling large parent child hierarchies

@a7r2 

 

I would recommend you go through these great articles

 

1. Hub Model Hierarchy Management

https://community.anaplan.com/t5/On-Demand-Courses/Hub-Model-Hierarchy-Management/ta-p/54530

If you are manually flattening/transforming the hierarchy, this would be an essential read. It can be done within Anaplan reducing the manual efforts that you put in transforming.

 

2. Data Hub - Peaks and Performance

https://community.anaplan.com/t5/Best-Practices/Data-Hubs-Purpose-and-Peak-Performance/ta-p/48866

This is about more on best practices.

 

Can you please share more details on how many hierarchies are you pulling from source system and what is that you are doing in transformation. What is your expected output to Anaplan? Small example can surely help.