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

Your scorecard displays a set of key performance indicators (KPIs) in rows and displays values for Actuals and Targets in columns. You need to display the KPIs in columns and display the values for Actuals and Targets in rows. What should you do?

You create a new dimension named HR in a PerformancePoint Planning Server application. You need to create an additional member property for the HR dimension. You also need to ensure that the additional member property is populated from a predefined dimension named Entity. What should you do first?

You create a new application in PerformancePoint Planning Server. You create a calendar for the application. Your manager wants another calendar for the manufacturing department. The department uses different fiscal year dates. You need to create the new calendar. What should you do first?

You plan to populate a predefined Currency dimension with data stored in a Microsoft Office Excel file. The file has an XLSX extension. You discover that the Load Members wizard is unable to load the XLSX file. You need to ensure that the Load Members wizard can load data from the XLSX file. What should you do?

You plan to load dimension members to a predefined dimension. The data that is used by the dimension is located in a Microsoft SQL Server database. You start the Load Members wizard. You discover that the database is inaccessible. You need to ensure that you can load the data by using the Load Members wizard. What should you do?

You are configuring the currency type for the Entity dimension in a model. You add the Dollar (adjusted) currency type to the Currency dimension. The Dollar (adjusted) currency type does not appear in the Select Member window. You need to ensure that Dollar (adjusted) appears in the Select Member window. What should you do?

A PerformancePoint Planning Server application has a dimension named Products. The dimension has a custom property named Type. You load new members to the Products dimension. You need to add the new members to a member set named Equipment. What should you do?

You create a model. You plan to add a rule to your model. The rule uses a predefined property named Consolidation Balancing account. You are unable to locate the predefined property in the Model Properties workspace. You need to ensure that the predefined property is listed in the Model Properties workspace. What should you do?

You create a model named Generic. You need to link the Generic model to two assumption models named ProductPrice and UnitMovement. What should you do?

You are configuring dimensions. You add a shared Product dimension to the root model site. You add dimension members for each product type to the shared Product dimension. A subsite uses the shared Product dimension. You create a model in the subsite. You need to ensure that the subsite tracks only product type shoes. What should you do?