List of issues that are fixed in Microsoft Office PerformancePoint Server 2007 Service Pack 1

Microsoft Office PerformancePoint Server 2007 Service Pack 1(SP1) includes the latest updates to PerformancePoint Server 2007. This article describes the issues that are fixed in PerformancePoint Server 2007.

The build of PerformancePoint SP1 is 3.0.3917.00

For more information about PerformancePoint Server 2007 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:

Issues that are fixed

PerformancePoint Server 2007 SP1 fixes the issues that are described in the following Microsoft Knowledge Base articles:








PerformancePoint Server 2007 SP1 also fixes the following issues that were not previously documented in the Microsoft Knowledge Base articles:

• You have a strategy map that is linked to a filter in Visio. When you open the strategy map, the strategy map displays incorrect filter value.
  
• The Microsoft Dynamics Axapta data provider will no longer be included in the Data Import Wizard for PerformancePoint Server 2007 SP1.
  
  The Data Import Wizard for PerformancePoint Server 2007 SP1 is now a generic data integration wizard that requires customers and partners to develop their own data providers to integrate 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. Therefore, the Data Import Wizard for PerformancePoint Server 2007 SP1 is not limited to the data providers for Microsoft products.
  
  To obtain this toolkit, visit the following Microsoft Web site:
  http://go.microsoft.com/fwlink/?LinkId=117552&clcid=0x409 (http://go.microsoft.com/fwlink/?LinkId=117552&clcid=0x409)
  
  
  Important The Data Import Wizard for PerformancePoint Server 2007 SP1 will not be released together with PerformancePoint Server 2007 SP1. The Data Import Wizard for PerformancePoint Server 2007 SP1 will be released later in June.
• You use the Report Wizard to define a filter scope. In the displayed report, you can still select all the members. However, you expect that only the members that you define in the filter scope are available for selection.
  
• The Microsoft Dynamics Axapta data provider will no longer be included in the Data Import Wizard for PerformancePoint Server 2007 SP1. The text reference to Microsoft Dynamics AX is removed from the Data Import Wizard user interface. For example, when you install the Data Import Wizard for PerformancePoint Server 2007 SP1, the title of the installation wizard changes from "Data Import Wizard for Microsoft Dynamics AX Setup" to "Data Import Wizard Setup."
  
  Important The Data Import Wizard for PerformancePoint Server 2007 SP1 will not be released together with PerformancePoint Server 2007 SP1. The Data Import Wizard for PerformancePoint Server 2007 SP1 will be released later in June.
  
• Consider the following scenario. You use the Data Import Wizard to load data into PerformancePoint Server 2007 by using the Financial Data Mart (FDM) data provider. The data range that you specify for the import operation is broader than the FDM calendar date range. In this scenario, the Data Import Wizard does not open.
  
  Important The Data Import Wizard for PerformancePoint Server 2007 SP1 will not be released together with PerformancePoint Server 2007 SP1. The Data Import Wizard for PerformancePoint Server 2007 SP1 will be released later in June.
  
• In PerformancePoint Server 2007 SP1, the application upgrade functionality is added in the Planning Server Configuration Manager.
  
• The name of the .dll file for the Data Import Wizard for PerformancePoint Server 2007 SP1 is changed. The original name is PPSPlanningAXImportWizard.resources.dll. The new name is PPSPlanningImportWizard.resources.dll.
  
  Important The Data Import Wizard for PerformancePoint Server 2007 SP1 will not be released together with PerformancePoint Server 2007 SP1. The Data Import Wizard for PerformancePoint Server 2007 SP1 will be released later in June.
• You want to deploy PerformancePoint Server 2007 in an environment where Kerberos delegation for PerformancePoint Server 2007 is required. However, you cannot install the Planning Web services if other applications that also require Kerberos delegation exist on the same computer. For example, you cannot install Planning Web services together with Monitoring and Analytics Server on the same computer.
  
  In PerformancePoint Planning Server 2007 SP1, this limitation is removed for Planning Web services.
• When you use a strategy map in a report view, you cannot apply more than one filter to the strategy map as a Page dashboard endpoint Item.
  
• The Data Import Wizard for PerformancePoint Server 2007 SP1 uses .wizardConfig files. Old configuration files (.importConfig) can no longer be recognized or used by the Data Import Wizard for PerformancePoint Server 2007 SP1.
  
  Note The Data Import Wizard for Microsoft Dynamics AX uses .importConfig files.
  Important The Data Import Wizard for PerformancePoint Server 2007 SP1 will not be released together with PerformancePoint Server 2007 SP1. The Data Import Wizard for PerformancePoint Server 2007 SP1 will be released later in June.
• You use a locale that displays the date in the "Day - Month - Year" format. When you load a dashboard that contains a Time Intelligence (TI) Post Formula filter for the first time, the current date is displayed incorrectly. For example, you encounter this problem if you use the French locale.
  
• Support for the IIS compression feature is added in PerformancePoint Server 2007 SP1.
  
• You set the Enable Annotations property of a model to False. Then, you deploy the model. When you try to display a matrix that uses this model, you receive the following error message:
  Cannot render the Matrix1 matrix. The server returned the following error: Query (1, 63) The member '[Annotations Test_MeasureGroup_AnnotationCount]' was not found in the cube when the string, [Measures].[Annotations Test_MeasureGroup_AnnotationCount], was parsed.
  
  
• You deny a user access to an attribute of a cube in Microsoft SQL Server 2005 Analysis Services. You create a scorecard that displays the attribute. When the user views the scorecard, the attribute is displayed. Additionally, the value of the attribute is 0.
  
• Planning Business Modeler Help and PerformancePoint Add-in for Excel Help describe whether data movement jobs can be run in PerformancePoint Add-in for Excel. However, the descriptions in these Help files are not consistent.
  
  Note The description in the Planning Business Modeler Help file is correct.
  
• You install the Data Import Wizard on the same computer as PerformancePoint 2007 Management Reporter. When you start the Data Import Wizard, the Data Import Wizard closes unexpectedly. Additionally, you receive the following error message:
  An unhandled exception has occurred. The CLR is terminating. Could not load type 'Microsoft.PerformancePoint.DataServices.Core.CompanySettingCollection' from assembly 'Microsoft.PerformancePoint.DataServices.Core, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.
  
  Important The Data Import Wizard for PerformancePoint Server 2007 SP1 will not be released together with PerformancePoint Server 2007 SP1. The Data Import Wizard for PerformancePoint Server 2007 SP1 will be released later in June.
  
• You use the Time Intelligence Post Formula filter. When you select a date in the calendar control, the date that is displayed is one day before the date that you selected.
  
• When you set display conditions on reports in Dashboard Designer, the default report is not displayed.
  
• In the "Flow dimension members" topic in PerformancePoint Planning Business Modeler Help, the Closing member is described as a system-calculated flow member. However, the Closing member is a user-modifiable flow member.
  
• When you view the details of a cell in a scorecard, you receive the following error message:
  Cannot show details for this cell because both the row and column must have a selection.
  This problem does not occur in an Analytic Grid.
  
• It takes less time to reopen assignments that contain lots of changes. Additionally, a new option enables form templates to automatically remove all the changes that you made in an assignment after you trigger a workflow action. For example, a submit operation is a workflow action. Therefore, the performance is improved when you work on an assignment. However, it may take longer to process a workflow action when the changes that are recently submitted do not exist in an assignment. This is because the changes are processed by the server and no longer exist locally.
  
• As you add more matrices to the worksheets in PerformancePoint Add-in for Excel, the time to refresh a worksheet is longer.
  
  
• You have an assignment that contains a large matrix. The matrix contains formulas in matrix cells. When you open this assignment in PerformancePoint Add-in for Excel, the matrix takes a long time to be displayed.
  
• You have a Time Intelligence Post Formula filter or a Time Intelligence filter. The filter value is passed on across levels of other elements. However, the value cannot be passed to the last element.
  
• Consider the following scenario. You republish a form template for an assignment. Then, you perform an Update Running Instances action for the assignment definition in Planning Business Modeler. If a contributor does not submit the assignment, the contributor sees only the updated form template. However, if a contributor has submitted the assignment, the contributor sees the original form template. A new action is now available to contributors. After a contributor submits an assignment, this new action removes the form template in the submitted assignment. This makes sure that the contributor always obtains the most current form template for the assignment.
  
• You create a key performance indicator (KPI) in Dashboard Designer. You specify a Multidimensional Expressions (MDX) query to be the MDX tuple formula for the actual value or for the target value of the KPI. However, the MDX query has a limit of 1000 characters.
  
  In PerformancePoint Server 2007 Service Pack 1, the limit is removed.
  
• You use the importsecurity command to perform an initial import of the role permissions on a hierarchy. When you import the role permission again, the hierarchy permission is changed to "Read + Write."
  
• You have a dimension that contains a hierarchy of multiple levels. When you use the PPSCMD utility together with the overrideexistingmember flag to import the dimension, the import operation fails.
  
• You create a strategy map in a dashboard. You add a multi-select dashboard filter that is mapped to the strategy map. If you select more than four members in the dashboard filter, you receive the following error message when you view the strategy map:
  The Microsoft Office Visio Viewer cannot load the specified URL or file.
  However, first three members are displayed successfully.
  
• When you restore the PDW.abf file in SQL Server 2005 Analysis Services, you receive the following error message:
  The level '[1-08]' object was not found in the cube when the string, [Time].[Week].[1-08], was parsed. (Microsoft.AnalysisServices)
  
  
• When you have an application whose label contains a space, you cannot open an assignment in the application in a Web browser. The problem usually affects the users who use the workflow notification feature.
  
• You have a scorecard that uses a tabular data source. For example, the scorecard uses an Excel worksheet as the data source. When you apply a filter to the scorecard, values in the scorecard appear as "ERROR."
  
• You remove the Write permission on the following folder for a user who is supposed to open assignments:
  C:\Documents and Settings\All Users\Application Data
  When the you use the user's credentials to open an assignment, you receive the following error message:
  Access to the path C:\Documents and Settings\All Users\Application Data\FileName.tmp is denied.
  
  
• You have a child KPI that is under a hidden parent KPI. You expand the child KPI. When you collapse the child KPI, child KPIs that are under other hidden parent KPIs disappear.
  
• When you refresh a large matrix that contains many changes in PerformancePoint Add-in for Excel, the performance of the refresh operation improves.
  
• You create an MDX query in a business rule that uses some special arguments. For example, the business rule uses one of the following arguments:
  • EXCLUDEEMPTY
  • INCLUDEEMPTY
  • SELF
  • LEAVES
  If the MDX query contains a semantic error on these arguments, the PEL compiler displays only a generic error message when you deploy the rule. However, you expect that the compiler will specify the location of the semantic error.
  
• You create a business rule in a Spanish version of PerformancePoint Server 2007. When you try to specify the rule type, two items of the same name appear in the Type list.
  
  This issue occurs because the word Allocation and the word Assignment have the same translation in Spanish.
  
• You create a self-referencing member property in a dimension. However, some attributes in the dimension are associated incorrectly with the self referencing member property.
  
• When you view a scorecard that contains negative values, text after the minus sign (-) is wrapped.
  
• You create some nested rule sets in a business model. Then, the size of the rule dataset grows for each deployment.
  
• When you refresh a matrix that contains many page filters, the performance of the refresh operation improves.
  
• You use the Report Wizard to create a report by using the InterCompany Reconciliation report template. The rule that you specify for this report runs against the "All Members" member of a dimension. When you view this report, you receive the following error message:
  Error when executing MDX Query.
  
  
• In PerformancePoint Add-in for Excel, you change the cell style for a cell. Then, you lock the sheet that contains this cell. When you click Restore cell style defaults, the cell style of the cell is not reset.
  
• You add an annotation to a cell in PerformancePoint Add-in for Excel. Then, you click Show Current Changes. In the Change Sheet, the annotation that you added appears in the column that is next to the Annotation column.
  
• You open an assignment in PerformancePoint Add-in for Excel. Then, you insert a comment to a cell. However, you cannot resize the comment input window.
  
• Consider the following scenario. In PerformancePoint Business Modeler, you have two models that are named MA and MB. You add dimensions to these models. For example, you add D1 to MA, and then you add D2 to MA. Next, you add D4 to MB, and then you add D3 to MB. You create an allocation rule to map dimension members between these models. In the allocation rule, the order in which the dimensions appear differs from the order in which you added the dimensions to the corresponding model. For example, in the allocation rule, D3 appears first. Additionally, D4 appears second. Also, the allocation rule contains member sets that have a different number of members. Or, the allocation rule contains a member and a member set.
  
  Assume that you map ({D1.[All Members].Mem1, D1.[All Members].Mem2}, D2.[All Members].Mem3) to ({D3.[All Members].Mem4, D3.[All Members].Mem5}, D4.[All Members].Mem6). When you validate the allocation rule in PerformancePoint Business Modeler, you receive the following error message:
  Member set is not defined correctly for cross model mapping. The number of members in source and target member sets in cross model mapping must match.
• Consider the following scenario. You have a hierarchical member set. You create a business role in Planning Business Modeler. On the Role tab for this business role, you click the member set. In this scenario, only some members in the member set are displayed.
  
  This is a user interface problem only.
  
• The RowId column of the measure group tables contains a redundant unique index.
  
• You create a dashboard filter that uses the Tree display method. The filter contains many members. When you view the dashboard, the tree view is displayed slowly.
  
• In PerformancePoint Add-in for Excel, you click the Add new matrix button in the Authoring pane for the first time. Then, the following issues occur:
  • The Authoring pane moves ahead.
  • The mouse pointer points to the Add new matrix with wizard button.
• You start a cycle instance. Additionally, you create an instance of the form assignment in the cycle instance. Then, you start another cycle instance. However, you cannot create the instance of the form assignment in this other cycle instance.
  
• You open an assignment in PerformancePoint Add-in for Excel. You perform a drillthrough operation, or you click Show Current Changes. When you click the Compare with Server button, you receive the following error message:
  Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))
  
  
• When you click Add Found in the Select Members dialog box, you receive the following error message:
  Object reference not set to an instance of an object
  
  
• In PerformancePoint Add-in for Excel, you submit changes to an assignment. As soon as you submit the changes, you lock the cycle instance that contains the instance of this assignment. To do this, you set the Hard parameter to "true" in Planning Business Modeler. When you refresh the assignment in PerformancePoint Add-in for Excel, you expect to receive an error message for the locking operation. However, you receive the following irrelevant error message:
  The model selected for calculation job jobName is not part of the model site the calculation job is saved to.
  
  
• You create a member in a dimension in Planning Business Modeler. The label of the member contains brackets. Then, you create a business role. You also set the business role to have access to the member. When you save this business role, you receive the following error message:
  The following items cannot be saved
  
  
• You have a report that executes a complex query. This query runs for a long time. You open the report in your Web browser. Before the report is displayed, you click Stop the report rendering process. You repeatedly refresh the report and stop the report rendering process several more times. In this scenario, the CPU usage of the SQL Server 2005 Analysis Services service is high.
  
• You have a model site that contains a data destination connection. You migrate the application that contains this model site to another planning server. In the Planning Administration Console, you edit the data destination connection that is migrated together with the model site. When you try to create a database for this destination data connection, you receive the following error message:
  Your outbound operation failed. (Error code: PerformancePoint_225000066)
  
  
• In the x64-based version of PerformancePoint Add-in for Excel, you click Run Diagnostics. In the result, the value of the MonikerForMachine element is URL: PerformancePoint Protocol.
  
  This problem occurs because the x64-based version of PerformancePoint Add-in for Excel does not access the corresponding registry entries under the Wow6432Node registry subkey.
  
• In Planning Business Modeler, you create a member property in a dimension. You specify the member property to links to a member of another dimension. When you save the model, you receive the following error message:
  The attempt to save the model site failed.
• In Planning Business Modeler, you set a member as the default member of a member set. After you deploy the model site that contains this member set, you change the label of the member. When you deploy the model site again, you receive the following error message:
  The attempt to deploy, Root Site, to the model or model site failed. (Error code: PerformancePoint_1050200270)
  
  
• You create a business rule by defining a scope of members. The members for the business rule differ from the members in the member set for the model that contains this business rule. When you deploy the model, you receive the following error message:
  Some of the model's dimension members are invalid or missing. The model may need to be redeployed.
  This error message does not point you to the cause of the error.
  
• You set the Allow data entry property of a matrix to "False" in PerformancePoint Add-in for Excel. However, the data cells in the matrix are still formatted as writable.
  
• You open Planning Business Modeler by using a user who is a member of the User Administrator role only. In Planning Business Modeler, you make some changes to the model site. Then, you stop the Planning Web service. When you try to save the changes by creating a local recovery file, you receive the following error message:
  Error occurred while unloading plug-in ModelerPlugin: Object reference not set to an instance of an object
  
  
• In Planning Business Modeler, you open the Select Members dialog box to select members of a hierarchical member set. When you click a root member, and then click the down arrow on the Add button, the Add Ancestors item is available. However, you expect that this item is unavailable because the member that you select is a root member.
  
  If you click Add Ancestors, you receive the following error message:
  Object reference not set to an instance of an object.
• Consider the following scenario. You update the default value of a member property of a dimension in Planning Business Modeler. When you open the definition of the table to the dimension in Microsoft SQL Server 2005, the default value of the column that corresponds to the member property is still the original value.
  
• You set the Enable annotations property of a model to "False." Then, you save this model. You add a dimension. When you save this model, you receive the following error message:
  The attempt to save the model site failed:
  The attempt to save object failed for rootSite: (code -2146232832) Unexpected database error occurred. Look in the server log and/or contact your system administrator for more information.
• You have connected to Planning Server by using PerformancePoint Add-in for Excel or you are working offline. If the Catalog.xml file is corrupted, Excel crashes. For example, after you manually clear or perform invalid changes to the content of the Catalog.xml file, Excel closes unexpectedly.
  
  When Excel closes unexpectedly, you receive the following error message:
  Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience.
  
  Note The Catalog.xml file is in the following folder:
  %userprofile%\Local Settings\Application Data\Microsoft\PerformancePoint\OfflineCache\Sumtgmea
• When PerformancePoint Server requests a Kerberos ticket to access the Planning Web service, PerformancePoint Server is denied access. This is because PerformancePoint Server does not include the Planning Web service port in the request.
  
• In Planning Business Modeler, you create a member property in a dimension. The member property references a member of the dimension. You create a member view that groups members by this member property. Then, you deploy the model site to SQL Server 2005 Analysis Services. When you browse the hierarchy that represents the member view in SQL Server 2005 Analysis Services, the hierarchy structure differs from the structure of the member view.
  
• In Planning Business Modeler, you create a member property in a dimension. The member property references a member of the dimension. You create a member in the dimension. Additionally, you set the member property of the member to NULL. Then, you deploy the model site. When you browse the dimension in SQL Server 2005 Analysis Services, the member that you created does not exist.