You update a role named Managers for the Human Resources cube in your SQL Server
2008 Analysis Services (SSAS) database. The database contains a dimension named
Employee.
You plan to configure the security for the Managers role.
You need to allow the Managers role to access aggregate data based on only three or less
employees.
What should you do?
A.
Add members of the [Employee].[Employees] hierarchy that contain three or less children
to the denied set for the Managers role.
B.
Add members of the [Employee].[Employees] hierarchy that contain more than three
children to the allowed set for the Managers role.
C.
Add the following expression to the Allow Reading property in Cell Data in the Managers
role.
Descendants([Employee].[Employees].CurrentMember,,LEAVES).Count <= 3
D.
Add the following expression to the Allow Reading property in Cell Data in the Managers
role.
IIF(Descendants([Employee].[Employees].CurrentMember,,LEAVES).Count <= 3,
[Employee].[Employees].CurrentMember, null)