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
| Argument | Required? | What it does |
|---|---|---|
| connection | Yes | The name of the connection to the OLAP cube, in quotes. |
| member_expression | Yes | The member whose property you want, e.g. "[Store].[Store Name].[Downtown]". |
| property | Yes | The 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
- Cube functions talk to a live Data Model or Analysis Services cube, so they can't run in our practice Sandbox.
- Related functions: CUBEVALUE, CUBEMEMBER, CUBESET, CUBERANKEDMEMBER, CUBESETCOUNT, CUBEMEMBERPROPERTY, CUBEKPIMEMBER, GETPIVOTDATA.

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.