Wauvel

Excel like a finance pro.

← The library

Cube function

CUBEMEMBER

Returns a member or tuple from an OLAP cube, validating that it exists.

Rarely usedDifficulty 1600 · ExpertUsage rank #515 of 520
Practice · 2 questions →

When to use it

Returns a member or tuple from a cube and validates that it exists. The building block of a formula-driven report on a data model.

The shape of it

Syntax
=CUBEMEMBER(connection, member_expression, [caption])

Worked examples

  • One member

    =CUBEMEMBER("ThisWorkbookDataModel","[Region].[Region].[West]") → West

    A single member from the workbook's data model.

  • With a caption

    =CUBEMEMBER("Sales","[Date].[Calendar].[Year].&[2025]","FY2025") → FY2025

    A member with a caption.

  • A tuple

    =CUBEMEMBER("Sales","([Region].[West],[Product].[Widget])") → West

    A tuple of two members; the cell shows the first.

Worth knowing

  • Put members in row and column headers, then CUBEVALUE in the grid referencing them.
  • Convert a pivot to formulas to see correct MDX for your model.
  • Captions make headers readable.

Where it goes wrong

  • #N/A for a member that does not exist or while the connection refreshes.
  • MDX is case sensitive and bracket sensitive.

Related

CUBEVALUECUBEKPIMEMBERCUBEMEMBERPROPERTYCUBERANKEDMEMBERCUBESETCUBESETCOUNT

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.