Skip to Content
0

Query works in RSECADMIN but user getting No Authorization Error

Dec 13, 2017 at 04:36 PM

212

avatar image
Former Member

Hello All,

I am facing a strange issue. The user is able to execute query in Analysis for Office and then enter values in variable selections screen but after entering variable values he is getting NO Authorization error. When I tried to execute same query with user's ID using RSECADMIN -> Analysis -> Execution As, The query works without any issue and shows the expected data. User has all required roles assigned to access the query.

What can be the issue here ?

Thanks in Advance.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Frédéric Cincet Dec 13, 2017 at 06:19 PM
1

Hello Rahul,

Do you have any authorization variable of type exit ?

If yes, check that no Sy-uname is used in the code...

Show 1 Share
10 |10000 characters needed characters left characters exceeded

See note 1914703 - Transaction RSECADMIN "Execute as User" has different BW query result compared to direct BW query execution result by this user

1
Loed Despuig Dec 19, 2017 at 07:06 AM
1

Cause

This can happen for below specific situation:

  1. A Customer Exit variable is used in the query definition or user's authorization definition. And:
  2. The Customer Exit coding uses system variable SY-UNAME in the logic to determine the returned value of the customer exit variable.

This is because the value of SY-UNAME is always the logon user (A in this case), even if using "Execute as User B" function. The function "Execute as User" does not overwrite the value of SY-UNAME.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 31, 2017 at 05:53 AM
1

Hi Rahul.

1. You have to use the transaction code either RSECADMIN or RSUDO to check the missing authorization of user A in BW system.

2. Refer the link

https://wiki.scn.sap.com/wiki/display/BI/Authorization+in+SAP+NW+BI

Regards

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 31, 2017 at 02:58 AM
1

Did u check su53?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 21, 2017 at 08:22 AM
0

Thanks for your responses Frederic, Eugeniy and Loed.

Basically one of our user A is getting 'No Authorization' Error while executing one of the BeX Query. We asked for reference user who has the access and able to display report. Compared both users in SUIM and found that both have same authorizations (Roles, Analysis Authorizations, S_RS_COMP/COMP1, S_RS_MPRO etc). reference user is able to access query without issue. but user A is getting no authorization error. He is having access to query it seems as he is able to enter values in variable screen. My assumption is, he is missing authorization to multiprovider data.

What else can be the reason for such error ?

Thank you in advance.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi,

If you have user A and user B who have same access, why don't you try to delete user A then recreate user A in reference to user B? Did you already try it?

Regards,

Loed

1
avatar image
Former Member Jan 11 at 09:26 AM
0

Hi all,

Thank you very much for your responses.

The reason was one of the customer exit used in user's authorization role was restricting users to specific country's data. I assigned the user with worldwide role and now the query is working for him. I am new to Authorization concepts so it took little longer to investigate the issue.

Best Regards,

Rahul Panchal

Share
10 |10000 characters needed characters left characters exceeded