SAP HANA Calc View analytical previlege

[Former Member]

Hello Experts,

  We have created graphical calculation view of type CUBE and then created analytical privilege to restrict data by country.  Users are getting errors as not authorized for view.  But we don't restrict by country then it works fine for the same user.  Just to prove the concept we created analytical view with same tables and created analytical privilege to restrict by country it works perfect.

  We are using HANA SPS 97.  Any help would be appreciated.

Thanks

Mohan

[former_member183326]

Hello Mohan,

Have you tried running a trace on the request when the error appears?

http://scn.sap.com/docs/DOC-68108 Here you can see how to run the trace.

You can then also find out what privilege the system is saying the user needs.

BR

Michael

[Former Member]

Hi BR,

  Thanks for the response.  Yes we have enabled the trace and see we are getting the following error even though we have granted access.  We are seeing the issue only when we do "Attribute Restrictions" in calc view.  If we do same restriction in Analytic View then no issue.

  I also gone through the "show authorization option" we are not seeing any thing is missing from this.

Here is the error from Tableau:

[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;258 insufficient privilege: [2950] user is not authorized :

Trace log from HANA:

AP ObjectId(24,2,oid=236818): Not granted.

[1849]{412790}[104/-1] 2015-12-01 17:49:19.384575 i TraceContext     TraceContext.cpp(00827) : UserName=BILLING1

[1849]{412790}[104/-1] 2015-12-01 17:49:19.384563 i Authorization    XmlAnalyticalPrivilegeFacade.cpp(01301) : UserId(5617254) is missing analytic privileges in order to access _SYS_BIC:SD.BIlling/BILLINGITEM(ObjectId(26,0,oid=327231)). Current situation:

AP ObjectId(24,2,oid=57): Not granted.

AP ObjectId(24,2,oid=236818): Not granted.

[1849]{412790}[104/-1] 2015-12-01 17:49:19.384589 i Authorization    ceAuthorizationCheckImpl.cpp(00423) : AuthorizationCheckHandler::isAuthorizedToSelect (AP check on CalcScenarioDS): User UserId(5617254) is not authorized on _SYS_BIC:SD.BIlling/BILLINGITEM (-1) (main view: _SYS_BIC:SD.BIlling/CV_BILLING (-1)  due to XMLAP check

[1849]{412790}[104/-1] 2015-12-01 17:49:19.386434 i Authorization    XmlAnalyticalPrivilegeFacade.cpp(01301) : UserId(5617254) is missing analytic privileges in order to access _SYS_BIC:SD.BIlling/BILLINGITEM(ObjectId(26,0,oid=327231)). Current situation:

AP ObjectId(24,2,oid=57): Not granted.

Thanks

Mohan

[rindia]

Hi Mohan,

Your thread is almost a month end. Hope you might resolved by now.

ObjectId 57 refers to _SYS_BI_CP_ALL. Generally this will not be given to end users?

Check the objectid 327231 and give required access.

You can check this by:

SELECT * FROM OWNERSHIP

WHERE OBJECT_OID IN (57,327231);