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.