There are peculiar cases like mergers or acquisitions when the Master Data of the company changes. Name and/or Code gets changed in the source system, and you want to update the hierarchy with these new details in Anaplan without creating new entries —which will increase the model size exponentially. We also want to make sure that the data isn't affected due to this exercise. 

The below article will explain how these cases should be handled effectively. Here a simple two-level hierarchy has been taken into consideration, i.e., SKU -> Brands

Current State: This is how your hierarchy looks like in Anaplan as of now.

Misbah_0-1582210788973.png

Future State: This is how it should look like in Anaplan (Due to Changes in Source System) – Both the Name and Codes have been changed in the source system and the same should be reflected in Anaplan.

Misbah_1-1582210789061.png

Step 1: All you need is the mapping between the Old Name & New Name and Old Code & New Code – Sample like below. This information can be put into one file or multiple files. Remember this will be a one-time effort and once the change is implemented you would need only three columns i.e., New Name, New Code & Parent.

Misbah_2-1582210789070.png

Step 2: Replacing the Codes—Create an Import and map “New Code” from the source file to “Code” of the list keeping everything else same. Check “Items uniquely identified by – Name only”. This will  match the Names within Anaplan with the Source file replacing the Codes associated with the corresponding Names.

Misbah_3-1582210789197.png

As you can see in the below screenshot nothing got created and 6 got updated.

Misbah_4-1582210789241.png

Misbah_5-1582210789250.png

Step 3: Replacing the Names—Perform the same exercise that we did in Step 2 but this time edit the import by mapping “New Name” from source file with “Name” of the List. Check “Items uniquely identified by – Code only”. This will  match the Codes within Anaplan with the Source file replacing the Names associated with the corresponding Codes.

Misbah_6-1582210789262.png

As you can see in the below screenshot nothing got created and 6 got updated.

Misbah_7-1582210789268.png

Misbah_8-1582210789275.png

Data before Hierarchy Change 

Misbah_9-1582210789281.png

Date after Hierarchy Change  

Misbah_10-1582210789291.png

There can be scenarios when only Codes Change and Names remain the same – in this case, you only need to take Step 2 and in other scenarios where Names Change and Codes remain the same then you only need to take Step 3.

Note: All these hierarchy related changes are to be done within Data Hub. This article just demonstrates the best practices – and to show that there is no data loss or any impact on model size (Which could have been possible had we inserted new items into the hierarchy).

0 Kudos
Contributors
Latest Articles
Refinancing Calculator
Content Sandbox
a week ago
by Stan
02-20-2020
by Misbah
[IN REVIEW] Tier Pricing
Content Sandbox
02-19-2020
Labels (1)