Import complete with failures

Hello everyone,
I'm in need of assistance with a problem I'm facing. I have a module where I enter data (Product, Quantity). Everything was fine until I used the time dimension(Periode, Product and Quantity). However, the results are not accurate. Instead of giving me the quantity of Product X in January, it gives me the total : sum quantity of all products in January. I have already changed the summary to "none," but the issue persists. Please refer to the attached picture for more details.

Thanks in advance.

E1 Data Importation.PNG

E2 Mapping.PNG

E3 Time.PNG

E4 line items.PNG

E5 import complete but with failures.PNG

E6 result.PNG

E7 summary none.PNG

Tags

Accepted answers

It is because of your time mapping, you are using "Janv-23" and asking anaplan to map it to "M-Y" format.

Anaplan can map "Jan-23" to "M-Y" format. You need to remove v from your time list.

Cheers!!

Can you also share the mapping tab screenshot

All comments

It is because of your time mapping, you are using "Janv-23" and asking anaplan to map it to "M-Y" format.

Anaplan can map "Jan-23" to "M-Y" format. You need to remove v from your time list.

Cheers!!

Hi @Himanshu1998

I followed your recommendation, but unfortunately, it didn't resolve the issue. I have attached some pictures for further clarification.

E8 Error.PNG

E8 import complete.PNG

E8 import data.PNG

E8 time.PNG

Can you also share the mapping tab screenshot

Hi @ - decimel separator? Should be dot not comma I would think.

Also what does the file look like before loading? It might be to do with how anaplan is seeing the data.

hi @Himanshu1998

Attached is the mapping table screen you requested. However, the problem still persists.

E8 MAPPING.PNG

Thank you for your response. I believe the source table may not be the issue as it is an Excel file that I converted to CSV format.

Have you changed the time mapping tab settings here? Language to francais? This could possibly be causing issue. You should reset it back to english(or what it was earlier) and then try again

Cheers!!

Hi @Himanshu1998

I followed your recommendation, but unfortunately, the probleme still persist. I have attached some pictures for further clarification.

Quick Links

Can you help?

Unanswered questions

3.4.3 Activity: Create Country Summary Module
Hi, I have a doubt in level 2 sprint 3.4.3 Activity: Create Country Summary Module I did the following :- Step 1 → Created a new column "Country Made in" in SYS08 SKU details Step 2 → Wrote a formula Parent(Supplied By) to bring parent of the location i.e. country in "Country Made in" column Step 3 → I have written the…
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.…
Top-Down Allocations
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…