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.

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)

About these ads

2 thoughts on “SQL SERVER – Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s