I have defined dimension security in my OLAP cube by creating roles and assigning users to each roles. Each user in a role can only see the location they belong to.
When I browse the cube using a role , I see correct location for that role. But, when I browse the cube using "Other User" feature in "Change User" and test it for the same user which exist in the role, it fails and I see all the locations.
What could be the problem?
Thanks, Kailash