Skip to Content
avatar image
Former Member

IBP Excel : No time data. Ask your administrator to check the planning area configuration

Hello Team,

I have created time profile, generated time periods, master data, planning level, key figures and activated as per the model config document.

But when i try to login into excel add in to view my planning area. It gives me below error message. I have generated time periods through the application job.

No time data. Ask your administrator to check the planning area configuration.

I have created a new planning area in that too i am getting the same error. Please help to resolve the message.

I have checked the previous incident on the same issue.(https://archive.sap.com/discussions/thread/3529395)

there are no discrepancy in my time periods. Time periods attached for reference.91-template.txt.

Regards,

Harshad

91-template.txt (361.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 27, 2017 at 11:16 AM

    Dear Harshad,

    One possible root cause for this issue is value for parameter MAX_DIM_MEMBERS in Global Configuration Parameter. Please make sure no commas or dots are defined, e.g. '20,000'. It should contain the value without any commas or dots, i.e. '20000'.

    If issue persists, please attach the Time Profile .csv file instead of .txt file. It is easier to analyze in our side.

    Best regards,
    Matheus

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Harshad,

      Thank you for confirmation!

      As .csv files cannot be uploaded and this would facilitate to analyze it, I'd suggest you to create an incident with SAP Product Support under component SCM-IBP-INT and attach the .csv file in there.

      Best regards,
      Matheus