- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Advanced Excel - Cube Functions
The Excel Cube functions enable data from OLAP cubes to be brought into Excel to perform calculations. These functions are supported with a connection to Microsoft SQL Server 2005 Analysis Services or later data source.
As PowerPivot creates a data source, which is compatible with OLAP cubes, it can also be used with these functions.
Cube Functions
The following table lists all the Cube functions −
| S.No. | Function and Description |
|---|---|
| 1 | CUBEKPIMEMBER
Returns a key performance indicator name, property, and measure, and displays the name and property in the cell. |
| 2 | CUBEMEMBER
Returns a member or tuple in a cube hierarchy. |
| 3 | CUBEMEMBERPROPERTY
Returns the value of a member property in the cube. |
| 4 | CUBERANKEDMEMBER
Returns the nth, or ranked, member in a set. |
| 5 | CUBESET
Defines a calculated set of members or tuples by sending a set expression to the cube on the server. |
| 6 | CUBESETCOUNT
Returns the number of items in a set. |
| 7 | CUBEVALUE
Returns an aggregated value from a cube. |