CUBEMEMBER()

Syntax. CUBEMEMBER(connection,member_expression,caption)

Definition. This function returns a member (cell) from a cube. Use CUBEMEMBER() to validate that the member exists and to pass the member to other functions through a cell reference.

Arguments

  • connection (required) The text string name of the workbook connection to the cube, in quotation marks. When you are entering the connection, after you type the first quotation mark, existing context-sensitive data connections are displayed (see Figure 14-4).

    Context sensitivity helps you enter formulas.

    Figure 14-4. Context sensitivity helps you enter formulas.

  • member_expression (required) Defines the position of a member in the cube based ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.