Back
Excel

New Whitepaper – Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables

Another Excel 2007 whitepaper is available.  According to the overview, “Microsoft Office Excel 2007 takes advantage of most of the features in Microsoft SQL Server 2005 Analysis Services. To take full advantage of these features, it is important to keep in mind the end-user experience in Office Excel 2007 when you are designing cubes.  This document outlines how you can create a good end-user experience by optimizing the cube design for Office Excel 2007 PivotTable dynamic views.

You can find the paper here.

It was published yesterday, and I have already had a number of emails on the paper, so folks are clearly finding it useful reading.

I hope to have a short post on what changes in Excel 2007 when you have SQL Server 2005 SP2 installed soon.

 PS Updated to fix a typo.