PerformancePoint Monitoring Server assumes a top-level web site (or root site) is defined for a Microsoft Office SharePoint Server site collection. (This site would typically be accessed by a URL similar to http://Production.) If a top-level web site is not defined, Excel Services reports may not render in published dashboards.
This is likely the issue if your Excel Services reports are shown correctly in Dashboard Designer and the Preview site but display the Operation in Progress indicator (below) indefinitely, rather than the Excel Services report.
To resolve this issue, we recommend two options: 1) create a top-level web site for the MOSS site collection or 2) edit the web.config file for the SharePoint site collection, as described below.
Editing the Monitoring Server web.config file for the SharePoint site collection
1) Open the web.config file for the SharePoint site. By default, this is installed in the following location on the server running SharePoint Server: C:\Inetpub\wwwroot\wss\VirtualDirectories\80\web.config.
2) In the <appSettings> element, add the following key, replacing "<<subsite>>" with the path to a properly configured subsite for your SharePoint installation:
<add key="Bpm.WebPartResourcePath" value="/sites/<<subsite>>/_wpresources/Microsoft.PerformancePoint.Scorecards.WebParts/22.214.171.124__31bf3856ad364e35/"/>
3) Save and close the web.config file.
Elaine Andersen (email@example.com)