Results for:
Analysis Services

• Calculated Member and Measures in Excel 2013

  15 Oct 2012

  Today blog post is brought to you by Alex McMains a Software Development Engineer in Test from the Office Business Intelligence team. Besides many new, exciting features, Excel 2013 also offers enhancements to older features even those that may be a little more obscure to the everyday Excel user. Today...
• Using PowerPivot with Excel 2010

  23 Oct 2009

  In this blog article, we’ll step through using PowerPivot for Excel 2010 for building a rich application in Excel. Note: following screenshots describe the SQL Server 2008 R2 August Community Technology Preview (CTP) functionality for a feature codenamed Gemini. As recently announced , Gemini will be...
• Introducing PowerPivot

  22 Oct 2009

  Today we have a guest author from the SQL Server Analysis Services team, Ashvini Sharma, to tell us about the PowerPivot (née Gemini) feature that you may have heard about recently. PowerPivot is the recently announced name of technologies this blog previously referred to by its codename, Gemini. This...
• A Few More PivotTable Improvements in Excel 2010

  15 Oct 2009

  Thanks to Diego Oppenheimer for putting together this post. In today’s post I will be covering a couple of smaller PivotTable features that we incorporated in Excel 2010. Most of these features have been longstanding customer requests or pain points that we felt could be addressed in this release. This...
• Excel 2010 PivotTable What-If Analysis (Writeback)

  12 Oct 2009

  Thanks to Diego Oppenheimer for putting together this post. When thinking of Excel as an OLAP analytical tool the first thing that usually comes to mind is the ability to quickly and easily analyze data from an OLAP data source. With the introduction of PivotTable What-If Analysis in Excel 2010 you can...
• Quick and Easy Data Access with Excel Services

  5 Feb 2009

  Today’s author, John Campbell, a Program Manager on the Excel Services team, shows us the quick and easy way to get external data access working with your Excel Services spreadsheets. I have seen a lot of great blog posts that tell folks how to do great things with refreshed data in an Excel spreadsheet...
• Using Excel & Excel Services with SQL Server Analysis Services 2008

  28 Aug 2008

  Today's author, Pej Javaheri, a Product Manager on the SharePoint team, talks about configuring Excel Services to work with the just-released SQL Server 2008. With the recent announcement of SharePoint Server 2007 supporting SQL Server 2008 , like you, I was excited to setup my Excel / Excel Services...
• Setting up Excel Services to Refresh Workbooks When Opened.

  24 Mar 2008

  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 the right data. With Excel Services, this has become...
• Common Questions Around Excel 2007 OLAP PivotTables

  6 Feb 2008

  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 Analysis Services Service Pack 2 cubes: Filtering...
• Switching Data Sources in Excel 2007

  12 Dec 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 Connections in Excel 12” which can be found here ...
• New Whitepaper - Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables

  10 Apr 2007

  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...
• Data Mining In Excel

  21 Feb 2007

  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 allow users to take advantage of SQL Server 2005...
• Managing External Database Connections in Excel 12

  16 Feb 2006

  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 data (whether that is an Access database, and...
• CUBE Functions 4: Deconstructing the PivotTable

  15 Feb 2006

  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 thier PivotTable. Then, with a single command, they...
• CUBE Functions 3: Formula AutoComplete revisited

  9 Feb 2006

  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 navigate the OLAP namespace while authoring CUBE...
• SQL Server Analysis Services support – the list

  9 Feb 2006

  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 hopefully answers folks’ questions. Specifically...
• CUBE Functions 2: A Few Examples

  6 Feb 2006

  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 functions can be used to produce reports based...
• The Excel 12 Blog Rides Again, or “CUBE Functions Part 1”

  2 Feb 2006

  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 Pivot Tables to bring OLAP data from SQL Server Analysis...
• PivotTables 12: Filtering OLAP data, and some “persistence” improvements

  12 Jan 2006

  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 to Analysis Services, so I want to review...
• PivotTables 11: Key Performance Indicators, Actions, and Named Sets

  10 Jan 2006

  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 indicators (KPIs). A KPI is a set of calculations...