We request your kind suggestions for the authorization problem we are facing in BI IP 7.0.
We have implemented Integrated planning of BI 7.0. We have many workbook queries (BEx Analyzer) consisting of three authorization objects. Now we have a requirement where we need to give authorization to users for working on certain data of those authorization objects. So, we have created users with certain authorizations.
Now, we are encountering problems when we are trying to work with some of the functions in the certain scenarios as follows:-
1. We are unable to open copy the data from one cube the another where the target cube doesn't have one authorization object. Here we are getting 'No authorization to read the data' error. Even we tried to trace the id using ST01 to find which authorization is missing but of no use as it is specifying us to give 0BI_ALL for BI_AUTH authorization object. This we cannot give as it gives authorizations to all the data of the authorization objects.
2. We are getting authorization error when open certain queries which doesn't have one of the authorization objects. The userid we are trying to open the queries have been restricted to specific data of all authorization objects..
We request you to please suggest if there is any way to trace the user id to find the specific missing authorization.