This is where existing spreadsheets can get the value-add of having PowerPivot data available to them in a way that is not only understandable for the traditional spreadsheet junkie (as opposed to the typical BI one) but that also that will add major value while integrating into existing models. Today I am going to give you a quick and dirty example of what I think is one of the key features of PowerPivot that will give it a much broader initial and on-going impact for experienced power spreadsheet developers. Using Excel Cube Functions with PowerPivot The New Visitor page has information on how to get started, including download links. I highly recommend reading both for examples and ideas.īut if you want to use cube functions with just plain tables of regular data, you can do that with Excel 2010! Just download PowerPivot (free addin from MS), copy/paste or link your tables of Excel data into PowerPivot sheet tabs, and you are off and running. Cube functions work the same with PowerPivot as they do with other OLAP sources like Analysis Services. This article below by Dick Moffat, as well as the one by Dany Hoter, is an excellent, detailed example of how to use cube functions with *any* OLAP data source, and NOT just PowerPivot. Arriving Here from a Search Engine or via Excel Help?