Hi

How can I grant custom access to a role like following:

* BB should have access to all dimensionmembers in AccountNo,
* CC should have access to only dimensionmember 20 in AccountNo

Dimension Account (with one attribute AccountNo)
Values:
10
20
30

Dimension Product (with one attribute ProductNo)
Values:
BB
CC

Can this actually be created for a role in Dimension Data or can this only
be solved with Cell Security?

Regards
donRiccardo

From the problem description, it appears that Cell Security would need
to be defined, rather than Dimension Security, since the secured members
on the Account dimension depend on the member selected on another
dimension/hierarchy.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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