You maintain a SQL Server 2008 Analysis Services (SSAS) instance. The instance contains
a database that is used by the members of the Engineering group.
You configure a new role named Engineering and Design by using the following allowed
permission set:
{[Employees].[Department].[Engineering and Design]}
You assign the Engineering group to the Engineering and Design role.
You need to ensure that users in the Engineering and Design role can only view data for
their department.
What should you do?
A.
Add your account temporarily to the Engineering and Design role.
B.
Select the Enable Visual Totals check box for the Engineering and Design role.
C.
Add the Roles= [Engineering and Design]; parameter to the connection string.
D.
Add the User ID= [Engineering and Design]; parameter to the connection string.