You need to implement a solution that meets the needs o…

You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used by the finance,
sales, and marketing teams.
The sales team reports that the model is too complex and difficult to use.
The sales team does not need any information other than sales-related resources in the tabular model.
The finance and marketing teams need to see all the resources in the tabular model.
You need to implement a solution that meets the needs of the sales team while minimizing development and
administrative effort.
What should you do?

You are developing a SQL Server Analysis Services (SSAS) tabular project that will be used by the finance,
sales, and marketing teams.
The sales team reports that the model is too complex and difficult to use.
The sales team does not need any information other than sales-related resources in the tabular model.
The finance and marketing teams need to see all the resources in the tabular model.
You need to implement a solution that meets the needs of the sales team while minimizing development and
administrative effort.
What should you do?

A.
Create a perspective for the sales team.

B.
Create a separate partition for each team.

C.
Create a separate data source for each team.

D.
Enable client side security to filter non-sales data.



Leave a Reply 1

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


Marchello

Marchello

A.
Create a perspective for the sales team.