Quick Navigation
CUBEMEMBERPROPERTY Function
Summary
The CUBEMEMBERPROPERTY function retrieves specific property values for cube members in OLAP analysis. It extracts metadata like captions, descriptions, or custom properties from multidimensional cube structures.
Syntax
CUBEMEMBERPROPERTY(connection, member_expression, property)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| connection | Text |
Yes | Text string specifying the cube connection name from the workbook |
| member_expression | Text |
Yes | MDX text string defining the target cube member |
| property | Text |
Yes | Property name to return or cell reference to property name |
Using the CUBEMEMBERPROPERTY Function
CUBEMEMBERPROPERTY enables extraction of member attributes from OLAP cubes for enhanced reporting and analysis. Use it to display member descriptions, formatting codes, or custom properties alongside cube values.
Common CUBEMEMBERPROPERTY Examples
Retrieve Fiscal Year Caption
=CUBEMEMBERPROPERTY("Sales","[Time].[Fiscal].[2014]",$A$3)Returns the caption or description for the 2014 fiscal year member from Sales cube.
Get Store Square Footage
=CUBEMEMBERPROPERTY("Sales","[Store].[MyFavoriteStore]","[Store].[Store Name].[Store Sqft]")Extracts square footage property for a specific store member.
Frequently Asked Questions
Common Errors and Solutions
#NAME? error
Cause: Invalid connection name or unavailable OLAP server
Solution: Verify connection exists in workbook and OLAP server is running
#N/A error
Cause: Invalid MDX member expression or nonexistent member
Solution: Check MDX syntax and ensure member exists in cube
#N/A with session objects
Cause: Referencing deleted PivotTable session objects
Solution: Avoid session-based calculated members in shared connections
Notes
- Displays #GETTING_DATA… during evaluation
- Requires valid OLAP cube connections
- MDX syntax must be precise
- Does not support Power Pivot Data Models
- Useful for extracting captions, keys, and custom properties
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2003 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+