Configure the unattended service account for PerformancePoint Services

In PerformancePoint Services, you create the unattended account directly in the PerformancePoint Services application settings.

 In this case, the password is stored in Secure Store Service and the actual username is stored in the PerformancePoint Services database.

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. To configure the unattended service account.

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 Application Settings.

3.      In the Secure Store and Unattended Service Account section, enter the user name and password for the account that you want to use as the unattended service account.

4. OK
You will see the Secure Store Service name and the user name that represents the unattended service account.

 

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 Excel workbook in a SharePoint document library.

• For data in a SharePoint list, the account must have read access to the list.

 Or With Screen shot Explanation!!

1. Browse to the Central Administration Site.

2. From the Application Management category, choose Manage service applications.