Re: Creating a role for users
- From: Deepak Puri <deepak_puri@xxxxxxxxxxxxxxx>
- Date: Tue, 28 Nov 2006 16:22:37 -0800
Since you're seeing "#N/A" in the cells, you may be getting misled by
the (admittedly confusing) verbiage on the Cell Data page of the Role
Designer. At first glance, you'd assume that you need to check at least
one of the 3 options (and it looks like you selected "Enable read
permissions"); but try clearing all the 3 check-boxes instead:
http://msdn2.microsoft.com/en-us/library/ms177279.aspx
SQL Server 2005 Books Online
Cell Data (Role Designer) (SSAS)
Use the Cell Data page of Role Designer to specify cell permissions for
the role.
...
Enable read permissions
Allows the role read-only access to the cells in the selected cube.
...
Enable read-contingent permissions
Allows the role read-contingent access to the cells in the selected
cube.
...
Enable read/write permissions
Allows the role read-write access to the cells in the selected cube.
...
- Deepak
Deepak Puri
Microsoft MVP - SQL Server
*** Sent via Developersdex http://www.developersdex.com ***
.
- References:
- Creating a role for users
- From: davidb1835
- Creating a role for users
- Prev by Date: Re: Can SSAS 2005 work in Novell network?
- Next by Date: Tables from Different Databases in Same Cube?
- Previous by thread: Creating a role for users
- Next by thread: Parent-child dimension with two tables
- Index(es):
Relevant Pages
|
