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
Screenshot for Time hierarchy in BW
Screenshot of PARENTH1 from BW