PeriodID missing for key figure date

[Former Member]

Hi,

I am geting the error 'PERIODID is missing for the KEYFIGUREDATE provided'

TIme profile data is uploaded without any error.

I tried uploading a file with jus one record and for that record I copied the date from the time profile file, still getting the same error.

Attaching screen shots of time profile and KF file.

Kindly guide me.

KF

Time Profile

[Former Member]

Hi,

I think problem is due saving in CSV file format.

whichver format i use

YYYY-MM-DD

yyyy-mm-dd hh:mm:ss

while saving i get a pop sayin some format might be lost due to csv.

After saving -> closing -> reopening file ->format is lost.

[Former Member]

Hi,

For the key figure file,the correct Date Format is YYYY-MM-DD,save the file as CSV and close.It seems you are using Excel to read/write the file,please use editor like Notepad/Notepad++ for making changes and save.

Regards

Avijit

[Former Member]

Hi Avijit,

Tried your suggestion.

But opening in notepad/wordpad shows garbage data.

Also I need to mention that I was able to upload same data in IBP 4 without any hassle but getting period id error in IBP 5

[former_member123657]

Hi Prabha

Please open a css message and provide all the details.

VIvek

[Former Member]

Thanks Vivek.

We tried one more thing which resolved the error.

As in IBP5, SAP3 is defined at  Daily weekly and monthly level, we created time profile file for daily weekly so on and uploaded it and then uploaded the KFs, we were able to do  it successfully.

Till last week we were working on IBP4 in which SAP3 was at weekly, monthly level. Hence we continued with the same files on IBP5 too. We didn't get any error when we uploaded the time profile file with weekly n monthly data. So thought omitting daily data is not an issue.

But a new problem has cropped up now. After uploading the time profile and KFs in IBP5 successfully, when we tried loggin into the excel addin we get an error saying

'Bad request. Cannot get data for the time bucket'

Any suggesstions?

Prabha

[Former Member]

Hi Prabha,

The error - "PERIODID is missing for the KEYFIGUREDATE provided" comes when the keyfigure date provided in the CSV file doesn't falls in the range of the Time Profile selected in the Planning Area for which upload is being done.By going through the screenshot you have provided,it looks OK.But are you sure the same time profile has been uploaded to the system and not any other file.Is it possible for you to upload the time profile once again and then try uploading KF data.

Regards

Avijit

[former_member123657]

HI Prabha

sometimes the date format is lost with excel csv file.

see if this helps

highlight the date format in the KF file and format the cells as custom.

the format being YYYY-MM-DD

save and retry.

[Former Member]

Thank you vivek for the prompt response

Tried both formats

yyyy-mm-dd hh:mm:ss

yyyy-mm-dd

still getting the same error