Cube
CUBEMEMBERPROPERTY Function in Excel
Returns the value of a member property in the cube.
Syntax
- =CUBEMEMBERPROPERTY(connection, member_expression, property)
Arguments
- connection (required): Connection string to cube
- member_expression (required): MDX expression for member
- property (required): Property name
Examples
- =CUBEMEMBERPROPERTY("Sales", A1, "Description") - Get member description - Result: Property value
CUBEMEMBERPROPERTY and data models
- Validate members with CUBEMEMBER before CUBEVALUE.
- Confirm the connection name matches your Power Pivot or OLAP model.
- Explore summaries with [Pivot tables guide](/guides/excel-pivot-tables-guide/).
Common errors
- #N/A if property not found
Use cases
- Metadata retrieval
- Reporting
- Documentation
Frequently asked questions
- What is the CUBEMEMBERPROPERTY function in Excel? CUBEMEMBERPROPERTY returns the value of a member property in the cube. The syntax is =CUBEMEMBERPROPERTY(connection, member_expression, property). Typical use cases include metadata retrieval, reporting, documentation.
- How do I use the CUBEMEMBERPROPERTY function? To use CUBEMEMBERPROPERTY, type =CUBEMEMBERPROPERTY( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
- Why is CUBEMEMBERPROPERTY not working in my Excel? Common issues with CUBEMEMBERPROPERTY include #N/A if property not found. Start by checking the syntax =CUBEMEMBERPROPERTY(connection, member_expression, property), then verify each referenced cell or range.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.