Import between alternate hierarchies

BahalR

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.

 

prabhu

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.

 

 

 

 

 

 

 

 

 

 

 

Hope it Helps,