HANA VIEW + BO WEBI ERROR

[former_member280546]

We are getting the following error while trying to consume a HANA view through WEBI.

It was working just fine and all of a sudden we are getting the error. Everything is fine in the HANA side, I can execute a data preview normally.

"ErrorCode: 256 Description: sql processing error: Error occurred while executing a MDX statement. The error message is: Cube VIEWNAME could not be found. Please check if the Cube is valid and exists. The detail error message: Failed to insert entitycache VIEWNAME Source: (Error: INF )."

[philprentiss]

Hi Filipe, I am facing a similar problem. I found the issue is addressed with SAP Note 2423003 - SAP HANA SPS12 Database Maintenance Revision 122.07. This option is not possible for us at this time so I will continue looking for alternative solutions. Please let me know if you find, or have found, any.

Thanks,
Phil Prentiss

[former_member204374]

Check HANA Model and ensure all the dimension view in the Star Join has a primary key mandatory.