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/)

Troubleshooting #N/A

  • Validate connection name matches the data model
  • Test one member with CUBEMEMBER before CUBEVALUE
  • General lookup errors → [#N/A guide](/errors/na/)

Functions in this category

  • 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.