You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. You create a cube named ExpenseData that uses a dimension named Expense.
The Expense dimension is a parent-child dimension with:
a key attribute named Expense.
a parent attribute named Expenses of type Expense.
The project contains a role named Users.
You need to modify the Users role to achieve the following tasks:
Restrict role members from viewing the cell values of Expenses under the expense Managerial Expenses.
Ensure that all the labels for the Expense dimension are visible. What should you do?
A.
Change the access to Read/Write for dimension Expense for the ExpensesData cube.
B.
On the Cell Data tab, select the Enable read permissions check box. Enter the [Expense].[Expenses].Parent.Name<>”Managerial Expenses” expression.
C.
On the Cell Data tab, select the Enable read permissions check box. Enter the [Expense].[Expenses].Parent.Name=”Managerial Expenses” expression.
D.
On the Dimension Data tab, select the dimension Expense in the ExpensesData cube in the Dimension drop-down box, and then cancel the selection of all the members under the member Managerial Expenses.