I've got a couple of cubes setup that I want to start allowing people
to see on part of the data. I setup mulitple roles for this. I then
changed the region dimension to custom restriction, and selected the
values I wanted to allow the role to see. Everything is great when I
have the visual totals option disabled, but I get an error when I
enable visual totals. Since this is a requirement I can't just leave it
disabled either.

The error I get is:
The operation requested failed due to security problems - unknown Sales
Pipeline^Region

Also, I don't have a distinct count in the cube. Any suggestions???
Thanks
James

Ok, I have found some more information about the issue. First I forgot
to mention I'm using AS 2000. Next I found that out of 18 regions if I
give the role access to nine or more it works. If I give access to less
than nine it gives the error above..... I'll take any thoughts.
Thanks
James