Insufficient privilege while data preview

[Former Member]

Hi Experts,

While clicking on data preview of calculation view. I am getting below error.

    SAP DBTech JDBC: [258]: insufficient privilege

I have select & execute access for BW package as well as for _SYS_BIC.

I also tried below sql commands too. But still getting privilege issue. Please help me what I am missing here. I am in BW on HANA 7.5.

GRANT SELECT ON SCHEMA "_SYS_BIC" TO _SYS_REPO WITH GRANT OPTION

GRANT SELECT ON SCHEMA "SAPXXX" TO _SYS_REPO WITH GRANT OPTION

Thanks,

Saravanan.

[Former Member · Accepted solution]

The issue is with Analytical Privilege. We changed to Classical Analytic Privileges in calculation view properties to fix the issue.

[former_member746118 · Accepted solution]

I was trying to access ADSO table in my calculation view and was getting below privilege error while doing data preview. When i changed to classic privilege in property. it worked.