Excel Function : CUBEVALUE

Download now!

Excel Function : CUBEVALUE




Returns an aggregated value from a cube.

Microsoft Excel Reference Page


Syntax and Description of the CUBEVALUE Excel Function

CUBEVALUE(connection, cube, x, y, z, [w]) x, y, z, and w are numeric coordinates that specify a cell in the cube. connection is a string expression that specifies the ODBC data source to connect to. cube is a string expression that specifies the cube containing the data you want to retrieve.

About CUBEVALUE Excel Function

CUBEVALUE returns the value of a cell in a cube. The cube must be a cube in the current database. The cell is identified by its coordinates, which are the members of the dimensions of the cube. For example, if the cube has the dimensions "time" and "location", then the cell is identified by its time and location members.