PerformancePoint Services application settings (SharePoint Server 2010)


Applies to: SharePoint Server 2010 Enterprise

Topic Last Modified: 2011-11-07

PerformancePoint Services in Microsoft SharePoint Server 2010 has settings such as cache durations, filter behavior, and query time-out that affect performance, security, and connections to external data. These settings affect anyone who uses the same service application. The settings can be managed by using the SharePoint Central Administration Web site. You can make additional changes to settings by using Windows PowerShell 2.0 to provision PerformancePoint Services, manage and configure a service application, configure and manage trusted locations, configure and manage proxies for the service application, and configure the global settings of the service. For more information, see PerformancePoint Services cmdlets (SharePoint Server 2010).


Setting Description

Secure Store and Unattended Service Account

A single shared user account is used to access all data sources. This is a low-privileged domain account stored in the Secure Store Service. An application ID is automatically mapped in the Secure Store Service that specifies the default secure store target application, PerformancePoint Services, and it looks up credential mapping when it connects to external data sources.

When you establish an unattended service account, first determine whether this account should have access to the data sources that will be retrieved in Dashboard Designer.


Users who have appropriate permissions can annotate scorecard cells in Dashboard Designer and on a deployed SharePoint site.

If a Dashboard Designer author attempts to add cell comments that are disabled, the author will receive a message that states, "An unexpected system error has occurred. Additional details have been logged for your administrator." If you want the author to be able to insert comments in a cell, select the check box, Enable comments.

You can also remove comments by clicking Delete Comments by Date. This command opens a dialog box. Select the date by which you want comments removed from the PerformancePoint Services database, and then click Delete.


Temporarily storing (or "caching") frequently-accessed items decreases load times for future requests. Specify the duration for items to remain in the cache.

Data Sources

Set the duration of no response before a data source query is canceled.


Specify how long to remember user-selected filter values and how often to clear expired values. Set the maximum number of members to retrieve and insert into a filter of type "tree".

Select Measure Control

Set the maximum number of measures to retrieve and insert into a dashboard Select Measure control.

Show Details

Set the limit for the number of rows returned when a user clicks "Show Details".

Decomposition Tree

Set the maximum number of individual items (per level) returned to the decomposition tree visualization. The minimum value is 0. The maximum is 1,000,000.