The Excel Cube functions perform calculations and extract data from a cube, which is stored on an external SQL server. These functions are only supported with a connection to Microsoft SQL Server 2005 Analysis Services or later data source.
|CUBEKPIMEMBER||Returns a key performance indicator (KPI) property and displays the KPI name in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, that is used to monitor an organization's performance (New in Excel 2007)|
|CUBEMEMBER||Returns a member or tuple from the cube. Use to validate that the member or tuple exists in the cube (New in Excel 2007)|
|CUBEMEMBERPROPERTY||Returns the value of a member property from the cube. Use to validate that a member name exists within the cube and to return the specified property for this member (New in Excel 2007)|
|CUBERANKEDMEMBER||Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or the top 10 students (New in Excel 2007)|
|CUBESET||Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel (New in Excel 2007)|
|CUBESETCOUNT||Returns the number of items in a set (New in Excel 2007)|
|CUBEVALUE||Returns an aggregated value from the cube (New in Excel 2007)|