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

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

This post is part of a series focussing on installing and configuring PerformancePoint Monitoring Server across multiple servers e.g. SharePoint Farm.  Other parts can be found here:




In this part, I will step through configuring the ‘Dashboard Viewer for SharePoint Services’ – AKA PerformancePoint Web Part.

This step will be carried out on our SharePoint WFE. In this case, we only have one WFE, but this step will need to be repeated for all WFE’s in the farm.


I cannot stress the importance of making sure you have all your pre-reqs installed, PRIOR to installing PPS Monitoring Server and SP3 on this WFE.  If you haven’t, or not sure, go back a check the list on Part 1.

Configuring the PerformancePoint WebPart / MasterPage

Right, now we’re set, run the Monitoring Server Config Wizard, and you should be presented with the pre-req check screen, which should all light up green except the SSRS components (unless you have SSRS installed on your WFE). Click Next.


On the next screen, ensure that ‘Distributed Configuration’ is selected, and ensure that the only component selected is ‘Dashboard Viewer for SharePoint Services’ (remember we configured the Monitoring database and Web Service in Part 2). Click Next.


Next, you’ll be asked for the SQL Server and Database Name. This is so the Web Part can locate the published dashboards and dashboard items for display.  Enter these details and click Next.


The final piece of information is a Site Collection URL on which to deploy this component.  Now this is actually a bit misleading.

There are essentially two components deployed here:

1. The PerformancePoint Dashboard WebPart will be added to the GAC and deployed as a solution to the Web Application containing the selected Site Collection above.

2. A dashboard master page will be deployed to the chosen Site Collection. This will be used by default when deploying an entire dashboard to that SharePoint Site Collection. If you’re like me and just add the Web Part to your existing Master Page, you wont be too fussed which Site Collection you select.

So taking all that in, select an appropriate Site Collection and click Next.


You should see confirmation that we are ready to proceed, click Next.


Finally, double check your settings and click ‘Configure’.


Fingers crossed, this component will be installed successfully!


Most issues arise from the following causes:

– The pre-requisites haven’t been installed successfully prior to installing PPS 2007 Monitoring Server and SP3 (prior to installing PPS, not prior to configuring).

– The user account running the Configuration Wizard doesn’t have permissions to add assemblies to the GAC or solutions to the SharePoint Central Admin solution store.

– The user account running the Configuration Wizard doesn’t have Site Collection Admin rights on the Site Collection selected in the Config Wizard.

Next, we shall look at setting up Dashboard Designer ready to begin creating some BI Dashboards!

Categories: Uncategorized Tags:
  1. October 16, 2013 at 6:17 am


    I am getting this error while connecting to sql server “the sql server instance must be running on sql server 2005 sp2”

    My sql version is Microsoft SQL Server 2005 – 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    Krunal Jani

  2. Tobias West
    August 19, 2010 at 4:39 pm


    I’d Just like to thank you for the detailed steps, I’ve been battling with installing PPS on a dist. env. and this particular part of the walkthrough helped as I was missing a key part out!

  1. April 26, 2010 at 11:50 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: