EPM 10 report Error (BPC on HANA)

[former_member288392]

When I m trying to execute EPM 10 report, somtimes the system throws the following error.

"The execution of the report failed " -  UJHANA_SQE_EXCEPTION_007

  Run SQE HANA Query fail

Attached screen shot of the same.

The error seems to get resolved when i try to process the dimension used in the report and Run UJA_REF_DIM_CACHE ,but it reappears again randomly .

Would like to understand the root cause of the issue if any along with the troubleshooting steps.

Thanks in advance for your help.

Regards,

Sridhar Sundaram

[Former Member · Accepted solution]

Hi,

Does this happen after you did some maintenance on a dimension?

I was able to find this note:

http://service.sap.com/sap/support/notes/1763693

But I am not sure if it is applicable to your situation. If UJ_REFRESH_DIM_CACHE fixes the issue, it looks like somehow the dimension tables are becoming incorrect.

With kind regards,

Tim

[former_member288392 · Accepted solution]

Thanks ..,The issue is resolved