Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Analysis Services   (RSS)
Monday, March 24, 2008 4:11 PM

Setting up Excel Services to Refresh Workbooks When Opened.

Today's author, Pej Javaheri, a Product Manager on the Excel Services team, talks about one of the more common configuration questions we hear about from customers. One of the challenges in sharing Excel workbooks is ensuring that the right people see
Posted by Joseph Chirilov | 3 Comments
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
Wednesday, December 12, 2007 3:17 PM

Switching Data Sources in Excel 2007

Today’s Author: Howie Dickerman, a program manager on the Excel team. Howie is going to discuss different ways to change data sources in Excel 2007. Prerequisite: This post assumes that you have read the blog post entitled “Managing External Database
Posted by David Gainer | 3 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
Wednesday, February 21, 2007 1:31 PM

Data Mining In Excel

One of the technologies available in SQL Server Analysis Services is data mining. You can read lots more about it here . We have just released a set of add-ins for Excel ("The Microsoft SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007") that
Posted by David Gainer | 0 Comments
Filed under:
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 15, 2006 10:55 PM

CUBE Functions 4: Deconstructing the PivotTable

Actually, before I talk about data connections, I want to cover one other way that users can author OLAP formulas ... users can create a PivotTable bound to an OLAP cube and then use the Field List to quickly add all the fields that they care about to
Posted by David Gainer | 7 Comments
Thursday, February 09, 2006 4:00 PM

CUBE Functions 3: Formula AutoComplete revisited

Previously when discussing CUBE functions, I showed a couple of examples of reports based on OLAP data that could be built using CUBE functions. Now I’d like to explain how we’ve done something very special with Formula AutoComplete to make it easy to
Posted by David Gainer | 13 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
Monday, February 06, 2006 4:10 PM

CUBE Functions 2: A Few Examples

Last time, I explained the seven new CUBE functions that are available in Excel 12 to fetch data from Analysis Services cubes. With the theory that a picture is worth a thousand words, I would like to walk through a few examples that illustrate how these
Posted by David Gainer | 4 Comments
Thursday, February 02, 2006 8:59 PM

The Excel 12 Blog Rides Again, or “CUBE Functions Part 1”

OK, I am freshly back from a fascinating couple weeks of visiting a number of customers (thanks to all you that spent time with us over the last few weeks), so it is time to get back to talking about Excel 12 features. We’ve already talked about using
Posted by David Gainer | 13 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