nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Import complete with failures

SAtrane

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.

E5 import complete but with failures.PNG

Accepted answers

HimanshuRaj

Hi @SAtrane

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!!

HimanshuRaj

Hi @SAtrane

Can you also share the mapping tab screenshot

All comments

HimanshuRaj

Hi @SAtrane

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!!

SAtrane

Hi @Himanshu1998

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

HimanshuRaj

Hi @SAtrane

Can you also share the mapping tab screenshot

andrewtye

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.

SAtrane

hi @Himanshu1998

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

SAtrane

hi @andrewtye

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.

HimanshuRaj

Hi @SAtrane

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!!

SAtrane

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

Recommended Design for Determining Whether a Source Combination Exists in a Target List
Hello Anaplanners, I'm looking for advice on the best modeling approach for a DCA use case. Scenario I have an input module called "CC-Account Activation". It is dimensioned by: Cost Center (CC) Account Users can select an Activate? boolean to indicate that a Cost Center / Account combination should be activated. I have a…
Anaplan XL Forms Error
Does anyone also get this error when opening the Forms in Anaplan FCR? I am downloading Investment Registry from the app but I cannot open it in Anaplan XL. How did you fix this issue?
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…