Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error message in Hana Studio calculation view when doing Data Preview

Hi Experts

We are getting a strange error message in Hana Studio when we use the “Data Preview” functionality on certain objects in a calculation model (VDM). The error message is:

Cannot open Data Explorer

SAP DBTech JDBC: [321] (at 21): invalid view name: home.bi.co.projcash/FACT_COFP_VBAK/dp/Projection_1: line 1 col 22 (at pos 21)

If we use the “Data Preview” functionality on the objects “Aggregation” or “Semantics” everything work as expected. But, if we use the “Data Preview” functionality on any other objects like “Projection” or “Join” we get the error message above.

Is this an error or does this has something to do with authorisations? Our Hana system is newly installed system and the authorisation setup is also new.

Kind regards

Erik

Tags:
replied

Hi Erik,

You are missing privileges. Try to get SELECT and EXECUTE on _SYS_REPO schema. That should work.

Regards,

Chandra.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question