Anybody using cell level security successfully?
I am having trouble.
I set up a user that I know is not an olapadministrator
I set the user so that it can only see
store.CurrentMember.Name = 'CA' (in the foodmart sales cube)
I test the cell level security. It seems to work from the admin console.
However, when I then try a query from MDXSamp that user is still able to see all the data.
grrrrr.
Again, the only documented 'gotcha' that I have seen is that the user can not be an 'olap admin' and I think I have this covered.
I am having trouble.
I set up a user that I know is not an olapadministrator
I set the user so that it can only see
store.CurrentMember.Name = 'CA' (in the foodmart sales cube)
I test the cell level security. It seems to work from the admin console.
However, when I then try a query from MDXSamp that user is still able to see all the data.
grrrrr.
Again, the only documented 'gotcha' that I have seen is that the user can not be an 'olap admin' and I think I have this covered.