Skip to Content

UJO_READ_EXCEPTION_018 on refreshing the sheet

Hello,

I am getting the UJO_READ_EXCEPTION_018 error on refreshing the sheet. This is creating a problem in only 2 sheets where year.INP is selected. In all other sheets(where year.TOTAL is selected) I am able to refresh the reports. The error details are MDX statement error : value for 2017.INP 0HIER_NODE for characteristic /CPMB/xxxxx unknown.

Also the problem exists only in excel 2010. If the same report is refreshed in Excel 2016, it is working fine. I am using EPM SP 25 patch 2. Does the problem exists due to the excel version or due to any other reason.

Note: No upgradation/Changes has been done in the system.

Thanks in advance

EDIT 1:-

Screenshot for Time hierarchy in BW

Screenshot of PARENTH1 from BW

Regards,

Bharadwaj.

capture.png (19.9 kB)
capture.png (49.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 16 at 08:11 AM

    Please provide a detailed screenshot of administration of your TIME dimension!

    Add comment
    10|10000 characters needed characters exceeded