PerformancePoint Server Service Pack 1

By | June 5, 2008
PerformancePoint Server Service Pack 1 provides a number of features and fixes. Here are the downloads.

  • PerformancePoint Server 2007 Service Pack 1:  (x86)(x64)

The following is an overview of what has improved.

Monitoring

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

SQL Server 2008
Although not yet fully supported, SQL Server 2008 data sources can be used.

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
PerformancePoint Dashboards show improved performance when filters are applied.

Time Intelligence Post Formula filter
Time Intelligence Post Formula filters.

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. In PerformancePoint Server 2007 SP1, you can now specify a default report to display before dashboard users click that 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.

Planning

PerformancePoint Add-in for Excel offers a new workbook option: Clear changes after workflow action.

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.

PerformancePoint Add-in for Excel offers a new workbook option: Enable what-if analysis.

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. (http://go.microsoft.com/fwlink/?LinkId=117552&clcid=0x409) from 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.

PerformancePoint Add-in for Excel offers a new workflow action for assignments: Discard Submitted RDL & Workbook.

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