Unable to do data preview in Calculation view

[former_member185181]

Hi,

I am building calc view with projections on BSIK and BSAK table. I am doing an union of these 2 tables and joining further with star join. I am able to do data preview on star join, however doing it on union node or projection node doesn't work. Also, I am not able to do data preview on any HANA live content views delivered with simple finance addon. for example,

AccountsPayableCashDiscountForecastQuery

I have already executed GRANT SELECT/EXECUTE ON SCHEMA SAPHD to _SYS_REPO;

[vivekbhoj]

Hi Ananda,

Do you have  SELECT access on _SYS_BI schema and do you  have the required analytic privileges?

As the error says - invalid view name, Is your view activated successfully?

For more details, you can use Show Authorization option in HANA.

For that just go to _SYS_BIC schema and select your view in Column Views and R-Click on it and the select Show Authorization.

It would show you your missing privileges.

Regards,

Vivek