Microsoft has released a service pack for Microsoft Office PerformancePoint Server 2007. This article contains information about how to obtain the service pack. This article also contains a list of issues that the service pack fixes.
PerformancePoint Server 2007 Service Pack 3 (SP3) contains stability improvements and performance improvements. Some fixes that are included with PerformancePoint Server 2007 SP3 were previously released in separate updates. PerformancePoint Server 2007 SP3 combines the previously released fixes into one update.
PerformancePoint Server 2007 Service Pack 2 does not install on a Planning server that has Post-Service Pack 1 hotfixes installed or the PerformancePoint Server 2007 Service Pack 2 Beta installed
Description of the PerformancePoint Server 2007 hotfix package: June 17, 2009
PerformancePoint Server 2007 SP3 also fixes the following issues that were not previously documented in the Microsoft Knowledge Base articles.
PerformancePoint Server 2007 Planning issues
You cannot delete member properties for a dimension.
Symptoms You cannot delete member properties for a dimension in Planning Business Modeler.
The Prerequisites page of the Planning Server Configuration Manager displays incorrect information if no Internet Information Services (IIS) 6.0 components are installed.
Symptoms On a computer that is running Windows Server 2008, you install the Web Server (IIS) server role. You only install the components of IIS 7.0. You do not install any components of IIS 6.0. When you start the Planning Server Configuration Manager, the Prerequisites page displays the following results:
The Internet Information Services (IIS) 6.0 item is installed.
The IIS 6.0 Isolation Mode item is installed.
The ASP.NET 2.0 Web Services Extension in IIS item displays the following warning message:
ASP.NET 2.0 Web Services Extension is not enabled in IIS. See your IIS documentation for information on enabling ASP, ASP.NET, CGI, and ISAPI extensions.
Note This warning message persists even if the ASP.NET v2.0.50727 feature in the ISAPI and CGI Restrictions item is set to Allowed.
Buttons for adjusting member locations are unavailable for the No Member member in Planning Business Modeler.
Symptoms You create a member set that contains the No Member member and one or more other members. When you select the No Member member, the buttons for adjusting member locations become unavailable. This problem does not occur for other members. However, you can still use the drag-and-drop operation to adjust the location of the No Member member.
When you expand or collapse parent members in a member set in Planning Business Modeler, the No Member member jumps to a different location.
Symptoms You have a member set that contains the No Member member in Planning Business Modeler. Additionally, the No Member member is at the top parent level of the member set. You select the No Member member. When you expand or collapse other parent members, the No Member member jumps to a different location of the member set.
When you set the Spreading type option to Ratio in PerformancePoint Add-in for Excel, the values of the cells at the leaf level change from NULL to 0.
Symptoms You create a report that displays a hierarchy of data. One or more cells at the leaf level of the hierarchy have NULL values. You set the Spreading type option to Ratio, and then update a cell at the parent level. When the report is recalculated, the values of the cells with the NULL values change to 0.
You cannot select members for a member set when you create a report in PerformancePoint Add-in for Excel.
Symptoms You create a report in PerformancePoint Add-in for Excel. When you try to select members for a member set, you receive the following error message:
The hierarchy contains a problem. Unable to launch member selector.
This problem occurs when the following conditions are true:
The member set contains more than one sibling. Each sibling contains one or more children.
The IsAggregatable property of the parent/child hierarchy that represents the member set is set to False. Note The parent/child hierarchy has the same name as the member set.
When you import an application from a source computer that is running the Danish version of PerformancePoint Server 2007 to a destination computer that is also running the Danish version of PerformancePoint Server 2007, the data format is changed from Danish to English.
Symptoms You have an application that is created in the Danish version of PerformancePoint Server 2007. You export the application from a source computer. Then, you import the application into a destination computer that is also running the Danish version of PerformancePoint Server 2007. When you view the Time dimension on the destination computer, you notice that the date is displayed in the English format.
When you import a .csv file into a member set by using the /OverrideExistingMember flag, the dimension structure information for existing members in the member set is not updated.
Symptoms You use the ppscmd importdimension command together with the /OverrideExistingMember flag to import a .csv file into a member set in Planning Business Modeler. However, the dimension structure information for existing members in the member set is not updated.
The ppscmd importsecurity command does not set the model access setting to On for imported roles.
Symptoms You use the ppscmd importsecurity command to import roles and users. You notice that the model access setting is set to Off for imported roles. Therefore, you have to manually set the model access setting to On for the imported role.
When you load an assignment in PerformancePoint Add-in for Excel, the language setting of the Excel application is changed.
Symptoms When you load an assignment in PerformancePoint Add-in for Excel, the language setting of the Excel application in which the assignment was last updated is applied to the current Excel application where the assignment is loaded.
You cannot use the ppscmd importsecurity command together with the /override flag to update the member permission of a dimension member if the current member permission is Read + Write.
Symptoms You have a dimension member whose member permission is Read + Write. When you use the ppscmd importsecurity command together with the /override flag to update the member permission, you encounter one of the following problems:
You receive the following error message:
The following items cannot be saved: The total number of errors during submission is 1.
The command is completed successfully. However, the member permission is not updated.
You cannot configure PerformancePoint Planning Server if you configure Microsoft SQL Server 2008 Reporting Services to run in SharePoint Integrated mode.
Symptoms You configure SQL Server 2008 Reporting Services to run in SharePoint Integrated mode. When you start Planning Server Configuration Manager, you receive the following warning message on the Prerequisites page:
Analysis Management Object 9.0 (SP2) is missing.
Planning Server uses Analysis Management Object 9.0 Service Pack 2 to connect to SQL Server 2008. Therefore, you cannot configure Planning Server.
You cannot write data to parent members in PerformancePoint Add-in for Excel even if the Enable input at all levels model property of the model is set to True.
Symptoms You set the Enable input at all levels model property to True for a model. In PerformancePoint Add-in for Excel, you create a form for the model. You add a dimension to filters. Additionally, you only select the leaf member of the dimension. If the dimension is not the first item in the filter list, you cannot write data to parent members.
After you delete a cell value in a form assignment in PerformancePoint Add-in for Excel, you can no longer see updates for the cell.
Symptoms You open a form assignment in PerformancePoint Add-in for Excel. You delete the value of a cell in the form assignment and then perform the Submit Draft action. Then, another user updates the value of the cell. When you open the form assignment, value of the cell is still 0.
Workaround Perform the Clear Current Changes action for the form assignment.
You cannot create a job template for a business rule if the type of the business rule is Assignment and the implementation of the business rule is MdxQuery.
Symptoms You create a business rule in Planning Business Modeler. The type of the business rule is Assignment. The implementation of the business rule is MdxQuery. Additionally, you add a parameter to the rule. The data type of the parameter is Members of dimension. Then, you deploy the business rule. When you try to create a job template for the business rule, you receive the following error message:
An error occurred while creating a job template for rule set or rule <RuleName>.
You cannot submit the value that you use to replace a design-time formula in a form assignment in PerformancePoint Add-in for Excel.
Symptoms You replace a design-time formula in a form assignment with a value in PerformancePoint Add-in for Excel. After you submit the form assignment, the value is not submitted. However, if you replace the design-time formula with a new design-time formula and then submit the form assignment, the new design-time formula is submitted correctly.
PerformancePoint Server 2007 Service Pack 3 introduces the /replace switch for the PPSCmd.exe utility. You can use the PPSCmd.exe utility together with the /replace switch to update existing user permissions or role permissions.
You cannot run a report that is created for a model that has the Enable input at all levels model property set to True.
Symptoms You have a model that has the Enable input at all levels model property set to True. You create a report for the model in PerformancePoint Add-in for Excel. When you run the report, you receive the following error message:
Cannot render the <ReportName> matrix. The following error was detected: Measures
You cannot install a service pack of PerformancePoint Add-in for Excel on a Windows 7-based computer that is running Excel 2010.
Symptoms You have a computer that is running Windows 7. You install Excel 2010 on the computer. When you install a service pack of PerformancePoint Add-in for Excel, you receive an error message.
When you set the Spreading type option to Ratio in PerformancePoint Add-in for Excel, cells that contain line item details have inconsistent line item details on the Line Item Details pane.
Symptoms You add line item details to one or more regions in PerformancePoint Add-in for Excel. After you set the Spreading type option to Ratio, you update the value of the parent cell of the region. You open the Line Item Details pane for a cell that has a line item detail. Then, you notice that the line item detail in the Line Item Details pane differs from the line item detail of the cell.
PerformancePoint Server 2007 Monitoring and Analytics issues
When you run a Microsoft Excel Services report in Dashboard Designer, the report never finishes processing.
Symptoms You create an Excel Services report in Dashboard Designer. When you run the report, the report shows the processing status and never finishes.
This problem occurs when the root site of the SharePoint Web site does not exist. For example, the SharePoint Web site is located at http://localhost/sites/mysite. However, the root site http://localhost does not exist.
You cannot preview the data of a table item in an Excel workbook by using an Excel Services data source.
Symptoms You create a data source that is based on an Excel Services file in Dashboard Designer. You specify a table item in an Excel workbook. When you preview the data, you receive the following error message:
Error in Connecting to Data Source. Please verify the connection details.
This problem occurs when a cell in the first row of the table has a blank value.
You cannot connect to Monitoring Server in Dashboard Designer if you install Microsoft .NET Framework 3.5 before you install Monitoring Server.
Symptoms You install Microsoft .NET Framework 3.5 before you install Monitoring Server. When you try to connect to Monitoring Server in Dashboard Designer, you receive the following error message:
Unable to Connect to Server
After you perform the Show Details action on an analytical chart, you cannot export the result to Excel in Windows Internet Explorer 8.
Symptoms You view a dashboard that displays an analytical chart in Windows Internet Explorer 8. You perform the Show Details action on the analytical chart. When you try to export the result to an Excel workbook, you receive the following error message:
The file name is not valid.
When you export a scorecard that displays a value whose format is Percent to an Excel workbook, the result value is incorrect.
Symptoms You have a scorecard that displays a value whose format is Percent. When you export the scorecard to an Excel workbook, the result value becomes a decimal value that ends with a percent sign (%). For example, the original value is 4%. The result value is 0.04%.
An unhandled exception error occurs when you scroll down to a large dashboard in Dashboard Designer.
Symptoms You create a large dashboard that contains many charts and zones in Dashboard Designer. When you scroll down to the bottom of the dashboard, you receive an unhandled exception error.
When a formula in a Time Intelligence filter includes one member, the formula returns no data.
Symptoms You create a Time Intelligence filter for a dashboard in Dashboard Designer. Data on the dashboard is from a data source of the Tabular List category. The Time Intelligence filter has a formula that defines a range of members. When the formula includes one member, the formula returns no data.
Analytic grids and analytic charts generate incorrect results when the data source is Microsoft SQL Server 2008 Analysis Services.
Symptoms When you run an analytic grid or an analytic chart that uses the data source of SQL Server 2008 Analysis Services, you obtain incorrect results. This problem occurs when the EXISTING keyword is used in the query for the analytic grid or the analytic chart.
This problem does not occur when the data source is Microsoft SQL Server 2005 Analysis Services.
A stacked zone in the upper-right corner of a dashboard does not appear when you open the dashboard in PerformancePoint Server 2007 Service Pack 2.
Symptoms You create a dashboard in Dashboard Designer. The dashboard has a stacked zone in the upper-right corner of the dashboard. Additionally, the stacked zone contains an analytic chart or an analytic grid. A KPI is linked to the analytic chart or to the analytic grid by using the Display Condition feature. After you install PerformancePoint Server 2007 Service Pack 2, the stacked zone does not appear when you open the dashboard. This problem persists even if you click the KPI.
You cannot view a chart or a grid that returns no records.
Symptoms You create a grid or a chart that returns no records in Dashboard Designer. When you view the chart or the grid, you receive the following message:
Drag measures, dimensions, or named sets to Rows and Columns to lay out the report.
However, you expect to see no records.
This problem also occurs when you drill down a dimension level that contains no records.
When you expand a column header of an analytic grid, you receive an unexpected error.
Symptoms When you expand a column header of an analytic grid, you receive the following error message:
An unexpected error occurred. Error ReportViewControlUnexpectedError
After you change the font size of an item in a scorecard and then publish the dashboard that contains the scorecard, the item is still displayed in the original font size.
Symptoms You change the font size of an item in a scorecard in Dashboard Designer. When you preview the dashboard that contains the scorecard, the item is displayed in the correct font size. You publish this dashboard to a SharePoint Web site. However, when you view the dashboard from a SharePoint Web site, the item is displayed in the original font size.
If you set the Language Preference option for Internet Explorer to a language that uses the comma as the decimal separator, decimal values that appear because of the drillthrough action on an analytical report are incorrect in the exported Excel workbook.
Symptoms Consider the following scenario.
You set the Language Preference option for Internet Explorer to a language that uses the comma as the decimal separator. For example, you set the Language Preference option to German (Germany).
You perform the drillthrough action on an analytical report, and then export the result to an Excel workbook.
When you open the Excel workbook, you notice that decimal values are incorrect in the following pattern:
The decimal comma is removed from the original value.
A decimal period appears at the end of the original value.
The new value has zeros on decimal places. The number of zeros is equal to the number of decimal places in the original value.
For example, the original decimal value is 49,1234. The new decimal value is 491,234.0000.
When you use a user account that does not have access to a table view to view a scorecard that displays data from the table view, you can still see the data.
Symptoms Consider the following scenario.
You create a data source that uses the SQL Server Table template.
The data source connects to a view in a SQL Server database.
You create a scorecard that uses the data source.
When you view the scorecard by using a user account that does not have access to the view in the SQL Server database, you can still see the data from the view.
When you perform a drillthrough action on a cell in an analytical grid, the pop-up window shows the result from an earlier drillthrough action.
Symptoms You create more than two drillthrough actions on a cube. You open an analytical grid whose data is from the cube. You perform one drillthrough action on a cell. Then you close the pop-up window. When you perform another drillthrough action on the same cell, the pop-up window still shows the result from the first drillthrough action.
You cannot perform the Show Details action on a value that contains a plus sign (+).
Symptoms When you perform the Show Details action on a value that contains a plus sign (+), you receive an error message.
When you view a ProClarity Analytics Server Page report that is linked to a filter, columns in the report are sorted in descending order.
Symptoms You create a ProClarity Analytics Server Page report in Dashboard Designer. You create a dashboard that displays the report. Additionally, a filter in the dashboard is linked to the report. When you view this report, you notice that columns in the report are sorted in descending order. However, you expect the columns to be sorted in ascending order.
When you add a dimension member under the members from a named set whose expression uses the TOPCOUNT keyword, many duplicate dimension members are added.
Symptoms Consider the following scenario.
You create a named set in a cube. The expression of the named set uses the TOPCOUNT keyword.
In Dashboard Designer, you add the named set under a KPI in a scorecard.
In the scorecard, you add a dimension member under the members from the named set.
When you update the scorecard view, many duplicate dimension members appear under each member from the named set. The number of duplicate dimension members is the same as the number of members from the named set. However, you expect only one dimension member to appear under each member from the named set.
When you open a scorecard, the scorecard takes a long time to be displayed if the scorecard contains many indicator images.
Symptoms You have a scorecard that contains many indicator images. For example, the scorecard contains 500 indicator images. When you open the scorecard, the scorecard takes a long time to be displayed.
Analytic charts or analytic grids that are linked to the Display Condition option of filters are displayed as blocks of spaces.
Symptoms Consider the following scenario.
In Dashboard Designer, you create a dashboard that contains six zones in vertical layout.
You add filters to the first zone, to the third zone and to the fifth zone.
You set the Orientation setting of the second zone and of the sixth zone to Horizontal.
You add many analytic charts or analytic grids to the second zone or to the sixth zone. The analytic charts or analytic grids have fixed pixel width and fixed pixel height.
You link the Display Condition option of the filters to the analytic charts or to the analytic grids.
When you view the dashboard, the analytic charts or analytic grids that are not supposed to be displayed are displayed as blocks of spaces.
A zone in a dashboard has a fixed height if you set the Orientation setting of the zone to Vertical.
Symptoms Consider the following scenario.
In Dashboard Designer, you create a dashboard that contains six zones in vertical layout.
You add filters to the first zone, to the third zone and to the fifth zone.
You set the Orientation setting of the second zone and of the sixth zone to Vertical.
You add analytic charts or analytic grids to the second zone or to the sixth zone. The analytic charts or analytic grids have fixed pixel width and fixed pixel height.
After you add many analytic charts or analytic grids, you notice that the boundary of the zone is reached. If you add more analytic charts or analytic grids, these analytic charts or analytic grids are inaccessible.
You cannot drag an object from a zone that is visible to a zone that is not visible in Dashboard Designer.
Symptoms You create a dashboard that contains multiple zones in Dashboard Designer. You adjust the size of Dashboard Designer to make one or more zones invisible. Then, you add an object to a zone that is visible in Dashboard Designer. When you try to drag the object to a different zone that is not visible in Dashboard Designer, the scroll bar does not let you scroll down to the destination zone.
You cannot customize the Help URL for Web parts in dashboards that are published to a SharePoint Web site.
Symptoms You cannot customize the Help URL for Web parts in dashboards. Even if you change the Help URL for a Web part, the URL still points to the PerformancePoint Server Help.
The Show Details option is disabled for KPIs that map to MDX tuple formulas.
Symptoms You create a KPI that maps to a MDX tuple formula in Dashboard Designer. When you view this KPI in a dashboard, you notice that the Show Details option is unavailable. This problem does not occur if the KPI maps to a measure.
Zones that contain Excel Services reports start to update automatically after other stacked zones are updated.
Symptoms You have a dashboard that contains the following two zones:
A zone that displays an Excel Services report.
A zone that displays two other kinds of reports. The Orientation setting of the zone is Stacked.
After you open the dashboard, you switch to a different report in the stacked zone. After the stacked zone is updated, the zone that displays the Excel Services report starts to update automatically. However, no update occurs on the Excel Services report.
Installation details
How to obtain PerformancePoint Server 2007 SP3
The following file is available for download from the Microsoft Download Center:
The following list contains prerequisites for the hotfix:
Microsoft Office PerformancePoint Server 2007 must be installed before you apply this service pack.
Note
You must apply this service pack on all client computers and servers that have the affected component of PerformancePoint Server 2007 installed.
To apply this service pack, you must run the following PerformancePoint Planning installation files that are appropriate for your situation:
The Planning Server Pplsrv.msp installation file
This installation must be completed on the Planning server only.
The Planning Excel Client Pplxcli.msp installation file
This installation must be completed on all client computers that are running PerformancePoint Add-in for Excel.
The Planning Business Modeler Pbmcli.msp installation file
This installation must be completed on all client computers that are running PerformancePoint Planning Business Modeler.
To apply this service pack, you must run the PerformancePoint Monitoring installation files that are appropriate for your situation:
The Monitoring Server Pscsrv.msp installation file
This installation must be completed on the Monitoring server only.
Back to the top
