What's New in PerformancePoint Server 2007 Service Pack 1

Updated: 2008-08-21

This article is an overview of changes in Microsoft Office PerformancePoint Server 2007 Service Pack 1 (SP1) and a link to download.

Downloads

You can download SP1 from the following locations:

What’s New for PerformancePoint Monitoring Server

The following is an overview of what has changed for PerformancePoint Monitoring Server.

  • Windows Server 2008: Installation of PerformancePoint Server 2007 SP1 on Windows Server 2008 is now supported.

  • Scorecard key performance indicators (KPIs): Expand and Collapse commands can be used on scorecards that have hidden parent KPIs.

  • KPIs: Multidimensional Expressions (MDX) statements are not limited to 1,000 characters when they are used in KPIs.

  • Dashboard filters: Dashboards in PerformancePoint show improved performance when filters are applied.

  • Display Condition: You use Display Condition functionality to link a key performance indicator (KPI) to a report, so that when dashboard users click the KPI, the linked report appears. You can now specify a default report to display before dashboard users click the KPI.

  • Dashboard filters and SQL Server Reporting Services reports: You can link multi-select dashboard filters to multi-select Reporting Services report parameters.

  • Sample data: The sample data file has been updated.

What’s New for PerformancePoint Planning Server

The following is an overview of what has changed for PerformancePoint Planning Server.

  • Clear changes after workflow action; a new workbook option for PerformancePoint Add-in for Excel: When you set the Clear changes after workflow action option to True, PerformancePoint Add-in for Excel automatically clears any changes after the workflow action occurs when the form is used in an assignment. This can help improve performance of subsequent queries, such as queries done during a workbook refresh. However, if the submission fails when this option is set to True, the user will not be able to re-submit the changes, and the changes will be lost.

  • Enable what-if analysis; a new workbook option for PerformancePoint Add-in for Excel: When you set the Enable what-if analysis option to True for a matrix, PerformancePoint Add-in for Excel automatically performs what-if calculations that show the effect that the change will have on an assignment if it is submitted. If this option is set to False, PerformancePoint Add-in for Excel does not apply any changes to the matrix. This can help improve query performance.

  • The Data Import Wizard now works with any source data provider: The Data Import Wizard is now a generic data integration wizard that requires customers and partners to develop their own data providers for integrating source financial data. Microsoft provides the PerformancePoint 2007 Data Integration Toolkit. This toolkit is a companion tool that provides a data integration framework. You can use this framework to create your own data providers. You can obtain the PerformancePoint 2007 Data Integration Toolkit (https://go.microsoft.com/fwlink/?LinkId=117552&clcid=0x409) from the Microsoft Download Center.

  • PerformancePoint Add-in for Excel fixes a previous issue in the Report Wizard: Before the SP1 release of PerformancePoint Server, filter-value selections in a report that was created by using the Report Wizard did not behave as expected. They were not limited by filter scope. After installation of SP1, filter-value selections in a report that is created by using the Report Wizard will behave as expected. That is, filter-value selections will be limited based on the filter scope.

  • Discard Submitted RDL & Workbook; a new workflow action for assignments for PerformancePoint Add-in for Excel: When you select the workflow action Discard Submitted RDL & Workbook for an assignment, the input form that is used in the assignment reverts to the original input form template for the assignment. Submitted data is not affected.