CUBEMEMBERPROPERTY
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)
Parameters
- connection: Required. A text string of the name of the connection to the cube
- member_expression: Required. A text string of a multidimensional expression that evaluates to a unique member within the cube
- property: Required. A text string of the name of the property returned
Example
=CUBEMEMBERPROPERTY("Sales", "[Product].[Bikes]", "Description")