Archive for the 'PerformancePoint 2007' Category

21
Sep

Dashboard Designer Charts and Office 2007

By nathan 0 Comments
Categories: PerformancePoint 2007

If you use Dashboard Designer for PerformancePoint 2007, be careful about the chart components. Even though it has the Office 2007 Ribbon UI and acts like a 2007 suite member, it uses the Chart components from Office 2003.

When I installed Office 2007, I was unable to get to Data Retrieval Services when creating a data source for a report. This would let me use a SharePoint list as a data source. I thought I needed to reinstall the Office 2003 Chart Components, but that didn’t help.

I installed Excel 2003 side by side with Office 2007 and everything works again. Apparently the Chart Components are read only if you do not have a 2003 product installed.

17
Sep

SOAP Exception in Dashboard Designer 2007

By nathan 0 Comments
Categories: Dashboard Designer 2007 and PerformancePoint 2007

Encountered an issue this morning after some patches were installed on the main PerformancePoint server over the weekend. Opening Dashboard Designer and refreshing encountered this error:

A general SOAP exception has occurred. Contact an administrator.

Well, that’s annoying. Some googling indicated that there might be an issue with the ASP.NET version that the PerfPoint web sites were running under. Opened IIS, saw that there was no ASP.NET version, period. I saw that one of the suggestions was to hit the Central Site and try reinstalling Dashboard Designer. That did nothing for me, but the other link was for the preview site. I checked to see if it was working, and it was. At least, it worked until I tried to browse to one of the test dashboards. Then I got a generic “some problem occurred”. So I browsed to it from the server and got this error:

System.InvalidOperationException: Unable to generate a temporary class (result=1).

Ugh. So I googled that and got to KB908158 telling me to grant Read and List Folder Contents on %windir%\Temp to the user account for the errant website. The identity for the app pool is jfcom\moss.sspapppool so it was a simple thing to grant those perms. Once that was completed I tried dashboard designer again and voila – it worked like a charm.