CUBEMEMBER function
Summary
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])
The CUBEMEMBER function syntax has the following arguments:
• Connection Required. A text string of the name of the connection to the cube.
• Member_expression Required. A text string of a multidimensional expression (MDX) that evaluates to a unique member in the cube. Alternatively, member_expression can be a tuple, specified as a cell range or an array constant.
• Caption Optional. A text string displayed in the cell instead of the caption, if one is defined, from the cube. When a tuple is returned, the caption used is the one for the last member in the tuple.
• Connection Required. A text string of the name of the connection to the cube.
• Member_expression Required. A text string of a multidimensional expression (MDX) that evaluates to a unique member in the cube. Alternatively, member_expression can be a tuple, specified as a cell range or an array constant.
• Caption Optional. A text string displayed in the cell instead of the caption, if one is defined, from the cube. When a tuple is returned, the caption used is the one for the last member in the tuple.
Example
=CUBEMEMBER("Sales","[Time].[Fiscal].[2004]")
=CUBEMEMBER($A$1,D$12)
=CUBEMEMBER("Sales",(B4, C6, D5),"SalesFor2004")
=CUBEMEMBER("xlextdat8 FoodMart 2000 Sales","([Product].[Food],[Time].[1997])")
=CUBEMEMBER($A$1,C$12:D$12)
=CUBEMEMBER($A$1,D$12)
=CUBEMEMBER("Sales",(B4, C6, D5),"SalesFor2004")
=CUBEMEMBER("xlextdat8 FoodMart 2000 Sales","([Product].[Food],[Time].[1997])")
=CUBEMEMBER($A$1,C$12:D$12)