January 2006 - Posts
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,
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
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
Read More...
