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.