Some great new features and fixes here. Here's a quick list of some of the key changes. Sam Batterman has provided a list of functionality improvements for SSAS and SSRS. The question around support for Office System 2007 and challenges with MDX query performance in particular seem to have come up a lot lately. So hopefully this assists. 

 

Analysis Services

  • Microsoft Office 2007 requires the installation of SQL Server 2005 Analysis Services SP2 to support all of its business intelligence features. Features of Microsoft Office 2007 that require SP2 will be disabled when running against an instance of Analysis Services that does not have SP2 installed.
  • The performance of local cubes, grouping, and subselects have been substantially improved.
  • MDX query performance has been improved with respect to subselects, arbitrary shapes, running sum calculations, visual totals, ROLAP dimensions, cell writeback, many-to-many dimensions, 64-bit NUMA hardware, semi-additive measures and unary operators.
  • The redistribution of data mining viewer controls is now dependent upon ADOMD.NET.
    The new redist file will be available in a feature pack that will ship soon after Service Pack 2.

Reporting Services

  • You can integrate a report server instance with Windows SharePoint Services 3.0 or Microsoft Office 2007 SharePoint Server to store, secure, access, and manage report server items from a SharePoint site. Integration features are provided jointly through SP2 and a special Reporting Services Add-in that you download and install on an instance of the SharePoint technology you are using.
    The new Report Viewer Web Part is included in the Reporting Services Add-in that you install on a SharePoint technology instance. For more information about the Web Part and other integration features, see Reporting Services and SharePoint Technology Integration and Features Supported by Reporting Services in SharePoint Integration Mode.
  • In SQL Server 2005 Reporting Services (SSRS), a Select All check box was automatically added when you created an available values list for a multivalue report parameter. If you upgraded to SQL Server 2005 Service Pack 1 (SP1), the Select All check box was no longer available. In SQL Server 2005 Service Pack 2 (SP2), the Select All check box has been restored.
    For more information, see Breaking Changes in SQL Server 2005 Reporting Services.