Skip to Content
avatar image
Former Member

Error when importing IBP key figure data at aggregated level

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    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.

    Thanks,

    Rohit

    Add comment
    10|10000 characters needed characters exceeded