Welcome to MSDN Blogs Sign in | Join | Help

New Whitepaper - Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables

Another Excel 2007 whitepaper is available.  According to the overview, "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."

You can find the paper here.

It was published yesterday, and I have already had a number of emails on the paper, so folks are clearly finding it useful reading.

I hope to have a short post on what changes in Excel 2007 when you have SQL Server 2005 SP2 installed soon.

 PS Updated to fix a typo.

Published Tuesday, April 10, 2007 10:48 AM by David Gainer

Comments

# Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables WhitePaper

Tuesday, April 10, 2007 2:37 PM by Bart Wessels' Blog

Via David Gainer: Another Excel 2007 whitepaper is available. According to the overview, "Microsoft...

# re: New Whitepaper - Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables

Thursday, April 12, 2007 4:14 AM by Andreas

A very useful extension for Analysis Services Cubes and the PivotTable is MicroCharts:

http://www.bonavistasystems.com/Products_SparkLinerforMicrosoftBI.html

KPIs are calculateded as sparklines and bullet graphs in the cube. In the PivotTable sparklines and bullet graphs effectively visualize KPIs and display trends or patterns.

# SQL Server 2007?

Monday, April 16, 2007 1:46 PM by Mark Stafford

Nice!  When will SQL Server 2007 SP2 be released?  :)  (That's a friendly joke, but I think there just might be a typo in the blog.)  Looks like a good paper, anyway... thanks!

# re: New Whitepaper - Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables

Friday, April 20, 2007 12:57 AM by gay keramidas

where do we send speed issues? i have a pretty basic app, the schedule file opens a blend file based on a code, populates the schedule based on the blend ingredients and closes the blend file.

in this example, there are 13 blends in the schedule to update.

in vista x64/office 2007, it takes almost 6 seconds to complete. not bad you say to open 13 files and populate the schedule.

well, in xp/office 2003, it takes less than 2 seconds. and i have other examples, too.

about the only thing that's going to be faster on the vista/0ffice 2007 partition is formatting it to get rid of it.

# Whitepaper Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables

Friday, April 20, 2007 8:44 AM by Walter Stiers - Academic Relations Team (BeLux)

New Whitepaper - Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables blog entry

# Whitepaper Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables

Friday, April 20, 2007 9:12 AM by RSS It All

New Whitepaper - Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables blog entry

# re: New Whitepaper - Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables

Friday, April 20, 2007 12:00 PM by David Gainer

keramidas - I don't fully understand your example.  That said, you can send me a file and the repro steps using the email link at the top right of this page.

# Microsoft Excel blog posts

Wednesday, August 22, 2007 2:55 PM by Walter Stiers - Academic Relations Team (BeLux)

Microsoft Excel blog has 2 recent post I would like to refer to: Working With Excel's XML-Based File

# Microsoft Excel blog posts

Wednesday, August 22, 2007 3:57 PM by Noticias externas

Microsoft Excel blog has 2 recent post I would like to refer to: Working With Excel's XML-Based File

New Comments to this post are disabled
 
Page view tracker