CUBEMEMBER
Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube.
Syntax
CUBEMEMBER(connection, member_expression, [caption])
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
- caption: Optional. A text string displayed in the cell instead of the caption from the cube
Example
=CUBEMEMBER("Sales", "[Time].[2024].[Q1]")