You administer a SQL Server 2008 Analysis Services (SSAS) database. A sales manager is responsible for the sales of bikes in the Northeast region. You plan to grant the necessary permissions to the sales manager to access the database. You have two roles named Northeast Region and Bikes. The schemas of the two roles are as shown in the following table. The Visual Totals property is set to True for both roles. You need to ensure that the sales manager can view only the members in the Product dimension that relate to the Bikes category in the Northeast region. What should you do?

Question

Accepted Answer

C. Add the manager to a new role that has the following two components:

Answer

A. Add the manager to the Bikes role.

Answer

B. Add the manager to the Northeast Region role.

Answer

D. Add the manager to a new role that has the following four components:

You administer a SQL Server 2008 Analysis Services (SSAS) database. A sales manager is responsible for the sales of bikes in the Northeast region. You plan to grant the necessary permissions to the…

Question

Options

How the community answered

Community Discussion