Skip to Content

Getting authorization issue in SAC while running BPC queries via BPC live connection from SAC

We are having couple of queries on top of SAP BPC DSO in embedded BPC.

We are able to execute the query successfully in on premise BW system .We are trying to execute the same from SAC via BPC live connection with customized security role. We are getting the authorization issue .

It is executing successfully with 0BI_ALL/SAP_ALL which we can not give to the end user.

Error is shown as below.

The table failed to initialize: Server Error: Error [Server]: Fatal Runtime Exception occured; MsgClass: ;; OlapMsgClass: 0; Error [Server]: (#800) You do not have the authorization for component ZXX_ZZXXXXX_Q001; MsgClass: BRAIN;; OlapMsgClass: 0; Warning [Server]: (#1) EYE(001): You do not have sufficient authorization for the InfoProvider ZZXXXXX; MsgClass: ;; OlapMsgClass: 0;

Kindly share your thoughts on to resolve this issue.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Oct 17 at 10:04 PM

    What does the SU53 say? Did you run an STAUTHTRACE? I would try looking at the S_RS_COMP/1 Auth objects to see if you have granted the auth for this Infoprovider.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.