Steps to add Query to a role (SAP BW)

[Former Member]

Hi friends,

Can any body please tell me the procedure/steps to add a query to a role. Also please tell me the dependent authorizations to be included to access a query.

Thanks & Regards

Prasanth

[Former Member]

hi,

I hope you are asking about BI analysis authorization (BI 7.0)...

You need to add query in S_RS_COMP & S_RS_COMP1 auth. object in PFCG role.

Also You need to link your analysis auth. role in S_RS_AUTH auth. object.

Best Regards

Imran

[Former Member]

Hi,

Query is part of info cube. You need to give info cube access of that respective query for providing query access to user.

Thanks & Regards,

KKRao.

[Former Member]

Hi Prasanth,

You'll also need to provde access to the infocube / multiprovider in which the query resides, as well as the infoarea which the cube sits in. Within your analysis authorisations, depending on your authorisation-relevant characteristics, you may need to provide infoarea hierarchy access and other auth-relevant characteristics, e.g peronnel area etc...

Hope this helps,

Tom

[Former Member]

Hi,

This is how you add a query to a role.

1. Create a new role in PFCG and add only transaction RRMX to it.

2. Do not generate the role.

3. Save the role and then assign the role the user who will be adding the query to the role.

4. The user should have all the necessary authorization to create the query.

5. Now that user will run the transaction code RRMX and then create the required query.

6. Finally he will click on "Assign to role" to assign the query to given role.

Hope this will help you.

thanks