Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

RRMX for executing and creating queries

Former Member
0 Kudos

Hi,

I have some users which are able only to create queries and another group which are only able to execute them.

Which auth object and values should I consider in order to distinguish these 2 roles?

Thanks and regards

FedeX

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hello, Firstly, may I suggest that the subject is misleading for the question asked.

Transaction RRMX only excute the BEX analyzer add in.

In BI/BW the authorization objects that govern whether the user is authorized to display/ execute / create / change queries are S_RS_COMP and S_RS_COMP1.

Both these objects work in tandem. Where as S_RS_COMP covers the infocube, info area authorizations along with activity and Report IDs, S_RS_COMP1 covers the authorization to execute reports (queries) created by author /Owner (SAP username). example: If the owner field in S_RS_COMP1 has user ID PTERRY01, a user who is assigned the role containing this authorization will only be able to execute queries created by the user PTERRY01.

Standard Activities 03, 16 allow the user to display / execute reports while 01,02 determine whether the user can create / change reports and if he can, what reports example: If the acitivty 01 is combined with report ID Y*, the user can only create queries whose names start with Y.

And please note, RRMX (Bex analyzer) does not allow you to create queries, Query designer does (link from BEX Analyzer opens up Designer).

Regards,

Prashant

2 REPLIES 2

Former Member
0 Kudos

Hello, Firstly, may I suggest that the subject is misleading for the question asked.

Transaction RRMX only excute the BEX analyzer add in.

In BI/BW the authorization objects that govern whether the user is authorized to display/ execute / create / change queries are S_RS_COMP and S_RS_COMP1.

Both these objects work in tandem. Where as S_RS_COMP covers the infocube, info area authorizations along with activity and Report IDs, S_RS_COMP1 covers the authorization to execute reports (queries) created by author /Owner (SAP username). example: If the owner field in S_RS_COMP1 has user ID PTERRY01, a user who is assigned the role containing this authorization will only be able to execute queries created by the user PTERRY01.

Standard Activities 03, 16 allow the user to display / execute reports while 01,02 determine whether the user can create / change reports and if he can, what reports example: If the acitivty 01 is combined with report ID Y*, the user can only create queries whose names start with Y.

And please note, RRMX (Bex analyzer) does not allow you to create queries, Query designer does (link from BEX Analyzer opens up Designer).

Regards,

Prashant

Former Member
0 Kudos

Hi,

For this problem you need to create two role using the following authorization object.

1)S_rs_Comp

2)s_rs_comp1

One is for only display and execute the report nad another is for all change also.

attach these roles to respected person.

Regards,

Ganesh