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.