Microsoft-PRO Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008 Set 5

You design a SQL Server 2008 Analysis Services (SSAS) solution. You have a cube that uses a dimension named Product. The Product dimension has the attribute hierachies named Model Number and Color and a natural hierachy with the levels named Category, Sub-Category, and Product. The following table shows the total number of members for the attributes. Attributes Number of Members Product 11,500 Model Number 15 Sub-Category 125 Category 90 Color 300 The measures in the cube are often queried against the Model Number, Sub-Category, and Category attributes. You plan to create an initial aggregation to improve the performance of queries. You need to ensure that the aggregation uses the minimum amount of disk space and improves query performance. How should you set the Aggregation Usage property on the attributes?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You have a SQL Server 2008 Analysis Services (SSAS) cube. Some users only use Microsoft Excel 2007. Some users only use Microsoft ProClarity. You plan to add new key performance indicators (KPIs). You need to ensure that the KPIs meet the following requirements: -Provide all users access to the new KPIs. -Minimize future maintenance. What should you do?

You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services (SSRS) solution. Twenty users edit the content of the reports. The users belong to an Active Directory group named Developers. At times, the reports are published with incomplete information. You need to design an approval process. What should you do?