how to assign a Bex report to the user role

[Former Member]

Hi Expert

in the Excel, when you open a query, the system will display history, faviourate, infoarea, role button on the left side of the popup screen. if you click the role button, you can see the user authorized Bex report. now I have created a Bex report and I want to assign it to the user role.

how to do that?

does anyboday know which transcation or setting can solve this problem?

thank you in advance!

[Former Member]

Xioliu,

You should have the Report ID (25 characters). Go to the role you wan to add the BEX report to using PFCG. Under the Menu tab click the Report button, select the BW report radio button, paste the Report ID. You might want to check all the GUI support. Finally click the green check button.

You will get an entry "RRMX - Business Warehouse report", you might want to change it to a more meaningful name.

The rest will be standard authorization step, giving the need authorization objects for the report.

Have fun.

Lye

[Former Member]

Hi,

You need to add the object S_RS_COMP:

S_RS_COMP: Authorizations for using different components for the query definition. This authorization object is very important for reporting

The authorization object S_RS_COMP restricts query component activities. For example, it restricts if someone can create queries, change queries, or execute queries. You can restrict query creation, change, and execution by the InfoArea and InfoCube. If your company has one InfoCube for sales information and another for financial data, you can restrict a user to only those queries written for the sales InfoCube or the financial InfoCube.

You could also use S_RS_COMP if you want to protect by query name. For example, you have an InfoCube for sales data. Every sales manager needs access to this InfoCube. However, sales managers in different lines of business are not allowed to execute the same query.

Please visit:

http://www.sapsecurityonline.com/bw_security/bw_security_auth_obj_2.htm

to know more about BW Objects.

Hope it helps.

Please award points if it is useful.

Thanks & Regards,

Santosh