CUBEMEMBER
Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube.
CubeCube & Data Models
What it does
Validates and returns a member from the cube.
Syntax
CUBEMEMBER(connection, member_expression, [caption])
Arguments
connection(text) — Connection name.member_expression(text) — MDX expression.
Examples
Get Cube Member
Fetch '2023' year member.
FORMULA
=CUBEMEMBER("Sales", "[Time].[Year].[2023]")RESULT
2023
SAMPLE DATA
| A | |
|---|---|
| 1 | Member |
| 2 | 2023 |