Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 
SQL Server Transparent Data Encryption Alternative - Free Webinar
 

How to configure PerformancePoint services in SharePoint 2010 - Part II


By:   |   Last Updated: 2011-04-12   |   Comments   |   Related Tips: > Sharepoint

Problem

PerformancePoint used to be an independent product with the 2007 version. In SharePoint 2010, PerformancePoint has been integrated in the form of PerformancePoint services. But in order to effectively use PerformancePoint services in SharePoint 2010, it should be properly configured with appropriate service applications and a proxy pointing to it.

Solution

In the last article, we saw how to create a secure store service and turn the PerformancePoint service on. In this article we will discuss the following points:

1) Creating and configuring the PerformancePoint service application.

2) Relating the web application with the created service application.

To create and configure the PerformancePoint service application, Select Start -> All Programs -> Microsoft SharePoint 2010 Products -> SharePoint 2010 Central Administration. Click "Manage Service Applications" under Application Management.

sharepoint

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 onthe  Arrow below "New" and select "PerformancePoint Service Application".

performance point service

Enter an appropriate application name. In the "Application Pool" area, we can create a new application pool or choose an existing one. For our purpose, we will create a new application and configure it with an appropriate security account. We need to make sure the service account has sufficient rights on all data sources as well as network sources. After filling in all details, click on "Create".

application pool

A PerformancePoint service application will be created, which in our case is "Article Performance Point Service". We need to set up an unattended service account so that we can use a single shared account to access external data source. To do so, Select "Article PerformancePoint Service" and click on "Manage" on the ribbon.

manage

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".

performance point service

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.

secure store service

After the service application is created, we need to complete the last step of attaching the web application to the newly created service application. To do so, go back to "Application Management" in Central Administration. Under "Service Applications" click on "configure service application associations".

web applications

By default, the "default" connection will be selected. You can change it to "custom" and select all the service applications required for the web application including the custom PerformancePoint service application i.e. "Article Performance Point Service". You can even set the custom service application as the default PerformancePoint service application. After selecting all the required service applications, click OK, and web application associations will be updated.

article

You can cross check whether the PerformancePoint service application is properly configured by accessing PPS sites, Dashboard designer and other PPS first class objects in Business Intelligence Center Site. Before that, ensure to activate the PPS feature from Site Settings->Site Collection Features.

Next Steps
  • Try to configure various PPS service application for different web application.
  • Try to access external data source using configured service application via PPS Site.


Last Updated: 2011-04-12


next webcast button


next tip button



About the author
MSSQLTips author Siddharth Mehta Siddharth Mehta is an Associate Manager with Accenture in the Avanade Division focusing on Business Intelligence.

View all my tips





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools