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.

[FCI]

Hi Saravanan,

Try to add a read access to the "_SYS_BI" schema and to the view you're trying to access (you only talked of _SYS_BIC and package authorizations).

Regards,

Frederic

[muthuram_shanmugavel2]

Hi Saravanan,

Is this Calculation View, BW generated Advanced DSO - Calculation View?

[Former Member]

Hi Muthuram,

The calculation view was created based on composite provider of BW Modelling.

Thanks,

Saravanan

[Former Member]

May be this can help you

I think you need to convert the analytic view into a calculation view  for data preview not sure though.

thanks

[muthuram_shanmugavel2]

Hi Saravanan,

Is that Composite Provider have Tables/Views from any External Schema?

and one more try,

Can you please give EXECUTE Privilege too,

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