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.

[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