The CUBEVALUE function returns an aggregated value from the cube.

  • This function was introduced in Excel 2007 and so is not available in earlier versions.

Syntax

=CUBEVALUE(connection,[member_exp1],[member_exp2], … )

Arguments

Argument Description
connection A text string of the name of the connection to the cube
[member_exp] Optional. A text string of a multidimensional expression (MDX) that evaluates to a member or tuple within the cube

  Alternately, [member_exp] can be a set defined with the CUBESET function
  Use [member_exp] as a slicer to define the portion of the cube for which the aggregated value is returned

If no measure is specified in [member_exp], the default measure for that cube is used

Examples

  A B
1 Formula  
2 =CUBEVALUE(“Sales”,”[Measures].[Profit]”,”[Time].[2004]”,”[All Product].[Beverages]”)  
3 =CUBEVALUE($A$1,”[Measures].[Profit]”,D$12,$A23)  
4 =CUBEVALUE(“Sales”,$B$7,D$12,$A23)  

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if at least one element within the tuple is invalid
#N/A! Occurs if either:

  the [member_exp] syntax is incorrect
  the member specified by [member_exp] doesn’t exist in the cube
  the tuple is invalid because there is no intersection for the specified values
  the set contains at least one member with a different dimension than the other members
#NAME! Occurs if either:

  the connection name is not a valid workbook connection stored in the workbook
  the Online Analytical Processing (OLAP) server is not running, not available, or returns an error message
Null values are converted to zero-length strings A referenced cell has no data because it was never changed it or the contents were deleted and the cell now contains an empty value. A formula referencing that empty cell will return one of three values: a number value; a text value, which may be a zero-length string, or an error value, such as #NUM! or #VALUE.