Want to learn Performance Point Server 2007

If you’re interested in learning about Performance Point Server 2007, here are some links to start with.

Technet white papers (go ahead and read or skim over them).

Video Tutorials on creating dashboards.

List of books that MS recommends as resources.

Performance Point Server, approval’s don’t work

When you create an approval workflow in Performance Point, it appears to work.  Unfortunately it doesn’t.  When a user submits an excel template, to an approval it actually save the data to the database.  You can the record in your fact table to see what happens.

This is too bad that doesn’t work.  This one of those easy pieces of functionality. that sells the whole product..

Performance Point, can’t move data from Staging to App DB

You go through all the effort of loading your Staging database and you click on the “Load this model from Staging Area”.  Then you check your application database and there is nothing there.  You check your staging database and there no errors (BizSystemFlag = 0).

So what’s the problem?  There are no errors in the database (or in the event log).

You have to update the BizSystemFlag = 200.  Now when you load the model from the staging area it will actually move the data.

Performance Point excel not updating problems

So I found out a few tips about the excel add-in for Performance Point Server 2007.

Item 1, do NOT change a form template if you have a cycle created using that form template.  You can not guarantee that users will get the correct version of the form template.

Item 2, cache not clearing.  If you are sure you are not getting the latest form template when you open an assignment you can open the performance point excel add-in and click the clear cache button.  That may not always work.  To get around that problem you can browse to the folder

C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\PerformancePoint\OfflineCache.

If you can’t find the folder under Administrator, check under the current user or all users.

CAVEAT:  Do not delete the OfflineCache folder.  Be sure you only delete the folder under the OfflineCache.  If you do delete the OfflineCache folder I can’t tell you how bad Performance Point will react.

PerformancePoint Excel Add-in prerequisites

So if you want to make sure your clients can use the Excel add-in.
Here are the prerequisites for the add-in (from the Deploying PerformancePoint white paper).

All client computers require the following software before PerformancePoint Add-in for Excel can be installed:

· Windows Vista, Windows XP with Service Pack 2, or Windows Server 2003 with Service Pack 1

· Microsoft Office Excel 2003 Service Pack 1 or Office Excel 2007

· Office Excel 2003 Primary Interop Assembly (.NET Programmability Support)

· The Microsoft .NET Framework version 2.0.50727.42 or later.

To enable Export to Excel functionality or Export to PowerPoint functionality in Microsoft Office PerformancePoint Server 2007, you must install the Microsoft .NET Framework version 2.0 on the computer where these commands are executed.

· Microsoft Core XML Services (MSXML) 6.0

Be sure that you have Microsoft Core XML Services (MSXML) 6.0 installed before installing OLE DB Provider for OLAP Services 9.0.

· Microsoft OLE DB Provider for OLAP Services 9.0 Service Pack 2

· Microsoft ADOMD.NET 9.0 Service Pack 2