CUBEMEMBERPROPERTY Function

Returns a property of a cube member, such as a store's manager or size.

Category

Cube

Available in

Excel 2007+ for Windows, Microsoft 365

Returns

The property's value

Overview

OLAP cubes can store extra facts about each member — a store's square footage, a product's colour, a customer's segment. CUBEMEMBERPROPERTY reads one of those properties.

Member properties are an Analysis Services (OLAP) feature; the workbook's own Data Model usually doesn't expose them.

Syntax

=CUBEMEMBERPROPERTY(connection, member_expression, property) Explain

Arguments

ArgumentRequired?What it does
connectionYesThe name of the connection to the OLAP cube, in quotes.
member_expressionYesThe member whose property you want, e.g. "[Store].[Store Name].[Downtown]".
propertyYesThe property name, e.g. "[Store].[Store Name].[Store Sqft]", or a cell holding it.

Examples

Example 1 — Square footage of a store

Read a property stored in a company's sales cube.

=CUBEMEMBERPROPERTY("SalesCube","[Store].[Store Name].[Downtown]","[Store].[Store Name].[Store Sqft]") Explain

Common mistakes

  • #N/A. The member or property name doesn't exist in the cube — check the exact names with your database team or in a PivotTable field list.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.