Excel Cube Functions

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:

FunctionDescription
CUBEKPIMEMBER FunctionKey Performance Indicator (KPI) property and displays the KPI name in the cell.
CUBEMEMBER FunctionValue of a specific member or tuple from the cube.
CUBEMEMBERPROPERTY FunctionValue of a member property from the cube.
CUBERANKEDMEMBER FunctionNth or ranked member in a set.
CUBESET FunctionA calculated set of members or tuples by sending a set expression to the cube on the server.
CUBESETCOUNT FunctionCount the number of items in a set within a cube.
CUBEVALUE FunctionAggregated value from the cube.