Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » PivotTables » Analysis Services   (RSS)
Tuesday, February 05, 2008 10:00 PM

Common Questions Around Excel 2007 OLAP PivotTables

Today's author: Allan Folting, a program manager who works on the Excel team. I have gotten lots of questions from customers around specific functionality in Microsoft Excel 2007 PivotTables that is missing when connected to Microsoft SQL Server 2005
Posted by Joseph Chirilov | 13 Comments
Tuesday, April 10, 2007 10:48 AM

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
Posted by David Gainer | 9 Comments
Thursday, February 16, 2006 9:19 PM

Managing External Database Connections in Excel 12

Now that we have covered OLAP formulas, I would like to explain a set of work we did in the area of “connection management” in Excel 12 workbooks. Specifically, I want to show you three new things that you can do in a workbook that is connected to external
Posted by David Gainer | 9 Comments
Wednesday, February 08, 2006 9:23 PM

SQL Server Analysis Services support – the list

I have had a number of emails in the last week asking for a list of the SQL Server Analysis Services features that we support, asking for a list of the SQL Server Analysis Services features that are new in their 2005 release, etc., so here is a list that
Posted by David Gainer | 9 Comments
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 | 6 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 | 5 Comments
Thursday, December 29, 2005 3:12 PM

PivotTables 9: Great support for SQL Server Analysis Services

Today, I’ll start a series of articles on the improvements we’ve made to PivotTables connected to OLAP (OnLine Analytical Processing) data sources, specifically Microsoft SQL Server Analysis Services models (in addition to its relational database product,
Posted by David Gainer | 6 Comments
 
Page view tracker