Sunday, October 9, 2011

SharePoint 2010 PerformancePoint Service


The steps for creating and configuring a PerformancePoint Services service application are as follows:
  • Configure the PerformancePoint Services application pool account
  • Start the PerformancePoint service
  • Create a PerformancePoint Services service application.
  • Configure service application associations

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.

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:
    $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.

Next Steps

Once you have finished configuring PerformancePoint Services, you can make it available to the users. We recommend that you review the following tasks:
Configure the unattended service account for PerformancePoint Services


The Unattended Service Account is an Active Directory account that is used for accessing PerformancePoint Services data sources. This account is used by PerformancePoint Services on behalf of authorized users to provide access to external data sources for the purposes of creating and using dashboards and other PerformancePoint Services content.
note Note:
The Unattended Service Account is a universal account that provides equal data access to all authorized users. If you need more fine-grained data access, you must configure per-user data access through Kerberos delegation. For more information, see Configure Kerberos authentication for SharePoint 2010 Products (white paper).

PerformancePoint Services uses Secure Store Service to store the unattended service account password. Before using the Unattended Service Account, make sure that Secure Store has been configured. For more information, see Plan the Secure Store Service (SharePoint Server 2010) and Configure the Secure Store Service (SharePoint Server 2010).

Configure the unattended service account for PerformancePoint Services


To configure the unattended service account for PerformancePoint Services

  1. On the SharePoint Central Administration Web site, in the Application Management section, click Manage Service Applications, and then click the PerformancePoint Services service application.
  2. On the Manage PerformancePoint Services page, click PerformancePoint Service Settings.
  3. In the Unattended Service Account section, enter the user name and password for the account that you want to use as the unattended service account.
  4. Click OK.
You will see the Secure Store Service name and the user name that represents the unattended service account.
note Note:
If an error occurs, the Secure Store Service key may not have been correctly generated or the key was not refreshed after you created a new key.

Once the unattended service account has been configured, you must grant that account access to your data sources:
  • For SQL Server data, the account must have a SQL logon with db_datareader permissions on each database that you want to access.
  • For SQL Server Analysis Services data, the account must have read access to the cube or an appropriate portion of the cube, depending on your needs.
  • For Excel Services data, the account must have access to the Microsoft Excel workbook in a SharePoint document library.
  • For data in a SharePoint list, the account must have read access to the list.

    No comments:

    Post a Comment