CUBEVALUE()

Syntax. CUBEVALUE(connection,member_expression1,member_expression2,...)

Definition. This function returns the value of a member (cell) from a cube.

Arguments

  • connection (required) A string with the name of the workbook connection to the cube. After you enter the first quotation mark, the existing context-sensitive data connections are displayed (see Figure 14-4, shown earlier).

  • member_expression1 (required) and member_expression2 (optional) At least one and up through 255 expressions that define the position of a member in the cube based on an MDX. The expression can be entered directly or can be in a cell that is referenced. You can also use tuples in expressions. Alternatively, member_expression can be a set defined with the CUBESET() ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.