Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos

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


Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

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