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 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. The data source for a cube has tables as shown in the following exhibit. (Click the Exhibit button.)

The cube contains the following objects:

A dimension named DimAccounts that uses a table named Accounts.
A dimension named DimCustomers that uses a table named Customers.
A measure group named Transactions that uses a fact table named Transactions.
A measure group named Customer Accounts that uses a fact table named CustomerAccounts.

You need to create a cube dimension to browse through the measures in the Transactions fact table by using the DimCustomers dimension.

What should you do?

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. 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 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 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 report has three columns in a table. The columns are named MachineName, MachineMfr, and MachineModel. The report navigation options must allow users to click on a row from the MachineName column and drill through to another report, and then pass the contents of the MachineName column as a parameter named MachineName. You need to configure the report navigation options to satisfy the user requirements. Which three tasks should you perform? (Each correct answer presents part of the solution. Choose three.)

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report. The report uses a dataset that is constructed from an SQL table named Employees. The table has an employeeID field and a managerID field. The managerID field in each row represents the employeeID field.

You execute the following Transact-SQL query to get the dataset from the report:

SELECT CONVERT(varchar(255), c.FirstName + ‘ ‘ + c.LastName) as Name, e.EmployeeID, e.ManagerID FROM HumanResources.Employee AS e JOIN Person.Contact AS c ON e.ContactID = c.ContactID You need to display the dataset as a hierarchical, organizational chart, as shown in the Exhibit. (Click the Exhibit button.)

What should you do?

You are designing a Microsoft SQL Server 2005 Reporting Services (SSRS) report that supports drilldown. You need to modify the report so that the detailed data is hidden when the report is initially rendered. What should you do?