Setting Up Secure Store SharePoint 2010

One of those settings is for the Secure Store. Without it, you cannot use PerformancePoint’s unattended service account to connect to data sources. As with the 2007 version of the product, which used the application pool account as the application identity, the unattended account cannot use the application pool identity to connect to data sources. Rather, it must use a domain account, whose password is stored in the secure store. If you have created a new PerformancePoint service application and there is no secure store set up in the default proxy group, you will need to configure the secure store. You can tell whether things have been set up correctly when you go to the PPS settings page. You will see a warning indicating that the secure store hasn’t been configured.

Secure Store Warning

In order to configure the secure store, you will need to create a secure store service first. Do that by clicking on New (in the ribbon) from the Manage Service Applications page. If the Edit functions in the ribbon appear inactive, make sure that the secure store service has been started. You can check this by going to the Manage services on server page in Central Administration. If it hasn’t been started, start it, and proceed with the steps below. Fill in the parameters, and click OK. Once the service is created, you can configure it.

To configure the secure store for PPS, follow these steps:

1. Go to the Central Admin home page
2. Under "Application Management" click "Manage Service Applications"
3. Click on the Secure Store Service Proxy
4. Click "Manage" in the ribbon
5. You should get a message to generate a new key. Click "Edit" on the ribbon, then click "Generate New Key". You will be required to enter a pass phrase.
6. When this completes, click "Edit" on the ribbon, then click "Refresh Key". Enter the same pass phrase you used in the previous step.

Configure the Unattended Service Account (necessary for using "Unattended Service Account" option on Data Sources)

1. Go to the Central Admin home page
2. Under "Application Management" click "Manage Service Applications"
3. Click on the PerformancePoint Service Application
4. Click the "Manage" button in the ribbon
5. Click the first link: PerformancePoint Service Settings
6. In the "Unattended Service Account" section, enter the user name and password to be used for querying data sources.

http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx