cancel
Showing results for 
Search instead for 
Did you mean: 

BW Reports: Security

Former Member
0 Kudos
52

Hi Guys,

We are working with setting up Security for BW reports. We are already done with developing reports. And we have decided on setting up security on few Info objects. The problem is there are large number of queries. And we have to attend each individual query and update it with 'Securrity variables' for all the security relevant Info objects. This would be a humongous task considering the number of queries. I would like to know if there is any efficient way of doing this or are there any better suggestions in our case and situation.

Any help would be greatly appreciated.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

if you need an authorization on value basis you have to go through the following steps:

1) set infoObject authorization relevant (infoObject mainenance)

2) Create authorization object (transaction rssm)

3) create role including the authorization and enter values

e.g. if you have different company codes in one cube and you want to use authorizations to separate.

Here's another useful link

http://help.sap.com/saphelp_bw33/helpdata/en/80/1a689ae07211d2acb80000e829fbfe/content.htm

--Led

Answers (1)

Answers (1)

Former Member
0 Kudos

Led,

Thanks for the response. But, that is not what i was looking for. The Authorization objects are created and assigned to roles. All that is done.

As i mentioned, we created Authorization objects on few Info objects. Now, we have to go to each of the queries and update the queries by adding the security objects. Instead of updating each query, is there an efficient or easy way of doing this. If not, is there any better way of implementing this.

Any help would be greatly appreciated.