CUBEMEMBERPROPERTY function
Summary
Returns the value of a member property in the cube. Use 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.
• 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.
Example
=CUBEMEMBERPROPERTY("Sales","[Time].[Fiscal].[2014]",$A$3)
=CUBEMEMBERPROPERTY("Sales","[Store].[MyFavoriteStore]","[Store].[Store Name].[Store Sqft]")
=CUBEMEMBERPROPERTY("Sales","[Store].[MyFavoriteStore]","[Store].[Store Name].[Store Sqft]")