Now that SP1 has hit, I bet a lot of people are wondering about SP1 / SQL Server 2008 compatability. In fact, the PPS Help and How To page hints at same, saying (bold is mine):
PerformancePoint Server 2007 with Service Pack 1 (SP1) includes enhancements such as improved query performance, increased compatibility with Windows Server 2008, SQL Server 2008, additional data sources, and more filtering capabilities for reports and dashboards
So, is PPS SP1 officially supported with SQL Server 2008? No. The product team made it clear that we can’t support a product which hasn’t even been released yet – makes sense to me! Offical support won’t happen until PerformancePoint SP2 hits (no, I don’t know the timeline on that).
That doesn’t mean PPS SP1 won’t work against SQL 2008, however. The product team did test the products together, and they do get along quite well. (Sorry, I don’t have a list of specific functionality that either works or doesn’t)
I’m writing this before SP1 actually released, so I expect to update this post after I get my hands on the readme.
Now that SQL 2008 is out – and PPS SP2 is expected by early next year – do you have any suggested workarounds in the meantime? Or what would you suggest as an installation strategy so that we don’t have to do too much uninstall later on…
Reply greatly appreciated. Thanks
Well, I have colleagues who have gotten a complete system (PPS, ProClarity Desktop & PAS) up and running using Windows 2008 & SQL 2008 – but I’d never consider this in a production / qa / test environment since you’d be completely unsupported.
I began trying this out myself and ran into too many roadblocks – didn’t have the time to resolve them all, so I just went back to SQL 2005.
Right now I’d recommend you keep running with SQL 2005…unless you do SQL Reporting. There is *SO* much good stuff in SSRS 2008, I’d be tempted to install SSRS 2008 *only* so I could take advantage of Dundas charts and other nice visualizations.
If you go this route, you won’t be able to use the PPS “SQL Report” report view until SP2 hits – Instead, you’d need to expose the report in your dashboard by using a web report view instead, and using it to point to the URL where your SSRS 2008 report lives.