Skip to main content
Version: I2024.2.x

CUBEVALUE

The function combines the CUBEMEMBER functions it references, and returns an aggregated value.

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