How to configure 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 Sharepoint 2010 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.
  2. 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.


Leave a Reply

Your email address will not be published. Required fields are marked *