BW Reports: Security

[Former Member]

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.

[Former Member · Accepted solution]

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

[Former Member]

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.