How to configure PerformancePoint services

Configure the PerformancePoint Services application pool account

The application pool for the PerformancePoint Services service application requires a Microsoft SharePoint Server 2010 managed account (generally an Active Directory account) to run. This account must have access to the content databases where PerformancePoint data will be stored.

If you run the service application using the same application pool account as the web application where the content databases are located, this required database access is configured automatically. However, we recommend that you use a different account for the PerformancePoint Services application pool, especially in a large or complex farm. This allows for greater control over data and resource access.

If you choose to use the same managed account for PerformancePoint Services as is being used for the web application, you can skip the procedures in this section. If you choose to create a new managed account, you must do the following:

1. Register a managed account in SharePoint Server 2010. (You will need an Active Directory user account for this step. Have your Active Directory administrator create it.)
2. Grant access for this account to the content databases that will contain PerformancePoint data. This process includes running a Windows PowerShell script from the SharePoint 2010 Management Shell.

The first step is to register a managed account. Use the following procedure to register the Active Directory account that you want to use for the PerformancePoint Services application pool.

To register a managed account

1. In the SharePoint Server Central Administration Web site, click Security.
2. In the General Security section, click Configure managed accounts.
3. Click Register Managed Account.
4. In the Service account credentials section, type the user name and password for the Active Directory account that you want to register.
5. Optionally, if the account password is set to expire after a certain length of time, configure the automatic password change settings to have SharePoint Server 2010 change the password.
6. Click OK.

Once you have registered the managed account, you must grant that account access to the content databases where PerformancePoint data will be stored. Use the following procedure to grant database access to the account. Follow this procedure for each web application that contains a content database where PerformancePoint Services data will reside.

To grant content database access to an account

1. On an application server in the farm, click Start, click All Programs, click Microsoft SharePoint 2010 Products, right-click SharePoint 2010 Management Shell, and then click Run as Administrator.
2. At the Windows PowerShell command prompt, type the following, pressing Enter after each line:

Copy Code

$w = Get-SPWebApplication -identity

$w.GrantAccessToProcessIdentity("")

Once you have finished granting content database access to the managed account, the next step is to start the PerformancePoint service.

Start the PerformancePoint service

To configure PerformancePoint Services, you must first start the PerformancePoint service on the application server where you want to run PerformancePoint Services. You can start the service on multiple application servers for better performance, if you want, but the service must be started on at least one server. Use the following procedure to start the PerformancePoint service.

To start the PerformancePoint Service

1. In Central Administration, in the System Settings section, click Manage services on server.
2. Note the server specified in the Server box. If you want to run the PerformancePoint service on a different server, click the current server, and then click Change Server and select the server that you want.
3. Click Start next to PerformancePoint Service.

Create a service application

Once the service is started, you can create a PerformancePoint Services service application. Use the following procedure to create the service application.

To create a PerformancePoint Services service application

1. In Central Administration, in the Application Management section, click Manage Service Applications.
2. Click New, and then click PerformancePoint Service Application.
3. Type a name for the service application and select the Add this service application's proxy to the farm's default proxy list check box.
4. Select the Create new application pool option and type a name for the application pool.
5. Under the Configurable option, select the managed account to run the application pool.
6. Click Create.
7. Click OK.

Configure service application associations

For PerformancePoint Services to function, the PerformancePoint Services service application proxy must be associated with the default web application. Use the following procedure to confirm that the association is configured between the web application and the PerformancePoint Services proxy.

To configure service application associations

1. In Central Administration, click Application Management.
2. In the Service Applications section, click Configure service application associations.
3. In the Application Proxy Group section, click default.
4. Ensure that the PerformancePoint Services box is selected.
5. Click OK.

Tutorials:

http://www.learningsharepoint.com/2010/10/29/create-kpi-in-dashboard-designer-sharepoint-2010/

http://office.microsoft.com/en-us/sharepoint-server-help/create-and-publish-key-performance-indicators-kpis-HA010080027.aspx