You design a Business Intelligence (BI) solution by using SQL Server 2008. A SQL Server 2008 Analysis Services (SSAS) solution contains a cube that has the following objects:
Dimensions named DimCustomer, DimProduct, and DimGeography Measures named InternetSales and TotalSales
Users run reports against all dimensions and measures by authenticating with their Windows accounts.
You need to provide a basic view of data to the users to display only DimGeography, DimProduct, and TotalSales by using the least amount of storage space.
What should you do?
A.
Create a new perspective for the current cube.
Select DimGeography, DimProduct, and TotalSales.
B.
Create a new cube.
Add DimGeography, DimProduct, and TotalSales.
C.
Create a new role.
Grant access only to DimGeography, DimProduct, and TotalSales.
D.
Create a new data source view.
dd the tables used for DimGeography, DimProduct, and TotalSales.
Explanation:
Tip: “Windows accounts” = “new perspective”A perspective is a subset of the information in the model. Usually, a perspective coincides with a particular job or work area within an organization. If a plus sign is to the left of the model, the model contains one or more perspectives. Click the plus sign to view the perspectives. If you select one of these perspectives as the data source for your report, only the entities in that perspective will be available to your report. Because perspectives reduce the number of entities you have to look through to find the data you need on your report, it is usually a good idea to choose a perspective, rather than using the entire Report Model.
(McGraw-Hill – Delivering Business Intelligence with Microsoft SQL Server 2008 (2009))http://msdn.microsoft.com/en-us/library/ms345316.aspx
For models that contain many subject areas, for example, Sales, Manufacturing, and Supply data, it might be helpful to Report Builder users if you create perspectives of the model.
A perspective is a sub-set of a model. Creating perspectives can make naviga