Info provider based Security
We build the multi provider with cube A and B, and planing to implement object based security on Infoprovider, the purpose have a one report common for 2 business and enforce security while accessing the data.
1 Created 2 Authorization Object AO1 and AO2 based on info provider A and B.
2.Addd these authorization objects to Roles R1 and R2 respectively.
3 Assigned roles R1 and R2 to 2 test user U1 and U2.
The User U1 still able to access data from the cube B and the same way Use U2 able to see data from cube B.
Any suggestion how can I enforce this design at security level..
Thanks for your inputs..