Bex Query Authorization error - You do not have authorization for the component

[former_member266270]

Hi All,

We have copied a query from one multi provider to another. The query is not executable in Q and P due to below error. Can you please help on the reason why authorization issue appears for the copied query while the original one works fine.

Error - RSRT

You do not have authorization for Execute

You do not have authorization for component

Incorrect call of OLAP layer CL_RSR_OLAP; error in BW-BEX-ET ()

SU53 check:

Bex Query Designer Error:

Errors: Authorization change not available for Query

[erdempekcan · Accepted solution]

Hi Ajantha,

RSECADMIN will give you a better result for authorization check. Can you please try a test run with logs and share the results.

Regards,
Erdem

[former_member266270 · Accepted solution]

Hi Erdem,

Getting empty log in RSECADMIN.

Thanks!

[erdempekcan · Accepted solution]

Hi Ajantha,

Please check the following URL for the instructions of RSRT usage in RSECADMIN.

https://archive.sap.com/documents/docs/DOC-59028

[former_member266270 · Accepted solution]

Hi Erdem,

Thank you for the document link. I followed same steps. Unfortunately, am still not getting any logs,

STEP 1:

STEP 2:

STEP 3: Result after executing the query

STEP 4:

STEP 5:

STEP 6: No Results after returning back.

Post doing this, I also checked if there are any logs in Log administration. There were few but its empty as given in previous reply.

Please let me know if anything is missed. Thanks much!!

[erdempekcan · Accepted solution]

Can you please check the S_RS_COMP assignments of your role? It might be related to a authorization value restriction like InfoArea or InfoProvider.

[former_member266270 · Accepted solution]

Hi Erdem,

The reason for the issue is found. The necessary combination of Infocube and component ID is not assigned for the role.

Thank you so much for your suggestion!