This function returns value of member property from the cube.
CUBEMEMBERPROPERTY(connection, member_expression, property)
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. |
This function returns a temporary message "#GETTING_DATA..." in the cell while being evaluated and before all the data in the cell is retrieved.
Accepts only string data.
CUBEMEMBERPROPERTY("Product_Sales","[Time].[Fiscal].[2017]",$B$3)
CUBEMEMBERPROPERTY("Product_Sales","[Store].[MyFavoriteStore]","[Store].[Store Name].[Store Sqft]")
This function is available in product version 11.0 or later.
