We have a scenario with SAP BI 7.0 and Business Objects XI Release 2 installed, where we want end users to view reports through BO Web Intelligence (the users will have access to the reports through the BO Web Interface). It is our plan to build the BO Universes on top of a range of small to medium sized SAP BW Queries (not any queris that include entire cubes etc.). My question is now:
What is the optimal way of maintaining authorizations in a scenario like this? I would expect a setup with Single Sign On between BO and SAP BI, where we maintain the authorizations through SAP Analysis Authorizations, to be the best solution, but is this feasible?
I would really like to hear experiences from other people, and any comments are welcome.