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.

 

Tagged:

Answers

  • 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,

     

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

  • 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/Working_with_Numbered_Lists.html#Import%20-%20Code

     

     

  • @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 @prabhu