Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Formulas and fu... » Analysis Services   (RSS)
Sorry, but there are no more tags available to filter with.
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
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
 
Page view tracker