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

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.

Download Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
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 (https://blog.sqlauthority.com)

Business Intelligence, SQL Documentation, SQL Download, SQL White Papers, SQLAuthority Author Visit
Previous Post
SQL SERVER – What is Data Mining – A Simple Introductory Note
Next Post
SQL SERVER – FIX – ERROR : Cannot drop the database because it is being used for replication. (Microsoft SQL Server, Error: 3724)

Related Posts

2 Comments. Leave new

  • Rahul Vairagi
    January 17, 2011 3:26 pm


    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 !!


Leave a Reply

Exit mobile version