I implemeneted authorization analysis in BI and everything seems fine until I come to this tricky situation. I use 0PLANT as part of authorization. I limit user can only access to their own plant data. However, one of the reports I need to have users to access to all other plant data in additional to their own plant data.
I just wonder how can I take out the authorization restriction in the query? I tried to take out the 0PLANT authorization variable from the query as I expect I get the error for user is not authorized but if I leave the authorization variable in the query, user can only access to his plant data and can't see other plant data. Please advise. Thanks.