Correct mapping guide

Highlighted
Contributor

Correct mapping guide

Hi,

 

I have created a new list called 'SKU' which needs to be added at the bottom of product hierarchy for SKU's.  

I have denoted the hierarchy and tried importing the data. Can someone please correct what's going wrong. Thanks 

 

STEP 1

ankulkarni_0-1594678166532.png

STEP 2

ankulkarni_1-1594678220414.png

STEP 3

ERROR

ankulkarni_2-1594678358688.png

 

 

HIERARCHY 

 

ankulkarni_3-1594678461267.png

Thanks 

6 REPLIES 6
Highlighted
Valued Contributor

Re: Correct mapping guide

Hi @ankulkarni 

 

“Invalid Parent” error occurs  for every item on the list when you haven’t imported data into the Parent List (P2) in your case 

you have to load data in hierarchical list starting from the top level then go down. 

basically you are telling Anaplan, Load this particular SKU and create a child-parent connection with that parent, however, since the parent list is not populated, Anaplan can’t create that relationship. 

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Contributor

Re: Correct mapping guide

Hi @ankulkarni

 

As parent is not available in your model, Anaplan is not able to map child-to-parent (though you have set mapping rule). Ensure you import parent to your Lists, before importing child members. 

 

Cheers!

Highlighted
Certified Master Anaplanner

Re: Correct mapping guide

Hi @ankulkarni ,

 

There can be 2 reasons to this
1. Ether there is no data into the Parent List (i.e. P2 Products in your case) as mentioned by @einas.ibrahim & @fuvasm 

OR

2. If P2 Products is a numbered list then you need to capture the Code of Parent in the source import file and map the Code of Parent for the import.

 

Hope this helps.

 

~ Jitendra

Highlighted
Contributor

Re: Correct mapping guide

Data is present in all the hierarchy and I was able to apply the formula too

Problem statement:- I did pull data ( volume) from DATAO2 into REV02 module and referencing REV02 module I need to find volume for cities w.r.t product

In this case I want to check FY19 total CHOCOLATES consumed in Japan and I can even filter cities and products but the volume remains unchanged. 

E.g if you see first cell for Jan 19 the volume is 706,982 which is constant for every item. 

 

 

ankulkarni_1-1594745518559.png

 

Highlighted
Valued Contributor

Re: Correct mapping guide

Hi @ankulkarni 

Why do you have a subsidiary view for Volume in your REV02? Fix that, please. If the reason you have this subsidiary view is what I think it is then your issue will be fixed. I can't confirm without looking at the module blueprint

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Contributor

Re: Correct mapping guide

The issue was with one of the dimension which i corrected and was able to solve.

Thanks Einas!