You need to verify that users in the Northern Region role can view data only for their region

You are a server administrator of a SQL Server 2008 Analysis Services (SSAS) instance.
The instance contains a database that is used by the members of the Sales group.
You configure a new role named Northern Region by using the
“{[Customers].[Region].[Region].[Northern]}’ allowed permission set.
You assign the Sales group to the Northern Region role.
You need to verify that users in the Northern Region role can view data only for their region.
What should you do?

You are a server administrator of a SQL Server 2008 Analysis Services (SSAS) instance.
The instance contains a database that is used by the members of the Sales group.
You configure a new role named Northern Region by using the
“{[Customers].[Region].[Region].[Northern]}’ allowed permission set.
You assign the Sales group to the Northern Region role.
You need to verify that users in the Northern Region role can view data only for their region.
What should you do?

A.
Temporarily add your account to the Northern Region role.

B.
Add the User ID=Northern Region; parameter to the connection string.

C.
Add the Roles=Northern Region; parameter to the connection string.

D.
Select the Enable Visual Totals check box for the Northern Region role.



Leave a Reply 0

Your email address will not be published. Required fields are marked *