Highlighted
New Contributor

Import between alternate hierarchies

Hi,

 

I have the below hierarchies as follows

 

Product Hierarchy:

P1 Product

P2 SKU

 

Country Hierarchy: 

R1 Region

R2 Country

 

Alternate SKU Hierarchy:

R1 Region

R2 Country

R3 SKU

 

Both R3 SKU and P2 SKU are numbered lists.

 

I have the below modules:

Module 1 with dimensionality  R3 SKU,Scenario and Time and a line item 'test'

Module 2 with dimensionality P2 SKU,L2 Country,Scenario and Time and a line item 'test'

 

Is it possible to set up an import from Module 1 to Module 2 to import the values for test.

 

4 REPLIES 4
Highlighted
Super Contributor

Re: Import between alternate hierarchies

Hi @BahalR,

 

Yes it is Possible.

 

Point 1: Make sure that, the code for P2 SKU and R3 SKU are same.

 

Point 2: L2 Country is a addon Dimension in Module 2. You can either select Fixed item or Ask each Time import is run -> based on your requirements.

 

Capture.JPG

 

 

 

 

Capture1.JPG

 

Capture2.JPG

 

 

Capture3.JPG

 

Capture4.JPG

 

 

Hope it Helps,

 

Sorna Raja Prabhu
Highlighted
New Contributor

Re: Import between alternate hierarchies

the code for P2 SKU and R3 SKU are different. Is it still possible to set up an import?

Highlighted
Super Contributor

Re: Import between alternate hierarchies

Hi @BahalR,

                 The Best part of Code is - even if the List item name is different but code are same, then mapping happens automatically in Anaplan.

                 Code Represent a single unique entity, But this entity can be called by different names -> here in your case P2 and R3 SKU.

                 

                 If the code is not same, Mapping won't happen and you have to do manual work (Doing Manual Work is not the best approach).

 

You can read this article  https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Lists_and_Roll-ups/Numbered_Lists/...

 

 

Sorna Raja Prabhu
Highlighted
Community Boss

Re: Import between alternate hierarchies

@BahalR 

 

Code has to be there in numbered list items. It gets really difficult to play with numbered list if you don't have a unique code. Please revisit the article shared earlier by @Sorna Raja Prabhu