Correct mapping guide

ankulkarni
ankulkarni
in Integrations and extensibility

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 

Tagged:

Answers

  • einas.ibrahim
    einas.ibrahim

    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. 

  • fuvasm
    fuvasm

    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!

  • Jitendra.Vishnolia
    Jitendra.Vishnolia

    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

  • ankulkarni
    ankulkarni

    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

     

  • einas.ibrahim
    einas.ibrahim

    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

  • ankulkarni
    ankulkarni

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

    Thanks Einas!

Categories