Issues with L1 8.5.3 data download

Have gone through this several times.

Have changed current date in the Time list to 20209Have tried with date set at 2019 as well), in mapping have source as Column Headers -> Time, Fixed Item Location->G3 location, Fixed item P2 Products->P2 products, Fixed line item.

Row and Column are adjusted to 2 and 3.

Time is listed as Periods yyyymm, Location all regions, Products all products, Volume/Inputs as Volumes.

In Module I have Time Scale= Month and Time Range= Model Calendar

Still I get error message as "expected 4 digits in year".

1.png

2.png

3.png

Accepted answers

AjayM

Hi @MPWall ,

Did you have a look at the error records, from the 'Details' tab? The mistake lies not in your time mapping, but in the other two dimensions.

Why have you fixed both G3 location and P2 products in the mapping to their respective top levels? If you do so, Anaplan will try to load the data against top level and fails/ignores to load at each individual location and product level. Please try remapping these two dimensions to respective source columns in the file (Product Code, Location Code).

Cheers!

All comments

MPWall

I did read all posts about 8.5.3 data download issues and have tried all things suggested.

Thanks,

MPW

AjayM

Hi @MPWall ,

Did you have a look at the error records, from the 'Details' tab? The mistake lies not in your time mapping, but in the other two dimensions.

Cheers!

MPWall

AjayM, It was that and number seperator should have been comma which I am not sure why it was switched.

Thanks,

MPW

Quick Links

Can you help?

Unanswered questions

Hi Team , I am unable to login to the Anaplan portal using my credential.
Can someone help me i am unable to login anaplan portal using my credentials
Finding History for List Item Creation and changes
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
Action fails via cloudworks but works manually
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made to…