L2 Model Building - Sprint 1 - 1.4.3.1 Create SYS12 SKU Details Module

Hello, I am stuck on this: when importing the CSV file to populate the newly created above module I got an error I'm struggling with.

This is the SYS12 SKU Details Module created as requested in the training exercise:

this is the CSV file to import

this is the message I got after importing the file

It seems that the codes into the CSV file I'm importing are wrong despite the flat lists "Products Flat" and "Location Flat" are already populated with the same codes:

Unless the flat lists are incorrectly populated…
Could someone help me understand what I'm doing wrong?

Many thanks in advance!
Luca

Accepted answers

Dikshant

IN SYS12 Line Items tab, you can unmap the product code mapping. As You can make it formula-driven, like PARENT(ITEM('P3 SKU'))

All comments

Dikshant

Module does not have SKU dimension. Add the dimension from here:

LucaB

Thank you! I added the missing dimension.
However, I'm still having an issue with probably doing something wrong in the import:

My mapping seems fine:

but I do not understand why the Location code "lands" in the Product field and the Product code into the Location field.

Thanks

Dikshant

IN SYS12 Line Items tab, you can unmap the product code mapping. As You can make it formula-driven, like PARENT(ITEM('P3 SKU'))

LucaB

Thank you

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
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.…