Allan Folting, program manager who works on the Excel team has collected some. Questions customers around specific functionality in Microsoft Excel 2007 PivotTables that is missing when connected to Microsoft SQL Server 2005 Analysis Services Service Pack 2 cubes:
- Filtering individual calculated members
- Showing non-visual totals when filtering
He have also gotten lots of requests for the ability to add calculations to OLAP PivotTables using the object model, specifically:
- Adding calculated members/measures
- Adding named sets
Read the entire article with answers here:
http://blogs.msdn.com/excel/archive/2008/02/05/common-questions-around-excel-2007-OLAP-PivotTables.aspx