Microsoft-TS Microsoft Office PerformancePoint Server 2007, Applications Set 1

You create a PerformancePoint Add-in for Excel report. You create a matrix for the report. You add a dimension named Products to the column property of the matrix. One of the columns in the report displays the Product Id property of the Products dimension. You need to display the Product Name property with the Product Id property in the column. What should you do?

You create a PerformancePoint Add-in for Excel report. The report displays sales data. You need to change the background color of the cells that contain sales data. What should you do?

You create a PerformancePoint Add-in for Excel report. Your model has a dimension named Products. The Products dimension contains two member sets named Color and ProductCategory. You add a matrix to the report. The matrix displays the number of products in the ProductCategory member set. You need to ensure that the matrix displays the number of products in the ProductCategory member set only if the Color member has a value of either Red or Blue. What should you do?

You create a PerformancePoint Add-in for Excel report. The report retrieves data from a hierarchy. The hierarchy is located on the row axis and contains data that is grouped into different levels. You need to ensure that the data grouping in each level is easily visible. What should you do?

You create a PerformancePoint Add-in for Excel report. You publish the report as a form. Users can modify the values that are stored in the non-leaf members. You need to ensure that any changes made to nonCleaf- member values are also propagated to the leaf-member values. Your solution must maintain the proportion between the leaf-member values. What should you do?

You create a PerformancePoint Add-in for Excel report. You add a three-level hierarchy to the report. You select ten top-level members from the hierarchy. You need to ensure that the report displays only the leaf members of the ten selected members. What should you do?

You create a PerformancePoint Add-in for Excel report. Your report contains three matrices that are based on a model. The model contains a dimension named Products. You need to apply a linked filter to the three matrices by using the Products dimension. What should you do?

You are assigned the Global Administrator role on the Microsoft Office PerformancePoint Server 2007 server. You create a new application named Contoso. You attempt to assign data administrators to the application. You discover that the Add/Remove Users option for the Contoso application is unavailable on the PerformancePoint Planning Administration Console. You need to enable the Add/Remove Users option for the Contoso application on the Data Administrator Role menu. What should you do?

You create a new Microsoft Office PerformancePoint Server 2007 application. You need to ensure that only users assigned to the Modeler role can connect to the application. Which mode should you change the state of the application to?

Your company adopts a new security policy. The policy requires that changes made to the PerformancePoint Planning Server system configuration must be automatically recorded in a log file. The size of the log file must not exceed 30 MB. You need to ensure that a new log file is created when the size of an existing log file reaches 30 MB. What should you do?