One of my coworkers wanted to work on the new PerformancePoint platform with SharePoint 2010 RTM. He asked me to get the site up and running with PerformancePoint services. Not a big request, I did it before using beta software in the past. Should be easy right?
My steps were simple:
- Run the Farm Configuration Wizard for PerformancePoint services.
- Create a new site collection to host the services using the Business Intelligence Center template.
- Go to the site collection features and enable the PerformancePoint feature or verify that it is active.
Once I did this, my coworker emailed me with the following error:“This data source cannot be used because PerformancePoint Services is not configured correctly. Additional details have been logged for your administrator". Additional details is just another way of saying ‘the error is being shoved into the event logs’.
Fixing this issue should be easy, just go to the Manage Service Application link in Operations on Central Administration, find the PerformancePoint Services item, highlight it and then click manage. On the next screen, I should be able to then supply a valid entry for the Unattended Service Account. However when I click save, I get the following message:”The Unattended Service Account cannot be set for the service application. The Secure Store Service key might not have been generated or properly refreshed after the service was provisioned”.
Going back to the site, I see the following message: “Before creating a new Secure Store Target Application, you must first generate a new key for this Secure Store Service Application from the ribbon”.
I have to hand it to Microsoft, they are making this real easy for me to fix errors. Before setting the Unattended Service Account I have to create a secure store service key by selecting ‘Generate New Key’. Once I created the new key, I was able to set the Unattended Service Account.
So to recap, prior to anyone using PerformancePoint in your SharePoint 2010 farm don’t forget to do the following:
- Generate a new key inside the Secure Store Service.
- Navigate to the Management screen for PerfomancePoint and set the Unattended Service Account.
For more detailed information on PerformancePoint services, visit the following link: ‘Deploying PerformancePoint 2010 Soup to Nuts’ http://blogs.msdn.com/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx.