Correct mapping guide

ankulkarni

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

STEP 2

STEP 3

ERROR

HIERARCHY

Thanks

Accepted answers

All comments

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

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

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

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

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.

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

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

Thanks Einas!

Quick Links

Can you help?

Unanswered questions

How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…