The Excel cube functions are used to perform cube related calculations such as tuple, value of member property, aggregate value, and number of items in a set.
Complete List of Excel Cube Functions (A to Z)
All Excel cube functions are mentioned below in alphabetical order:
Function | Description |
CUBEKPIMEMBER Function | Key Performance Indicator (KPI) property and displays the KPI name in the cell. |
CUBEMEMBER Function | Value of a specific member or tuple from the cube. |
CUBEMEMBERPROPERTY Function | Value of a member property from the cube. |
CUBERANKEDMEMBER Function | Nth or ranked member in a set. |
CUBESET Function | A calculated set of members or tuples by sending a set expression to the cube on the server. |
CUBESETCOUNT Function | Count the number of items in a set within a cube. |
CUBEVALUE Function | Aggregated value from the cube. |