Archive for June, 2010

Using ODBC Connections in PerformancePoint 2007

June 8, 2010 2 comments

PerformancePoint is designed to work with multi-dimensional data sources (OLAP Cubes), however, it is possible to create ODBC Data Sources if necessary.

Such an example, may be to connect directly to a SQL Server data warehouse to create KPIs, especially if its to quickly knock up a demo. 

However, there is no wizard to create these connections and a connection string must be provided. There are a few things which must be done correctly before you will get a nice ‘Connection Successful!’ from the Test Connection button:

1. Ensure the account being used to connect to the data source has at least read access.  This account will either be:

PPSMonitoringWebService Application Pool account (if server connection is in service account mode)

Current logged on user (if server connection is in per user mode)

2. Ensure your connection string is in the ODBC Driver format AND assumes a trusted connection (you cannot supply hard coded user id/password when using SQL Server). This is critical as PerformancePoint is very strict about the format of this connection string.

Best thing to do is go to and pick one from the ODBC driver section e.g.

SQL Server 2008

Driver={SQL Server Native Client 10.0};Server=myServerAddress;Database=myDataBase;Trusted_Connection=yes;

3. Finally, make sure there are no extra spaces in the driver string as this will also mess things up!

The typical error you will receive when testing the connection will be:

The PerformancePoint Server could not connect to the specified data source. Verify that either the current user or application pool user has Read permissions to the data source, depending on your security configuration. Also verify that all required connection information is provided and correct.

If you see this – triple check the points above!

Categories: Uncategorized

PerformancePoint Session at SUGUK London

June 4, 2010 Leave a comment

A little belated due to my holiday, but here’s a quick post on my recent speaking engagement. 

On 25th May I was delighted to be invited to speak at the London SharePoint User Group (SUGUK), despite it being the evening before I was due to fly to Menorca on holiday (the Mrs was not impressed!).

The session was titled, ‘The Evolution of PerformancePoint’ and it aimed to bring the audience up to speed with how the product has progressed from its inception through to the integrated application within SharePoint 2010 we now have.

Despite a delayed start, which meant cutting out a fair chunk of demo, it seemed to be reasonably well received and I hope it was informative for those who attended (which was very low for London).

This now lays the foundations to perhaps return at a later stage and focus solely on SharePoint 2010 dashboards in practise and demonstrate an example case study perhaps.

Thanks to Matt as always for organising the event. 

The slides are now available for download:  The Evolution of PerformancePoint Services

Categories: Uncategorized Tags: ,