Skip to Content
Feb 16, 2018 at 08:05 AM

UJO_READ_EXCEPTION_018 on refreshing the sheet

513 Views Last edit Apr 17, 2018 at 07:41 AM 7 rev


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)