Skip to Content
avatar image
Former Member

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

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

auth.png (100.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jun 30, 2017 at 01:39 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Erdem Pekcan

      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!

  • Jul 01, 2017 at 07:34 AM

    Hi,

    To test authorizations, you can execute t.code RSECADMIN --> Analysis-->Execution as user --> Enter user. With this, you should be able to simulate before-hand the auth. checks an end-user may encounter.

    About the auth. errors you are facing, please check the values maintained for objects RSINFOAREA,RSINFOCUBE etc. You can do this via t.code PFCG --> Role --> Authorizations-->Display Authorization data. Once in the "Display Role :Authorizations" screen, go to Utilities->Technical Names On. This will give you tech. names of auth. objects ( eg.S_RS_COMP that you are seeing in your current screen shot). Now check for relevant auth. objects. Please note activity 03 is for display, 06 for Delete etc. You can click on the spectacles icon to see other options. No go ahead and give relevant activities' auth.

    Once done, do not forget to activate the profile !!

    Regards

    Atul

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 03, 2017 at 05:26 AM

    Hi,

    Do you know how to use PFCG or RSECADMIN? If not , just present your error to your BASIS or AUTHORIZATION team to help you fix it.

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 03, 2017 at 03:12 PM

    Dear All,

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

    Many thanks for all of your support!

    Thanks,

    Ajantha.

    Add comment
    10|10000 characters needed characters exceeded