CEDANIEL.COM

This post applies to PerformancePoint 2007

PeformancePoint 2007 is Microsoft’s Business Intelligence Environment that tightly integrates with Microsoft Office SharePoint Server 2007 (MOSS). This product is very difficult to get a stable installation working, so I decided to add a couple of comments here that helped me as I attempted to dodge all the road blocks involved in the install process. First of all, I guess the good news is that Microsoft has decided to integrate this product with their MOSS 2010 product so a separate install will no longer be needed. I’m not sure if this is a good thing or a bad thing yet.

Here are some things that will help:

• Use MS SQL Server 2005 SP 2 or MS SQL Server 2008 as your database install
• I recommend you use an NT Service account with elevated privileges to the database server. In fact, I recommend you do the entire installation under a service account and setup everything with the service account as the primary administrator of all services.
• Before installing any of the PerformancePoint 2007 services, make sure you have ASP.NET 2.0 AJAX extensions 1.0 found here:
  Click Here
• Before installing any of the PerformancePoint 2007 services, make sure you have ADOMD.NET 9.0 (SP 2) installed found here: Click Here
• Make sure you upgrade your installed services to PerformancePoint 2007 SP2 (as of the time of this post – this is my best recommendation)
• If you do not install PerformancePoint 2007 SP2 you will notice that certain services will be unavailable for install during the installation wizards. Example: Planning Process Service and Planning Web Service will not be available during the installation of PerformancePoint Planning.

Once you are able to successfully connect to a data source with PerformancePoint Designer, you will be able to develop dashboards and post them to MOSS 2007 Document libraries or Reporting repositories. I recommend you using the Enterprise Reporting site template.

Also, if you are unable to connect to a SharePoint List with PerformancePoint Dashboard, you will most likely need to give the PerformancePoint Service Account elevated privileges to the SharePoint Site and List. This service account will be the account used by IIS Application Pool that was created by PerformancePoint during the Install (found in the Identity tab).

DO NOT:

Install .NET Framework 3.5 before installing PeformancePoint Monitoring. After PeformancePoint Monitoring is installed, then install .NET Framework 3.5

Hope this post helps someone. This is a very frustrating product to get working well. More posts to follow with details on the usage of PerformancePoint.