Before you begin

Ensure you know the syntax and specifics of CUBEMEMBER. For details, see CUBEVALUE function.

Syntax

CUBEVALUE(connection, [member_expression1], [member_expression2], ...)

Consider that for member_expression you cannot include in-line MDX functions. Instead, you should use a key-based MDX member reference string. member_expression can also be a tuple, specified as a cell range or an array constant. Here are a few examples:

• Static text string: "[Measure].[Order Quantity]"
• Concatenated text string: "[Product].[Product Categories].[Category].&["&B16&"]"
• Cell range: B1:B3
• Cell list: {"[Measures].[Order Quantity Long]","[Product].[Product Categories].[Category].&[4]"}
• Cell list: (B1,B3)

The following examples show how you can use the CUBEVALUE function.

CUBEVALUE(connection, CUBEMEMBER Measure)

MDX query name:

C1= CUBEMEMBER- Internet Sales Amount Local
C2= CUBEMEMBER- Order Quantity

Example:

C11=CUBEVALUE("Connection Name",C1)
C12=CUBEVALUE("Connection Name",C2)

CUBEVALUE(connection, CUBEMEMBER Measure, CUBEMEMBER-Dimension)

MDX query name:

C2= CUBEMEMBER- Order Quantity
C3= CUBEMEMBER- United States

Example:

C13=CUBEVALUE("Connection Name",C2,C3)

CUBEVALUE(connection, CUBEMEMBER Measure, CUBEMEMBER Dimension)

This example is for lower level of the hierarchy.

MDX query name:

C2= CUBEMEMBER- Order Quantity
C7= CUBEMEMBER- California

Example:

C14=CUBEVALUE("Connection Name",C2,C7)

CUBEVALUE(connection, CUBEMEMBER Measure, CUBEMEMBER Dimension, ...)

MDX query name:

C2= CUBEMEMBER- Order Quantity
C3= CUBEMEMBER- United States
C4= CUBEMEMBER- Accessories

Example:

C15=CUBEVALUE("Connection Name",C2,C3,C4)
C16=CUBEVALUE("Connection Name",C2:C4)

CUBEVALUE(connection, CUBEMEMBER from CUBEMEMBER formula)

MDX query name:

C8=CUBEMEMBER- Order Quantity-United States
C9=CUBEMEMBER- Order Quantity-US-Accessories

Example:

C17=CUBEVALUE("Connection Name",C8)
C18=CUBEVALUE("Connection Name",C9)

CUBEVALUE(connection, CUBEMEMBER from CUBEMEMBER formula, CUBEMEMBER Dimension)

MDX query name:

C8=CUBEMEMBER- Order Quantity-United States
C4= CUBEMEMBER- Accessories

MDX query name:

C19=CUBEVALUE("Connection Name",C8,C4)

Note that the second cubemember should be a dimension different from the cube members from the combined CUBEMEMBER. In case when the invalid CUBEMEMBER is selected, CUBEVALUE will return: #Value! Error value

IFERROR(NUMBERVALUE(CUBEVALUE("Connection Name", CUBEMEMBERMeasure, CUBEMEMBER Dimensions)

MDX query name:

C2= CUBEMEMBER- Order Quantity
C3= CUBEMEMBER- United States
C4= CUBEMEMBER- Accessories

Example:

C21=IFERROR(NUMBERVALUE(CUBEVALUE("Connection Name",C2,C3,C4)),0)

CUBEVALUE(connection, CUBEMEMBER Measure, CUBESET)

MDX query name:

C2= CUBEMEMBER- Order Quantity
Cubeset(My Countries)

Example:

C22=CUBEVALUE("Connection Name", C2,Cubeset(My Countries))

CUBEVALUE(connection, CUBEMEMBER Measure, Slicer)

MDX query name:

C1= CUBEMEMBER- Internet Sales
C4= CUBEMEMBER- Accessories
Slicer_Color

Example:

C20=CUBEVALUE("Connection Name",C1,C4,Slicer_Color)

IFERROR(NUMBERVALUE(CUBEVALUE("Connection Name", CUBEMEMBER Measure, CUBEMEMBER Dimensions, CUBESET)

MDX query name:

C2= CUBEMEMBER- Order Quantity
C3= CUBEMEMBER- United States
C4= CUBEMEMBER- Accessories
CUBESET- Dates

Example:

C23=IFERROR(NUMBERVALUE(CUBEVALUE("Connection Name",C2,C3,C4,CUBESET- Dates)),0)

More information

Using CUBE functions