Configuring PerformancePoint services in SharePoint 2010


The following are the configuration steps to get PerformancePoint up and running on SharePoint 2010 enterprise edition. 

As PerformancePoint service is integrated in SharePoint 2010 environment, we need to do some configurations in Sharepoint2010 Central Administration tool.



It also explains what components are enabled with the Site Collection and what Site features are required for storing PPS dashboards, scorecards, and reports in SharePoint Lists and Document Libraries.

  • Starting the PerformancePoint service
  1. Open the SharePoint 2010 central administration and click on System Settings then click on Manage services on server link under Servers category



You will get the following window


Click the start link for the PerformancePoint Service

  •  Activating PerformancePoint Site Collection Feature

1. Open your Business Intelligence site and navigate to Site Actions and click on site settings option as shown below


2. Click on Site Collection Features option from Site Collection Administration


3. Activate the PerformancePoint service from the below list


  • Setting up the Secure Store Account

Without secure store account you cannot access the performance points unattended service account to connect to data sources. PP 2007 uses application pool identity to connect to the data sources where as in 2010 it is domain account whose password is stored in the secure store.

In order to configure Secure Store for PPS, Follow these steps

1. Open SharePoint 2010 central administration toll as shown in below


2. Click on Manage Service Applications under Application Management


3. Click on the Secure Store Proxy and click Manage in ribbon


You will get a message saying ‘Generate a new key’, Click Edit on the ribbon then say Generate a new key

  •  Setting up an Unattended Service Account

1. Go to Central administration Home page

2. Click “Manage Service Applications” under application management

3. Click the PerformancePoint service application as shown below



4. Click on the first link PerformancePoint Service Application Settings


5.In the “Unattended Service Account” section, enter the username and password for querying the data sources


Testing the configuration of Performance Point Service, Open a Performance Point BI Center Site and Click on Run Dashboard Designer button

If you have successfully created a PerformancePoint site collection, you should be able to browse to the BI Center, launch Dashboard Designer, and connect to a data source using the unattended service account.


Share this post :

Related Posts:

  • Dear Mr. Kalyan Bandarupalli,
    I have a question re. step 1. I do not have the option “Central administration – System Settings – Servers – Manage services on server” link on my screen in SharePoint. What am I missing? Do I need to install something more?
    Thanks for your help. Best regards, Edgar Walther

    • Hi Edgar,

      Performance point services are available in SharePoint 2010 enterprise edition. Have you installed this version?


  • Edaurdo

    Great post!

    I followed it and worked like a charm.

    Now, i think I’ve got an issue after creating reports, because options “display report” and “edit in dashboard designer” don’t appear for members uploaded into performancepoint content list

    any ideas?


    • Just add the users whom you want to edit the report in to admin group. Hope this solves the issue!

  • Eduardo

    I am afraid this doesn’t work out the problem. My user is already admin of the site


  • Eduardo


    it has to do with the language. I switched to English and the functions showed up. Maybe I am missing spanish library for dashboard designer

    Thanks for you help

  • Pingback: Configuring PerformancePoint services in... | .NET and SharePoint | Syngu()

  • scot

    can you some one can explain me how to connect oracle data to performancepoint 2010. thanks scot

%d bloggers like this: