In my recent Business Intelligence Training Roadshow August September 2009 I quite often get request to provide more details about Analysis Service Cubes for Excel 2007 PivotTable. Here is the white paper on the same subject.
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.
All the space of my road show is filled at this moment. Please post your comment here if you want me to do another event in your city.
Reference : Pinal Dave (http://blog.sqlauthority.com)
hi,
I exported the data from SQL Server 2008 to Excel 2007. In excel, data is coming in “Text” format.
So I am unable to use aggregations(sum,average,count…..etc)
I asked number of people but all were unable to answer.
Please answer ASAP !!
You need to format the EXCEL cell to number