SQL Server 2005 | SQL Server 2008

There is a nice example for an Excel add-in to enhance the abilities of the Excel pivot table with features like displaying the MDX query, adding calculated members or searching in dimensions. You can find the add-in as binary and source downloads at Codeplex: http://www.codeplex.com/OlapPivotTableExtend