Click here to Skip to main content
15,867,308 members
Articles / Productivity Apps and Services / Sharepoint

SharePoint 2010 Performance Point Service Configuration and Utilization

Rate me:
Please Sign up or sign in to vote.
4.75/5 (4 votes)
16 May 2012CPOL8 min read 75.7K   5   6
The article explains configuring Performance Point Services (PPS) in SharePoint 2010 and consuming that service and creates a Scorecard and Chart.

1.0 Introduction

This article explains about Performance Point Services in SharePoint 2010. The article explains configuring Performance Point Services (PPS) in SharePoint 2010 and consuming that service and creates a Scorecard and Chart.

1.1 Scope

This document would be useful for developers/designers/architects and those who want to configure Performance Point Service and consume the same for their SharePoint 2010 sites as a business requirement.

1.2 Document Structure Overview

This article is divided in two main sections:

  1. Configuring Performance Point Services (PPS).
  2. Consuming the PPS Service and creating a Scorecard and Chart.

2.0 Configuring Performance Point Service (PPS)

For configuring PPS, one should complete the following four steps to use Performance Point features. The four important steps are:

  1. Start a Secure Store Service and Performance Point Service at farm level via Central Admin.
  2. Configure the Secure Store Service.
  3. Create and configure the PPS application.

2.1 Start Secure Store Service and Performance Point Service

To start configuration of the Secure Store Service and Performance Point Service, we have to start on the Farm. For that go to CA -> Application Management -> Service Application ->  Manage Service on server.

Image 1

Here on this page there are many services available. Out of these services, start Performance Point Service and Secure Store Service as shown below:

Image 2

This will allow configuring further steps.

2.2 Configure the Secure Store Service

The Secure Store Service is a new addition to SharePoint 2010. Basically it replaces the Single Sign On feature. It is a service that has a secure database which stores the credentials associated with application IDs which can be used to authorize access to external data sources.

To configure the Secure Store Service, enter Central Admin -> Application Management -> Manage service applications.

Image 3

Here you can create a new Secure Store Application or use an existing one. Let’s create a new Secure Store Service application.

For that, click on New and select Secure Store Service.

Image 4

Here it will pop up a window for creation of the new Secure Store.

Image 5

Provide Name, Database Server and Database Details, Application pool, and Manage Account detail.

I created a Secure Store named SecureStoreForPerformancePoint.

Once the Secure Store is created then there is no key generated which would encrypt the credentials. To create a new key, click on “Generate new key” on the top ribbon.

Image 6

A pass phrase needs to be created to encrypt the key. Accept the check to Re-encrypt the Database Using the New Key and click OK.

Image 7

On successful generation of the Secure Store Service, it shows the following screen.

Image 8

On creation of the Secure Store Service, it has to be associated with the application. To configure the association, go to CA -> Application Management.

Image 9

This shows the association of all default services with all web applications. Select the web site where you want to use the Performance point service and make the newly created Secure Store Service as default.

2.3 Creating and configuring the PPS application

Once the Secure Store service is configured then to create and configure the PerformancePoint service application, re-enter CA -> Application Management -> Manage service applications.

Image 10

By default every web application takes the default service application, but for our purpose, we need to create a new PerformancePoint service application. On the ribbon, click on the arrow below “New” and select “PerformancePoint Service Application”.

Image 11

Enter an appropriate application name. In the “Application Pool” area, we can create a new application pool or choose an existing one. After filling in all details, click on “Create“.

Image 12

Once the Performance Point Service is created, we need to set up an unattended service account so that we can use a single shared account to access an external data source. To do so, select the newly created Performance Point Service and click on “Manage” on the ribbon.

Image 13

There will be several options such as defining the trusted data source location or content locations, importing PPS content and others. For our purpose, click on "PerformancePoint Service Application Settings".

Image 14

By default the Secure Store Service name will be pre-populated. In order to configure the unattended account, provide an appropriate username and password and click OK.

Image 15

Once the Performance Point Service is created, this service also needs to be associated with a Web Application similar to what we did with the Secure Store Service.

Image 16

Once the service is configured then it can be consumed for creating Scorecard and Chart reports.

3.0 Consuming the PPS Service and creating Scorecard and Reports

Performance Point Service in SharePoint is provided a site template named Business Intelligence Center. The user can create a Web Application from Central Admin by making use of this template and start using Performance Point Service for creating Scorecard and Reports using Dashboard Designer.

However Performance Point Service can be consumed on any other site template as well by activating some features related to this service and also start using Performance Point Service for creating Scorecard and Reports using Dashboard Designer. (I follow this way). Follow the below steps:

  1. Activate required features
  2. Create List and Library
  3. Create Scorecard using Dashboard Designer
  4. Create Report using Dashboard Designer
  5. Show Scorecard and Report on site

3.1 Activate required features

I created a Web Application by using the Team Site Template. On this team site, the user has to Activate Feature at two places.

  1. On this site, go to Site Settings -> Site collection Administration -> Site Collection Features (Note: Only Site collection Admin can see this link and can perform this step).

Image 17

And Activate PerformancePoint Services Site Collection Features as shown below:

Image 18

  1. On this site, go to Site Settings -> Site Actions -> Manage Site Features

Image 19

And activate PerformancePoint Services Site Features as shown below:

Image 20

3.2 Create List and Library

After activating above mentioned features, you are allowed to consume PPS. Now, create a Library of type Performance Point to store data connections.

Image 21

And also create a List of type Performance Point Content List, as shown below:

Image 22

The List and Library will help to create Scorecard and Reports.

3.3 Create Scorecard using Dashboard Designer

For creating Scorecard go to PPS Configuration List and click on Add New Item Link. Doing so will open the Dashboard Designer window (the first time it will ask to download and run an ActiveX control for Dashboard Designer).

Image 23

Here in this Dashboard Designer

  1. Let’s first create a Data connection in the PPS Connection Library.

For that right click on it and click on New Data Source.

Image 24

Here various types of data sources are available. I am planning to consume data from an Analytical service.

Image 25

The next screen provides server name, database name, and cube name to consume. (I am using the AdventureWorks database.)

Image 26

Once the Data Connection is created, you rename and save the same.

  1. For creating a Scorecard, right click on PPS Configuration list in Dashboard Designer.

Image 27

This will show a dialog box to select a template for a Scorecard, as shown below:

Image 28

Make sure you select the Analysis Services template from Microsoft for our Scorecard. We will use a Wizard option for our Scorecard. This wizard will guide us to select a data source. The next step is to add a new KPI in our Scorecard or select the existing KPIs from our data source (in case you have any). The steps are shown below:

Image 29

Once you select the data source, click the Next button in the wizard. This will take you to a step where we can either import existing KPIs from our data source or we can create new KPIs. Choose ‘Create new KPIs from SQL Server Analysis Services Measures’ and click the Next button.

Image 30

Create KPI as shown below:

Image 31

Now click the Next button until you reach the Finish wizard button. Keep all the default settings. Rename your Scorecard as ‘Sales Scorecard’. You are now done with a basic scorecard with three KPIs. It should look like the one shown below:

Image 32

Now let’s modify the Scorecard by adding our products and timeline. You will see a ‘Details’ window on your right hand side screen, as shown below:

Image 33

Add Country on Actual and Target and selected the desired country as shown below:

Image 34

Then click on Edit and Update from top ribbon. Your Scorecard value will change as shown below:

Image 35

Similarly, add Calendar Year from right side on Scorecard.

Image 36

And Select desired members as shown below:

Image 37

Again Edit and Update from top ribbon. Your Scorecard value will change as shown below:

Image 38

That’s all. Your Scorecard is ready.

3.4 Create Report using Dashboard Designer

Reports are also created using Dashboard Designer. In Dashboard Designer, right click on PPS Configuration List.

Image 39

In the popup wizard, select Report Template. Here we select Analytical Chart.

Image 40

In the next step it will ask to select Data Source. Select the AdventureWorks data source which we created while creating the Scorecard.

Image 41

On clicking Finish, it will create a Report Window. To configure the report, we have to put dimension data.

Let’s put Product data in Series as shown below:

Image 42

On Adding, it shows as below:

Image 43

Click on the dropdown and select the desired products.

Image 44

Then Add Fiscal Year from right side detail window into Bottom series as shown below:

Image 45

And that’s all. Report is ready as shown below:

Image 46

3.5 Showing Scorecard and Report on site

The Scorecard and Report are created using Dashboard Designer and saved into the PPS Configuration List. Now to show them on a site, SharePoint provides OOB Webparts. Those are Performance Point Scorecard and Report.

Image 47

For displaying Scorecard, use Scorecard webpart and provide the path of your newly created Scorecard in the Location property. The same is applicable for reports as well.

Image 48

4.0 Findings and conclusion

  • PPS configuration uses Secure Store.
  • There are multiple data sources for creating PPS.
  • Dashboard Designer help to create Scorecard and Reports.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Architect
India India
Hi,

I am Vinaykumar Joshi. I am having around +11 years of IT experience.

I worked on Asp.Net using C#, Microsoft SQL Server, Windows Communication Foundation (WCF), Microsoft Office SharePoint Server 2007 (MOSS) & SharePoint Server 2010.

I am certified MCPD (Microsoft Certified Professional Developer) by passing exam 70-573 & 70-576. Also passed SharePoint 2010 Administration exam (70-668).

Comments and Discussions

 
QuestionPPS & BI option are not finding Pin
Member 1102764021-Aug-14 5:13
Member 1102764021-Aug-14 5:13 
QuestionHow can we change data source in Sharepoint Performance Point services Pin
rajanikanth_2320-Feb-14 19:07
rajanikanth_2320-Feb-14 19:07 
QuestionHaving Problem to create PPS Step 2.3 . Pin
Rehan Hussain29-Apr-13 20:26
Rehan Hussain29-Apr-13 20:26 
QuestionDashboard Designer does not start on step 3.3 Pin
Dmitry Otblesk24-Sep-12 9:42
Dmitry Otblesk24-Sep-12 9:42 
GeneralMy vote of 5 Pin
Ankur_Agrawal28-Aug-12 2:19
Ankur_Agrawal28-Aug-12 2:19 
GeneralMy vote of 4 Pin
SoulStone-BR16-May-12 10:23
professionalSoulStone-BR16-May-12 10:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.