Error when importing IBP key figure data at aggregated level

[Former Member]

I'm trying to use the IBP WebUI option to load key figure data at an aggregated time bucket, yet I continue to get an error that the time format is invalid. Here is a sample of the data I'm attempting to load at the Year level:

KEYFIGUREDATE,LOCID,SOURCEID,PRDID,PRODUCTIONCOSTRATE 2017,CO,00316754_AAA1_0001,316754,0.12 2018,CO,00316754_AAA1_0001,316754,0.12

I've looked at other comments regarding date formating, and they only reference YYYY-MM-DD. I tried using that format, but it did not work either. Is there a trick to specifying the yearly timeperiod?

[former_member242371 · Accepted solution]

Hello Rob,

You need to maintain the date in YYYY-MM-DD format only. To load the key figure at aggregated level, just select time profile level as yearly from the drop down. System will then load the data at year level and store it at base planning level of the key figure using dis aggregation mode.

Thanks,

Rohit