Skip to Content

SAP HANA SQL insufficienet privilege 2950 User is not authorised

Hello experts ,

Need your help please.

We have a model that has hierarchies for Cost centre and Cost element in it . When I try to run a webi report on top of this model with test user id , this is throwing error message , however the same user id can run the report on a model that has no hierarchy in it . So just wondered what else we are missing in the authorisation for the test user Id ?

Error occurred while executing a MDX statement.
The error message is: An internal error occurred. Assertion failed with error message Hierarchy cache reference is invalid for [COST_ELEM].[COST_ELEM] : Hierarchy cache error:Hierarchy create error for "_SYS_BIC"."PK_FIN/CA_Q_FIN_HIER/COST_ELEM/hier/COST_ELEM" error: SQL: insufficient privilege: [2950] user is not authorized :

Add comment
10|10000 characters needed characters exceeded

  • Did you check what privileges the user has for the model for which the execution fails because of the auth. error? To check this would be the first step in your analysis.

  • Get RSS Feed

0 Answers