Skip to Content

Error when importing IBP key figure data at aggregated level

Aug 25, 2017 at 02:35 PM


avatar image
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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Rohit Ranjan
Aug 28, 2017 at 10:30 AM

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.



10 |10000 characters needed characters left characters exceeded