Microsoft-TS Microsoft SQL Server 2005 Business Intelligence - Implementation and Maintenance

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report contains financial data. An input parameter named TargetMfr is present in the report. When a value in the Machine_Mfr field matches the selected value in the input parameter, the color of the output in a column is red. Otherwise, the color of the output is green. You need to set the TextBox that contains the color property of the Machine_Mfr field to the appropriate expression. Which expression should you use?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The query that builds the dataset for the report uses a WHERE clause to filter the rows. The report parameter must perform the following actions: Use the new parameterized query.Run without any user input.Allow users to change the value that is passed to the query by selecting a value from a drop-down list. You need to modify the settings of the Report Properties dialog box to meet the outlined requirements. Which four tasks should you perform? (Each correct answer presents part of the solution. Choose four.)

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. The project contains a cube named Finance. The Finance cube contains the following objects: A measure group named SalesMeasures. A measure named SalesAmount. A time dimension named DimTime. A time dimension hierarchy named Calendar that contains Year on the first level, Quarter on the second level, and Month on the third level. You need to create a trend expression that displays the increase and decrease in the SalesAmount measure for the current DimTime member, irrespective of the level of the Calendar hierarchy. Which expression should you use?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. You create a cube that contains the following objects: A time dimension named Time that has an attribute named TimeKey. A fact table named FactOrders. The Time dimension contains different hierarchies. Two of the columns of the fact table link to the attribute. You need to view the measures for different hierarchies for both the columns in the fact table. What should you do?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. You create a cube named ExpenseData that uses a dimension named Expense. The Expense dimension is a parent-child dimension with: a key attribute named Expense. a parent attribute named Expenses of type Expense. The project contains a role named Users. You need to modify the Users role to achieve the following tasks: Restrict role members from viewing the cell values of Expenses under the expense Managerial Expenses. Ensure that all the labels for the Expense dimension are visible. What should you do?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. You create a dimension that contains a parent-child hierarchy. The dimension has a key attribute named Employee and a parent attribute named Employees. You need to ensure that the dimension identifies the topmost employee member of the hierarchy as the root member. What should you do?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. You create a cube that uses a dimension named DimEmployee. The dimension contains an attribute named Employee. You also host a Microsoft SQL Server 2005 Reporting Services (SSRS) project that contains a parameterized report on an employee. You need to create an action to view the report. What should you do?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. You create a cube with the following objects: A time dimension named Time. A fact table that contains two columns named Order Date Key and Numbers of Orders. A Number of Orders measure added to a measure group named Measures. The cube has a dimension usage named Order Date that links the Order Date Key column to the Time dimension. You need to create a Multidimensional Expressions (MDX) calculation that displays the cumulative totals of the Number of Orders column for all hierarchies in the Order Date dimension. Which MDX expression should you use?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. The project has a fact table named FactOrders that contains columns named Order Amount, Country, and Order Date Key. You create the first partition for the fact table with the Source property set to "Select * from FactOrders where [Order Date Key]>354 or Country='USA'". You need to create the second partition for the fact table to ensure accurate results when queried. What should you do?

You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. Your data source contains the following tables: Products table with a column named ProductCategories_ID ProductCategories table with a column named ID The ProductCategories_ID column is used to link to the ID column. You create a data source view with the RetrieveRelationships property set to false. You need to set the NameMatchingCriteria property of the data source view to an option to create a relationship between the two tables. Which option should you use?