Microsoft® Excel® 2010 Formulas & Functions Inside Out

Chapter 14. Cube Functions

• CUBEKPIMEMBER()

• CUBEMEMBER()

• CUBEMEMBERPROPERTY()

• CUBERANKEDMEMBER()

• CUBESET()

• CUBESETCOUNT()

• CUBEVALUE()

Cube functions were introduced in Microsoft Excel 2007. They are used with connections to external SQL data sources and provide analysis tools. Data cubes are multidimensional sets of data that can be stored in a spreadsheet, providing a means to summarize information from the raw data source. A cube is different from queries in Microsoft Access or Microsoft SQL Server because the data in a cube is already grouped in hierarchies, and calculated measures are saved in the cube. This offers two advantages to the user: Summary information is readily available, and most of the heavy-duty calculations are performed on the server. ...