Home > Uncategorized > Installing and Configuring PerformancePoint Server 2007 in a Distributed Environment (Part 1)

Installing and Configuring PerformancePoint Server 2007 in a Distributed Environment (Part 1)

Welcome to a multi-part blog on installing and configuring PerformancePoint Server 2007 on a multi-server SharePoint farm. Other parts can be found here:




I’ve been meaning to blog this for a while, but a recent task to install and configure PPS in a 3 server MOSS Farm has prompted me to finally do it.

This will be a multi-part blog, beginning with the scenario and general approach.


We have a 3 server MOSS Farm (WFE, APP Server and Database Server) and the requirement is to install and configure MS PerformancePoint Server 2007 (Monitoring and Analytics) onto this environment.  We do not have the luxury in this case of having a separate server to host PPS.


PPS Monitoring Components Overview

PPS Monitoring Server contains multiple parts:

Monitoring System Database

This will reside on your SQL Server and will contain all the published dashboards, dashboard items and data sources, in addition to security info.

Pre-reqs: SQL Server (2005/2008/2008 R2)

Monitoring Web Server

This comprises of a new IIS Web Site and three virtual directories to support the main Monitoring Web Service, Dashboard Preview and Dashboard Designer Installation Site (Monitoring Central). This component obviously needs to be configured on a server which has the Web Server role (IIS).

Pre-reqs: IIS, SQL Server Native Client 9.0 (SP2), ADOMD.NET 9.0 (SP2), ASP.NET 2.0 AJAX Extensions

Scorecard Viewer for SSRS

This is an interface for deploying scorecards to SSRS in RDL format.  This component will need configuring on your SSRS server and requires SSRS to be installed and configured ready.

Pre-reqs: SSRS

Dashboard Viewer for SharePoint Services

This is effectively a Web Part for connecting to and rendering PPS Dashboard Items.  Obviously this piece requires WSS but seeing as AJAX is used, the ASP.NET 2.0 AJAX Extensions are required on the server too.

Pre-reqs: WSS 3.0, ASP.NET 2.0 AJAX Extensions v1.0

Monitoring Plug-In for Visual Studio (BIDS)

This allows for the customisation of RDL Scorecards from within a developers BIDS/Visual Studio environment.  Obviously this is only required on a developer machine.

Pre-Reqs: Visual Studio Report Designer (BIDS)

Pre-Requisite Software Required

Just to clarify, the following table lists the pre-requisite software you require on each server, appropriate to the component you wish to configure.  PPS 2007 is very fussy about this, and even though the installation will not complain, I have seen many configuration issues arise due to the pre-requisites NOT being installed prior to PPS Installation (not configuration).

Ensure these are 64-Bit if your server and PPS install is 64-bit

PPS Component Pre-Requisites
Monitoring Database None (aside from SQL Server obviously)
If wishing to install the PPS Monitoring Database (as opposed to overlaying the schema only) ensure the user running the config wizard has a SQL Login with dbcreate rights.
Monitoring Web Service ASP.NET 2.0 AJAX Extensions v1.0
SQL 2005 SP2 CU9 Client (sqlncli.msi)
SQL 2005 SP2 CU9 Analysis Services ADOMD
SQL 2005 SP2 CU9 Analysis Services OLEDB Provider (ASOLEDB9.msi)
Dashboard Viewer for SharePoint (Web Part/Master Page) ASP.NET 2.0 AJAX Extensions v1.0
SQL 2005 SP2 CU9 Client (sqlncli.msi)
SQL 2005 SP2 CU9 Analysis Services ADOMD
SQL 2005 SP2 CU9 Analysis Services OLEDB Provider (ASOLEDB9.msi)

PPS Monitoring Installation & Configuration Approach

The general approach will be as follows:

Before beginning to install PPS 2007, ensure your SharePoint Farm is all configured correctly and working. 

1. Ensure al the pre-requisite software is installed on each server appropriate to the PPS Monitoring components you wish to configure on there (see the components overview above).

NOTE: Even if SQL Server 2008/2008 R2 is being used as your database server, there is still a requirement to install component from the SQL 2005 SP2 CU9 Package (http://support.microsoft.com/kb/953752).  PPS Monitoring components will only communicate with SQL Server via these interfaces. Also, a minimum of PPS 2007 SP2 is required in this case (prior to SP2, PPS 2007 wasn’t supported on SQL 2008).

2. Install PerformancePoint Monitoring Server 2007 (RTM) (PSCSrv.msi) on each server BUT DO NOT RUN THE CONFIG WIZARD (yet)

3. Install the service pack you desire on each server (the final service pack released by Microsoft was SP3 in September 2009) (PSCSrv.msp).  DO NOT RUN THE CONFIG WIZARD (yet)

4. Consider the best place to host the main Monitoring Web Server component

My personal preference is usually to host this component on your MOSS Application server.  Essentially the Monitoring Server is a service which will be requested by MOSS WFEs, in addition to clients connecting directly via Dashboard Designer.  If we think about SharePoint 2010, PerformancePoint is now a managed service application within the service tier of the product, and that is the desired model I aim to achieve in 2007 deployments. 

In addition to this, the Monitoring Server adds an additional IIS Web Site and 3 Application Pools to manage – something which you don’t necessarily want adding to your WFEs, even if this provides resilience via Load Balancing.

Finally, the PPS Monitoring Web Service is designed to be used internally within your organisation (via SharePoint or Dashboard Designer).  Therefore even if you have an Extranet environment it is unlikely you would wish to expose this outside your corporate walls.

5. Configure the PPS Monitoring Web Service (see Part 2)

6. Configure the Dashboard Viewer for SharePoint (Web Part) (see Part 3)

7. Configure the SSRS components if required. (see Part 3)

8. Finally set up and test authoring, publishing and deploying a PPS Dashboard to Monitoring Server and ultimately SharePoint. (see Part 4)

Now see how to configure the PPS Monitoring Web Service in https://macraem.wordpress.com/2010/04/23/installing-and-configuring-performancepoint-server-2007-in-a-distributed-environment-part-2/

Categories: Uncategorized
  1. August 4, 2013 at 7:19 am

    Hello, this weekend is nice for me, for the reason that
    this time i am reading this impressive informative post here at my house.

  2. July 18, 2013 at 5:54 am

    Surgery is advised in only the most extreme of cases Know that
    surgery treatment is actually a last resort procedure that
    is indicated when your symptoms are severe and other treatments
    don’t work.

  3. June 27, 2013 at 12:40 pm

    Very informative article.

  4. May 25, 2013 at 3:10 pm

    Magnificent goods from you, man. I’ve understand your stuff previous to and you are just too wonderful. I really like what you have acquired here, certainly like what you are saying and the way in which you say it. You make it enjoyable and you still take care of to keep it wise. I cant wait to read much more from you. This is actually a great website.

  5. May 14, 2013 at 11:04 am

    Hey! I simply wish to give an enormous thumbs up for the nice information you could have here on this post.

    I will probably be coming back to your weblog for extra soon.

  6. May 7, 2013 at 6:13 pm

    Good day! This is my first visit to your blog! We are
    a collection of volunteers and starting a new project in a community in the same niche.
    Your blog provided us useful information to work on.
    You have done a wonderful job!

  7. April 16, 2013 at 4:18 pm

    Useful info. Fortunate me I discovered your website by chance,
    and I’m shocked why this coincidence did not took place earlier! I bookmarked it.

  8. April 10, 2013 at 3:52 am

    This slim and light tablet comes with specifications that provides high computing power.

    They support USB, HDMI, Wi-Fi, Bluetooth, network adapter, 3G and many more than the standard net books on the
    market. Some manufacturers call their product a Cover while others use the name

  9. December 30, 2012 at 8:45 pm

    I like the valuable info you supply in your articles.
    I will bookmark your blog and check again right here frequently.
    I’m quite certain I will be told plenty of new stuff right right here! Best of luck for the next!

  1. April 26, 2010 at 11:47 pm
  2. April 23, 2010 at 4:44 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: