This function returns value of member property from the cube.

Syntax

CUBEMEMBERPROPERTY(connection, member_expression, property)

Arguments

This function has the following arguments:

Argument	Description
connection	Refers to the string data specifying the name of the connection to the cube.
member_expression	Refers to the string data specifying the multidimensional expression (MDX) text of a unique member in the cube.
property	Refers to the string data specifying the name of the returned property.

Remarks

This function returns a temporary message "#GETTING_DATA..." in the cell while being evaluated and before all the data in the cell is retrieved.

Data Types

Accepts only string data.

Examples

CUBEMEMBERPROPERTY("Product_Sales","[Time].[Fiscal].[2017]",$B$3)

CUBEMEMBERPROPERTY("Product_Sales","[Store].[MyFavoriteStore]","[Store].[Store Name].[Store Sqft]")

Version Available

This function is available in product version 11.0 or later.