I have one requirement.
In my project we have a Manager Profile, who runs some BW Reports, based on the Org Units of which he is a Manager, he can see data of only those Org Units in BW Reports.
Now this Manager is assigned another Role, which gives him access to all system wide data (means no restriction on Org Unit basis). Due to this Role, when the user is running BW Reports as a Manager, he is able to see the system wide data, but as a Manager he should be able to see data for only those Org Units of which he is a Manager.
So in nut shell the requirement is, the user is a Manager who is also having a Global Role.
Now when the user is running BW Reports present in Manager's Role, he should be able to view the data of only those Org Units for which he is a Manager and when he is running BW Reports, present in that other Global Role, he should be able to access data of whole system (no Org Unit Restriction).
While presently due to this Global Role, when the user is running BW Reports present in Manager's Role, he is able to access all the system's data, which should not be the case.
Could any one of you please suggest what needs to be done to achieve this?