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 separate partition for each team.
B. Create a separate data source for each team.
C. Create a perspective for the sales team.
D. Enable client side security to filter non-sales data.

  Discussion forum


Leave an answer