Enabling Impersonation in PerformancePoint Dashboard Viewer

One of there toughest challenges when setting up a PerformancePoint server environment is getting the impersonation aspect to work and work correctly. If anyone has attemped this they would realize that making the appropriate changes in SharePoint as well as in IIS does not guarantee you impersonation at all. In fact in most cases these two changes should be enough but there is rarely documented option called Bpm.ServerConnectionPerUser setting in the application's web.config file.

By default this is set to False which means no matter what you do, PerformancePoint will not allow impersonation at all. Setting this key to true is the only way to get the Identity of the authenticated user to be passed along to the various data sources in reports and dashboards.

The easier way to locate and change the web.config file for MOSS is to use IIS Manager and under the ASP.NET tab and then click the Edit Configuration button and locate the application settings for Bpm.ServerConnectionPerUser.

Good luck!