Level 3 Sprint 1 Import

Its regarding Level 3: Sprint 1 : User Story says " Import the Financial Forecast data from the Level 1 FP&A model" I have used the "Baseline+Financial+Forecast.csv" file. I am struggling with the import mapping "Time" and "Baseline Financial Forecast" portion. I keep getting failed errors regarding date format and/or Invalid line item identifier"

Can anyone help me to identify if the mappings given in the image are correct?

Any help would be appreciated!

Thanks,

#Level3

Level_3_Sprint_1_125694.PNG

Accepted answers

Vinay VaradarajM

Hi @DominickG ,

In this case, your import file has time data in YY-MMM format, where as the system accepts MMM YY (Match names as default).

You have the following options to successfully import the file:

1. Change the time data in your file to MMM YY format

2. Select custom fixed-position pattern (screenshot below), if you would like to use the existing time format in your file

Best Regards,

vinayvm

All comments

Vinay VaradarajM

Hi @DominickG ,

In this case, your import file has time data in YY-MMM format, where as the system accepts MMM YY (Match names as default).

You have the following options to successfully import the file:

1. Change the time data in your file to MMM YY format

2. Select custom fixed-position pattern (screenshot below), if you would like to use the existing time format in your file

Best Regards,

vinayvm

DominickG

Thanks for the input - I was able to apply the advice and successfully import the file!

@Vinay VaradarajM

Wangyandi

i triedYY-MMM format , but it seems failed

Quick Links

Can you help?

Unanswered questions

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…