Hana Calculaton View - Dynamic Analytic Privileges : Invalid SQL AP definition

[D039507]

Hi All,

I have a calculation View and a dynamic Analytic Privilege, that is based on a Catalog Procedure. I think everything looks fine, everything is activated. But in the data preview I get the following error message:

Error: SAP DBTech JDBC: [258]: insufficient privilege: Could not obtain all relevant analytical privileges for user WATZKE accessing view ._SYS_BIC.ZTEST.WATZKE/PV_VIEW due to exception: Invalid SQL AP definition

Has anyone an idea what to do?

Best regards

Thorsten

[former_member242627]

In case your calculation view is used from BW reat the following SAP Notes to find a solution

2390443 - BW External SAP HANA Views and Analytic Privileges

2608634 - Invalid definition of structured privilege when use HANA external view for modified composite provider

Comunity: External SAP HANA Views