Skip to Content

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

Getting errors while selecting data preview from attribute view.

Hello!

We are trying to demonstrate a big data use case to one of our customer using HANA and SAPUI5. Though we are certain that HANA is more efficient than our current implementation using NoSQL database, we are not able to demonstrate that effectively because of restrictions on access privileges

I created analytic view and attribute view on _SYS_BIC schema. View uses table from _SYS_BIC scheme schema. I am getting errors while selecting data preview

However, if I try to get to the element from select query and

I receive:  Could not execute 'SELECT * FROM "_SYS_BIC"."p1941009112trial.emchana.emc.views/AT_EROLLMENT_STATUS"' SAP DBTech JDBC: [2048]: column store error: search table error: [2950] user is not authorized.SAP DBTech JDBC: [2048]: column store error: search table error: [2950] user is not authorized

I executed successfully

call "HCP"."HCP_GRANT_SELECT_ON_ACTIVATED_OBJECTS"

But this doesn't help.

        Does anyone know what privileges should be assigned to user and how can this be done?

Thanks,

Aniket

Tags:
Former Member
Former Member replied

Hi ,

While defining the views (analytic, attribute, calculation) in hana studio or in eclipse , you just need to disable the Apply Privileges and then you can query the views with out any errors .

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