You can use your favorite social network to register or link an existing account:
Or use your email address to register without a social network:
Sign in with these social networks:
Or enter your username and password
Forgot your password?
Yes, please link my existing account with for quick, secure access.
No, I would like to create a new account with my profile information.
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.
Comments: (4) Collapse
A very useful extension for Analysis Services Cubes and the PivotTable is MicroCharts:
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.
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!
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.
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.
Comments: (loading) Collapse