You are managing a SQL Server 2008 Analysis Services (SSAS) database for
Company.com.
A sales manager called Clerk is responsible for the sales of bikes in the Northeast region.
You decide to give some rights to the rights to Clerk to visit the database. You won two roles
below called Northeast Region and Bikes.
Their schemas are listed below:
You have make The Visual Totals properties attribute true for roles above.
You should make sure that Clerk could browser the workers in the Product dimension which
link to the Bikes category in the Northeast region.
Which is the correct answer?
A.
You should increase Clerk to a Bikes role
B.
You should increase Clerk to the Northeast Region role.
C.
You should increase Clerk to a new role which owns components below: [Products
Territory Region].[Northeast]} as the permitted configuration.{[Product].[Product Category].
[Product Category].[Bikes]} as the permitted
D.
You should increase Clerk to the default Region role.
Explanation:
There was a mess in original q – Nikes, Bikes, Southwest, Northwest…
I think I have fixed it 🙂 another version of the q is: