Wauvel

Excel like a finance pro.

← The library

Cube function

CUBEMEMBERPROPERTY

Returns the value of a member property from an OLAP cube.

Rarely usedDifficulty 1650 · ExpertUsage rank #518 of 520
Practice · 2 questions →

When to use it

Returns a property of a cube member, such as an attribute defined in the model.

The shape of it

Syntax
=CUBEMEMBERPROPERTY(connection, member_expression, property)

Worked examples

  • An attribute

    =CUBEMEMBERPROPERTY("Sales","[Customer].[Customer].[ACME]","Country") → USA

    The Country attribute of a customer.

  • Caption

    =CUBEMEMBERPROPERTY("Sales","[Customer].[Customer].[ACME]","MEMBER_CAPTION") → ACME

    The display name.

  • From a member cell

    =CUBEMEMBERPROPERTY("Sales",A2,"[Customer].[Customer].[Industry]") → Manufacturing

    A2 holds a CUBEMEMBER.

Worth knowing

  • Property names come from the cube's dimension attributes.
  • Use it to add descriptive columns next to CUBEMEMBER headers.
  • Standard properties: MEMBER_CAPTION, MEMBER_UNIQUE_NAME, PARENT_UNIQUE_NAME.

Where it goes wrong

  • #N/A when the property is not defined for that member.
  • Requires an OLAP source; Power Pivot exposes only some properties.

Related

CUBEVALUECUBEKPIMEMBERCUBEMEMBERCUBERANKEDMEMBERCUBESETCUBESETCOUNT

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.