I am Norm Warren, an IT Pro writer for business intelligence tools in SharePoint 2010 Products. I want to share common troubleshooting tips for PerformancePoint Services. TechNet articles and trusted blog posts are valuable sources of information on these subjects, for example:
In addition to reading applicable articles, I use to the following tools to troubleshoot, particularly when I review data connection errors:
Here is a common error that occurs when you try to connect to a data source by using the Unattended Service Account for authentication. In this case, I opened PerformancePoint Dashboard Designer on my front-end web server, typed the correct database server name, and made a selection from the Database drop-down list. That’s when I got the following error.
I opened the ULSViewer, which is on my application server because the PerformancePoint service is running there. I could then view more details about the Unattended Services Account issue.
I then reviewed the PerformancePoint Services setup and configure article, which reads:
To initialize the Secure Store Service application, refer to the following sections of Configure the Secure Store Service (SharePoint Server 2010).
I checked that the Unattended Service Account was configured correctly. While in the Secure Store Service management page, I selected Refresh Key and entered the pass phrase to regenerate the key. I then tested my data connection and was able to view my Analysis Services OLAP cubes. Success!