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.

Barry Tousley, an SDET on the PerformancePoint Server team has released a tool to help you do PPS planning data  migration.

You can find it here:

http://www.microsoft.com/downloads/details.aspx?FamilyId=FA1C6CAD-45BD-4E5C-A257-4BBA84FA4224&displaylang=en

Information on the tool itself is here

If you have taken the time to implement translations in your SSAS cube, it is comforting to know that the Analytic Grid can and will display your localized text.

From what I can gather, we aren’t quite smart enough to simply read regional settings on the client (as defined in Control Panel | Regional Settings) and run with them like we can when leveraging Excel 2007. Instead, you must set the language in question in Internet Explorer ala:

Tools | Internet Options | Languages (button)

You’ll need to add the language you want the grid localized in to the “language list”, and then move it to the top of the list. Clear your browser cache, and you should be ready to rock and roll.