0

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

JotaBe
  • 38,030
  • 8
  • 98
  • 117
Kailash
  • 1

1 Answers1

0

My advice is here:
CurrentMember (MDX) Ignores Slicer Dimension

If you continue to use roles, I advise you to carefully read about 'Visual Totals' if your OLAP provider supports them. Sorry I can't be more helpful.

Community
  • 1
  • 1
Magnus Smith
  • 5,895
  • 7
  • 43
  • 64