Cube Excel Functions

Retrieve data from OLAP cubes and Power Pivot data models

Core cube formulas

Single measure value → [CUBEVALUE](/functions/cubevalue/)
One member → [CUBEMEMBER](/functions/cubemember/)
Set of members → [CUBESET](/functions/cubeset/)
Pivot-style exploration → [Pivot tables guide](/guides/excel-pivot-tables-guide/)

CUBEVALUE: Returns an aggregated value from a cube.
CUBEMEMBER: Returns a member or tuple in a cube hierarchy.
CUBESET: Defines a calculated set of members by sending a set expression to the cube.
CUBESETCOUNT: Returns the number of items in a set.
CUBERANKEDMEMBER: Returns the nth member in a set.
CUBEKPIMEMBER: Returns a key performance indicator (KPI) property.
CUBEMEMBERPROPERTY: Returns the value of a member property in the cube.

CUBESET defines a set of members for reporting from Analysis Services or Power Pivot models.
CUBEVALUE returns aggregated values from cube connections — confirm connection string stability.
CUBESETCOUNT counts items in a set — useful for validating slicer selections in formal reports.
Cube functions require live model connection; broken connections show #GETTING_DATA or #NAME?.

Prefer pivot tables connected to the same model for ad-hoc exploration before CUBEVALUE reports.
Document measure names exactly as defined in the model — typos fail silently with empty cells.
Separate formal financial reports from sandbox sheets that refresh cube formulas.

Retrieve data from OLAP cubes and Power Pivot data models — use this category page as a map before diving into individual function syntax pages.
Functions indexed here: CUBEVALUE, CUBEMEMBER, CUBESET, CUBESETCOUNT, CUBERANKEDMEMBER, CUBEKPIMEMBER, CUBEMEMBERPROPERTY.
Pick one function per week for your team, copy the examples into a practice workbook, and spot-check against manual math.
When functions in this category feed lookups or aggregates, read the related comparison and problem guides linked from function pages.
Small categories still matter in specialized models — document which niche functions your template depends on for auditors.
Confirm Excel version requirements: dynamic array and cube functions may not open in Excel 2019 even if other category members do.

#NAME? often means a niche function name typo or a locale mismatch — compare spelling to this English directory.
#VALUE! in specialized functions usually means wrong argument type — review each parameter description on the function page.
When results differ from documentation, verify regional settings, unit assumptions, and whether the workbook opened in compatibility mode.
Cross-link to fix-excel-formula-errors when multiple function types in this category fail after a bulk find-replace.

CUBEVALUE (/functions/cubevalue/): Returns an aggregated value from a cube. Syntax: =CUBEVALUE(connection, [member_expression1], ...).
CUBEMEMBER (/functions/cubemember/): Returns a member or tuple in a cube hierarchy. Syntax: =CUBEMEMBER(connection, member_expression, [caption]).
CUBESET (/functions/cubeset/): Defines a calculated set of members by sending a set expression to the cube. Syntax: =CUBESET(connection, set_expression, [caption], [sort_order], [sort_by]).
CUBESETCOUNT (/functions/cubesetcount/): Returns the number of items in a set. Syntax: =CUBESETCOUNT(set).
CUBERANKEDMEMBER (/functions/cuberankedmember/): Returns the nth member in a set. Syntax: =CUBERANKEDMEMBER(connection, set_expression, rank, [caption]).
CUBEKPIMEMBER (/functions/cubekpimember/): Returns a key performance indicator (KPI) property. Syntax: =CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption]).
CUBEMEMBERPROPERTY (/functions/cubememberproperty/): Returns the value of a member property in the cube. Syntax: =CUBEMEMBERPROPERTY(connection, member_expression, property).