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.
CubeCube & Data Models
What it does
Retrieves a specific property of a cube member.
Syntax
CUBEMEMBERPROPERTY(connection, member_expression, property)
Arguments
connection(text) — Connection name.member_expression(text) — Member MDX.property(text) — Property name.
Examples
Get Property
Get 'Color' property of 'Product A'.
FORMULA
=CUBEMEMBERPROPERTY("Sales", "[Item].[Product A]", "Color")RESULT
Red
SAMPLE DATA
| A | |
|---|---|
| 1 | Prop |
| 2 | Red |