Skip to Content

UJO_READ_EXCEPTION_018 on refreshing the sheet

Feb 16 at 08:05 AM


avatar image
Former Member


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



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

Looks like you are doing strange things...

I asked you to show BPC admin screen, not BW!!!

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Feb 16 at 08:11 AM

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

10 |10000 characters needed characters left characters exceeded