I want to apply dynamic dimension level security on my cube. I created two roles and assigned users to them. Everything worked fine till the time users did not overlap between roles. But as soon as I added the same user in both the roles ,all security was nullified and the user was able to see the entire data.
I read that SSAS has additive role security. Both the roles are based on Different Dimensions. I am trying to find a workaround so that I can maintain the security even if the same user is assigned to two different roles. Any suggestions as to how this could be achieved would be highly appreciated.