Syntax:

=CUBEMEMBER(connection, member_expression, [Optional caption])

Parameter:

• The following arguments are passed to the CUBEMEMBER function syntax:
• Connectivity is required. A text string containing the name of the cube connection.
• Member expression – This field is required. A text string containing a multidimensional MDX) that evaluates to a unique cube member. Member expression can also be a tuple that specifies a cell range or an array constant.
• Optional caption. A text string from the cube is shown in the cell instead of the caption, if one is defined. When a tuple is returned, the caption for the final item of the tuple is utilised.