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.
Showing results for 
Search instead for 
Did you mean: 

BW Authorization for different users on different Char values

Former Member
0 Kudos

Hi experts,

I am in BW 7.0.

How can i set authorization for different users for different values for Char say SALES_REP.

Scenario is:

1. Sales rep login in BW portal via BW system ID XYZ and runs a report.

2. In BW there is no relationship maintained between Sales REP value say 12345 and Sales ID XYZ.

3. Say new REP ABC joins company he should restrict to see SALES REP data 23456.

Can I create a single Authorization Object and reassign with different values of Char SALES_REP to different users.

We don't want to create as many authorization objects as the number of Sales Rep.

We have SALES_REP enabled as Authorization enabled don't know how to configure the things for above requirement .

It would be great help for me if steps are shared.




Former Member
0 Kudos

You have to create custom authorization object on salea_rep infoobject with RSECADMIN and make that infoobject salesrep as authorization relevant in RSD1. You can assign this custon object directly to user or can restrict through roles

0 Kudos

Thanks very Much for Reply.

Can I use the same Authorization Object for Different User IDs to restrict the different values of the Chars?

Say User ID A should have restricted to value 1 of sales rep.

User ID B should be restricted to value 2 of sales rep.

similarly User ID C should be restricted to Sales Rep value 3 and so on.

Please suggest.


Former Member
0 Kudos

Yes Mukesh, you can

Former Member
0 Kudos

Created Authorization objects as discussed in thread.

Active Participant
0 Kudos

Hi Mukesh,

You will need to create Analysis Authorizations in RSECADMIN, one for each value range of SALES_REP. If you are trying to restrict access to each individual SALES_REP value then you will be creating 1 Analysis Authorization for each value of SAPLES_REP separately. Then you can assign these analysis authorizations through roles using object S_RS_AUTH or assign directly using RSECADMIN. Assigning through roles will make user administration easy for you.

Also BW 7.0, you do not create any Authorization Object that was only in BW 3.x