Welcome to MSDN Blogs Sign in | Join | Help

January 2006 - Posts

Tuesday, January 17, 2006 5:56 PM

A pause in the proceedings

For the next week and a half, I am going to be on the road visiting customers, so I probably will not be posting new content to the Excel 12 blog (I will try and reply to comments that show up). I will definitely pick up again after the travel is done,
Posted by David Gainer | 7 Comments
Friday, January 13, 2006 10:46 AM

Pivot Tables grand finale: Tricks with the Values field

This is going to be the last PivotTable post, at least for a while. Unlike the last several posts, the subject matter that follows applies to any PivotTable, not just those connected to SQL Server Analysis Services. In current versions of Excel, one of
Posted by David Gainer | 7 Comments
Filed under:
Thursday, January 12, 2006 8:24 PM

PivotTables 12: Filtering OLAP data, and some “persistence” improvements

In a previous post I covered the new sorting and filtering capabilities of Excel 12 PivotTables . Those features are available for any PivotTable, regardless of the data source. There are a few additional filtering options available for PivotTables connected
Posted by David Gainer | 1 Comments
Tuesday, January 10, 2006 10:29 PM

PivotTables 11: Key Performance Indicators, Actions, and Named Sets

Today, I will cover three additional features of Analysis Services that Excel 12 PivotTables supprt – Key Performance Indicators, Actions, and Named Sets. Key Performance Indicators SQL Server Analysis Services 2005 introduced the notion of key performance
Posted by David Gainer | 5 Comments
Thursday, January 05, 2006 5:40 PM

PivotTables X: Server formatting, translations, member properties

In this post I’ll walk you through three Analysis Services features that we now support in Excel PivotTables – server formatting, translations, and member properties. One thing to keep in mind as you read is that since all these are defined in Analysis
Posted by David Gainer | 4 Comments
Tuesday, January 03, 2006 2:48 PM

Quick detour #3: Updates we have made to XLLs

In the past few months, I have written a couple of articles ( big grid , multi-threaded calculation ) that prompted comments and questions along the lines of “what about XLLs?” Since the email questions have actually been picking up in frequency (I guess
Posted by David Gainer | 21 Comments
 
Page view tracker