TechBubbles Microsoft Technology BLOG

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.

SP2010

 

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

 

image

You will get the following window

image

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

image

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

image

3. Activate the PerformancePoint service from the below list

image

  • 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

image

2. Click on Manage Service Applications under Application Management

image

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

image

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

 

image

4. Click on the first link PerformancePoint Service Application Settings

image

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

image

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.

image

Share this post :

About the author

Kalyan Bandarupalli

My name is kalyan, I am a software architect and builds the applications using Microsoft .NET technologies. Here I am trying to share what I feel and what I think with whoever comes along wandering to Internet home of mine.I hope that this page and its contents will speak for me and that is the reason I am not going to say anything specially about my self here.

10 Comments

TechBubbles Microsoft Technology BLOG

Follow me

Archives

Tag Cloud