The Excel CUBEMEMBERPROPERTY function returns a property of a cube member — a customer’s city, a product’s launch date — from an OLAP cube. Note: it needs true OLAP member properties, which Power Pivot Data Models mostly don’t expose — this one shines against Analysis Services cubes.
Syntax
| Argument | Description | |
|---|---|---|
connection | Required | OLAP connection name as text. |
member_expression | Required | MDX string identifying the member. |
property | Required | Property name as text, e.g. "City", or an MDX property expression. |
What you need first: cube functions only work against a Power Pivot Data Model (or an external OLAP cube). Add your table to the model — check “Add this data to the Data Model” when inserting a PivotTable, or use the Power Pivot tab — then reference it with the connection name "ThisWorkbookDataModel" and MDX-style member strings like "[Measures].[Total Sales]" or "[Products].[Category].[Displays]".
How to use it
Report row enriching a CUBEMEMBER cell in B5:
Power Pivot reality check: workbook Data Models don’t define member properties the way Analysis Services cubes do. Against "ThisWorkbookDataModel" you’ll usually get #N/A — pull the attribute as its own column/measure instead, or use a real OLAP cube.
Try it: interactive demo
Pick a member and a property — see the formula a corporate OLAP cube would answer.
Errors & common pitfalls
#NAME? — bad connection name. The first argument must exactly match a workbook connection; for the built-in Data Model it is "ThisWorkbookDataModel", quotes included.
#N/A — invalid member expression. Table, column, or item names in the MDX string don’t match the model. Check spelling and bracket every level: [Table].[Column].[Item].
“#GETTING_DATA” flashes in cells. Normal — Excel retrieves cube results asynchronously. It resolves when the query finishes.
Performance: hundreds of separate CUBEVALUE calls query the model one by one. Pull shared members into CUBEMEMBER cells once and reference those cells in your CUBEVALUEs.
Practice workbook
Frequently asked questions
Why do I get #N/A against ThisWorkbookDataModel?
What properties exist on a member?
CUBEMEMBERPROPERTY vs CUBEMEMBER?
Does it work in Excel for the web?
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class