|
Home > Archive > MS SQL Server OLAP > January 2006 > Issue with restricted dimensions and Visual Totals
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Issue with restricted dimensions and Visual Totals
|
|
|
| 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
|
|
|
|
|