CUBEMEMBER Function Explained
The CUBEMEMBER Function in Microsoft Excel returns a member or tuple from a cube hierarchy. It takes three arguments: Cube_Name, Member_Name, and Child_Hierarchy. The Cube_Name argument is the name of the cube from which to retrieve the member or tuple. The Member_Name argument is the name of the member or tuple to be retrieved. The Child_Hierarchy argument is an optional argument that specifies the name of the child hierarchy from which to retrieve the member or tuple.
CUBEMEMBER Function Syntax
CUBEMEMBER("cube_name", "member_expression")
- cube_name: The name of the cube from which to retrieve a member.
- member_expression: A valid Multidimensional Expressions (MDX) syntax expression that returns a member or a set of members.