You design a Business Intelligence solution by using SQL Server 2008. The solution includes a SQL Server 2008 Analysis Services (SSAS) database. You design a data mining structure. The structure is used by a data mining model that predicts the expected growth for a particular market location. The model also populates a data mining dimension named Market Location.
The database includes a cube that contains a calculated member named Predicted Revenue. The calculated member uses predictions from the data mining model.
You have the following business requirements:
The view shown in the following exhibit must be displayed to consultants. (Click the Exhibit button.)
The view shown in the following exhibit must be displayed to managers. (Click the Exhibit button.)
You need to design a solution that meets the business requirements. What should you do?
A.
Implement cell-level security on the cube.
B.
Implement drill through security on the cube.
C.
Implement dimension-level security on the Market Location dimension.
D.
Create a new reference dimension that joins Windows user names and their allowed market locations. Implement dimension-level security on the new reference dimension.
Explanation:
Tip: Two differents visons: managers and consultants = “cell-level security”