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

0 Answers