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/orInvalid 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
Solved!去解决方案。
Hi@DominickG,
In this case, your import file has time data inYY-MMMformat, where as the system acceptsMMM YY(Match namesas default).
You have the following options to successfully import the file:
1. Change the time data in your file toMMM YYformat
OR
2. Select custom fixed-position pattern (screenshot below), if you would like to use the existing time format in your file
Best Regards,
vinayvm
Hi@DominickG,
In this case, your import file has time data inYY-MMMformat, where as the system acceptsMMM YY(Match namesas default).
You have the following options to successfully import the file:
1. Change the time data in your file toMMM YYformat
OR
2. Select custom fixed-position pattern (screenshot below), if you would like to use the existing time format in your file
Best Regards,
vinayvm
Thanks for the input - I was able to apply the advice and successfully import the file!