Article ID: 970496 - View products that this article applies to.
This article has been archived. It is offered "as is" and will no longer be updated.
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page

INTRODUCTION

This article describes the known installation issues, deployment issues, and best practices in Microsoft Office PerformancePoint Server 2007.

Known issues in PerformancePoint Server 2007

The following issues are known to occur in PerformancePoint Server 2007 in specific circumstances. Each issue that is listed here is individual and has no relation to the other issues. All information is presented "as is" and without warranty or guarantee.

Issue 1: Error message when you connect to PerformancePoint Monitoring Server from PerformancePoint Dashboard Designer: "Unable to connect to Server"

Symptoms
You install the Microsoft .NET Framework 3.5 before you install PerformancePoint Monitoring Server. Then, when you connect to PerformancePoint Monitoring Server from PerformancePoint Dashboard Designer, you receive the following error message:
Unable to connect to Server
Resolution
To resolve this problem, reinstall Microsoft ASP.NET AJAX 1.0 after you run the Monitoring Server Configuration Manager for the first time. By doing this, you can restore Windows SharePoint Services site functionality or Microsoft Office SharePoint Server site functionality.

Issue 2: A runtime error occurs when you connect to Office SharePoint Server from PerformancePoint Dashboard Viewer for SharePoint Services

Symptoms
You install Office SharePoint Server on a computer. Then, you install PerformancePoint Dashboard Viewer for SharePoint Services on the same computer. When you connect to Office SharePoint Server from PerformancePoint Dashboard Viewer for SharePoint Services, you encounter a runtime error. When this problem occurs, an event that describes an ASP.NET configuration warning is logged in the Application log. The description of the event is as follows:
Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
Resolution
To resolve this problem, reinstall ASP.NET AJAX 1.0 after you run the Monitoring Server Configuration Manager for the first time to restore SharePoint site functionality.

Issue 3: You cannot install Microsoft SQL Server 2005 Management Objects Collection (XMO 9.0) on a computer that is running the SQL Server Reporting Services Add-in for Microsoft SharePoint Technologies

Symptoms
You install the SQL Server Reporting Services Add-in for Microsoft SharePoint Technologies, or you run SQL Server Reporting Services in SharePoint Integrated mode. In this situation, you cannot install SQL Server 2005 Management Objects Collection (XMO 9.0) on the same computer. This causes the following problems:
  • You cannot install PerformancePoint Planning Server, which requires XMO 9.0.
  • You cannot import KPIs from SQL Server because the import operation requires XMO 9.0 to connect to SQL Server.
Cause
This problem occurs because XMO 9.0 cannot be installed on a computer that is running the SQL Server Reporting Services add-in.

Note When you run SQL Server Reporting Services in SharePoint Integrated mode, the SQL Server Reporting Services add-in is installed.
Resolution
To resolve this issue, use one of the following methods.

Method 1

Install XMO 9.0 and the SQL Server Reporting Services add-in on separate computers. These products are not intended to be installed on the same computer as a production system. A single computer installation is intended only to provide a proof-of-concept environment for testing.

Method 2

Run SQL Server Reporting Services in native mode instead of in SharePoint Integrated mode. When SQL Server Reporting Services runs in native mode, the SQL Server Reporting Services Add-in is removed from the computer.

Method 3

If you want to import KPIs from SQL Server, you can manually re-create the KPIs in Dashboard Designer instead of importing the KPIs.

How to obtain and install optional components of PerformancePoint Server 2007

Microsoft Office Web Components (OWC) for pivot charts

These components work only on 32-bit Windows operating systems. For more information, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en

Visio for strategy maps

You must install Microsoft Office Visio on all computers where you want to create strategy maps. For more information, visit the following Microsoft Web sites:

Report Viewer for SQL Server Reporting Services

To download and install Report Viewer for SQL Server Reporting Services on client computers, use the following download links. For Report Viewer for SQL Server 2005 and for versions of PerformancePoint Server 2007 that are earlier than PerformancePoint Server 2007 Service Pack 2, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?FamilyID=e7d661ba-dc95-4eb3-8916-3e31340ddc2c&DisplayLang=en
For Report Viewer for SQL Server 2008 and for PerformancePoint Server 2007 Service Pack 2, visit the following Microsoft Web site:
http://www.microsoft.com/downloads/details.aspx?familyid=BB196D5D-76C2-4A0E-9458-267D22B6AAC6&displaylang=en
Note The Report Designer component is also available from the SQL Server 2005 installation CD. The Report Designer component is included with Business Intelligence Development Studio. For more information, visit the following Microsoft TechNet Web site:
http://technet.microsoft.com/en-us/library/bb838753.aspx

Issue 4 Prerequisite issue with PerformancePoint Planning.

When you try to install PPS Planning and you do not have SQL Server Native Client SP2 installed the installation fails.
Resolution
  To resolve this issue follow the steps in the following Microsoft Web Site: http://technet.microsoft.com/en-us/library/dd335965.aspx


Issue 5 PerformancePoint SP3 Add-in for Excel breaks Hot Keys to some functionality in Microsoft Excel

In a Microsoft Excel environment with the PerformancePoint Add-in for Excel with Service Pack 3 installed, the ability to use hot keys like Enter/Tab does not work. 

Resolution
To resolve this issue, use one of the following methods.  

Method 1
Use the other paste commands of Ctrl+V or Right Click menu then left click Paste.

Method 2
Go into Excel with the Add-in installed and disable it temporarily to use the Enter key paste function, you can do this by doing the following:
1. Windows Button
2. Excel Options
3. Add-Ins section
4. Manage: COM Add-ins and click Go...
5. Un-check PerformancePoint Add-In for Excel
6. Click OK

Method 3
Remove Service Pack 3 for the PerformancePoint Add-in for Excel from the computer you're trying to use the Enter key to paste in.Resolution
To resolve this issue, use one of the following methods.  

Best practices

Before you install the PerformancePoint Dashboard Viewer component for SharePoint Services, we recommend that you manually back up the Web.config file that is associated with the SharePoint Web application. By default, the location of the Web.config file for a Web application on port 80 is as follows:
C:\inetpub\wwwroot\wss\VirtualDirectories\80\Web.config

Properties

Article ID: 970496 - Last Review: January 16, 2015 - Revision: 4.0
Applies to
  • Microsoft Office PerformancePoint Server 2007, 32 Bit Edition
  • Microsoft Office PerformancePoint Server 2007, 64 Bit Edition
Keywords: 
kbnosurvey kbarchive kbsurveynew kbexpertiseadvanced kbhowto kbinfo KB970496

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com