Re: Roles, hide dimension question

[dpuri]

Does this Connect case describe what you want to do - in that case, you
can deny access to members and omit the dimension in a perspective
(assuming you have Enterprise Edition):

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?Feedb
ackID=233410
>>
Denying Access to a Whole Dimension by Christopher Webb Active

In AS2K it was possible to deny access to an entire dimension (and not
just the members on the dimension) using a role. This is no longer
possible in AS2005 - all you can do is use dimension security to hide
all the members and then create a perspective where the dimension is
hidden for users of that role - but this is hardly satisfactory. See
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=843443&SiteID=1
for more background.
>>

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***