CUBEMEMBERPROPERTY Function

The CUBEMEMBERPROPERTY function retrieves the value of a specific member property. This function can fetch properties like numbers, dates, and detailed descriptions. You may utilize the CUBEMEMBERPROPERTY function to validate the names of the members that reside in the cube.

Compatibility

This advanced excel function is compatible with the following versions of MS-Excel −

Excel for Microsoft 365
Excel for Microsoft 365 for Mac
Excel for the web
Excel 2021
Excel 2021 for Mac
Excel 2019
Excel 2019 for Mac
Excel 2016
Excel for iPad
Excel Web App
Excel for iPhone
Excel for Android tablets
Excel for Android phones

Syntax

The syntax of CUBEMEMBERPROPERTY function is as follows −

CUBEMEMBERPROPERTY (connection, member_expression, property)

Arguments

You can use the following arguments with the CUBEMEMBERPROPERTY function −

Argument	Description	Required / Optional
Connection	A text string representing the connection name.	Required
member_expression	A text string represents the MDX for a specific member in a cube.	Required
Property	A text string denotes the property's name that will be returned or points to a cell where the specific property name is mentioned.	Required

Points to Remember

When you compute the CUBEMEMBERPROPERTY function, a "#GETTING_DATA" message will appear for a few seconds before retrieving the actual result in a cell.
If the connection name is invalid and the connection is not saved in the workbook, the CUBEMEMBERPROPERTY function will retrieve a #NAME error. If the OLAP server is unavailable, not in workable mode, or receives an error message, then the CUBEMEMBERPROPERTY function will retrieve the same error #NAME.
If the incorrect syntax of MDX has to be written, or the member does not reside in the cube, then the CUBEMEMBERPROPERTY function will retrieve a #N/A error.
If you specify a session-based object as an argument in the CUBEMEMBERPROPERTY function, it may return a #N/A error value in a pivot table while sharing a connection.

Example

=CUBEMEMBERPROPERTY ("Sales","[Time].[Fiscal].[2004]",$A$3)
=CUBEMEMBERPROPERTY("Sales","[Store].[MyFavoriteStore]","[Store].[Store Name].[Store Sqft]")

Save or share this article