O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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() ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required