The CUBEMEMBERPROPERTY function, one of the Cube functions in Excel, returns the value of a member property from a cube. Use it to validate that a member name exists within the cube, and to return the specified property for this member.
Syntax
CUBEMEMBERPROPERTY(connection, member_expression, property)
The CUBEMEMBERPROPERTY function syntax has the following arguments:
- Connection Required. A text string of the name of the connection to the cube.
- Member_expression Required. A text string of a multidimensional expression (MDX) of a member within the cube.
- Property Required. A text string of the name of the property returned or a reference to a cell that contains the name of the property.
Remarks
- When the CUBEMEMBERPROPERTY function evaluates, it temporarily displays a "#GETTING_DATA…" message in the cell before all of the data is retrieved.
- If the connection name is not a valid workbook connection stored in the workbook, CUBEMEMBERPROPERTY returns a #NAME? error value. If the Online Analytical Processing (OLAP) server is not running, not available, or returns an error message, CUBEMEMBERPROPERTY returns a #NAME? error value.
- If the member_expression syntax is incorrect or if the member specified by member_expression doesn't exist in the cube, CUBEMEMBERPROPERTY returns a #N/A error value.
- CUBEMEMBERPROPERTY may return a #N/A error value if you reference a session-based object, such as a calculated member or named set, in a PivotTable when sharing a connection, and that PivotTable is deleted or you convert the PivotTable to formulas. (On the Options tab, in the Tools group, click OLAP Tools, and then click Convert to Formulas.)
- CUBEMEMBERPROPERTY will not work against Excel Data Models that are edited in Power Pivot, since they are not multi-dimensional cubes.
Examples
=CUBEMEMBERPROPERTY("Sales","[Time].[Fiscal].[2014]",$A$3)
=CUBEMEMBERPROPERTY("Sales","[Store].[MyFavoriteStore]","[Store].[Store Name].[Store Sqft]")
Need more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.