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