Menu
EXCEL CUBEVALUE FUNCTION
Excel CUBEVALUE Function Introduction
Returns the cube’s aggregated value.
Description of Excel CUBEVALUE Function
Syntax :
=CUBEVALUE (connection, [member expression1], [member expression2],…)
Parameters :
- The following parameters are :
Connection :
- Required. A text string containing the name of the cube connection.
Member expression :
- Optional. A text string containing a multidimensional MDX) that evaluates to a cube member or tuple. Member expression can also be a set defined with the CUBESET function. To specify the section of the cube for which the aggregated result is returned, use member expression as a slicer. If no measure is supplied in member expression, the cube’s default measure is utilised.
Step By Step Guide of CUBEVALUE Function
Example :
- =CUBEVALUE( ) “Sales”,”[Measures].[Profit]”,”[Time].[2004]”,”[All Product].[Beverages]”)
- =CUBEVALUE($A$1,”[Measures].[Profit]”,”[Time].[2004]”,”[All Product].[Beverages]”) [Profit]”,D$12,$A23)
- =CUBEVALUE(“Sales”,$B$7,D$12,$A23)
Key Points
- When the CUBEVALUE function evaluates, it presents a “#GETTING DATA…” message in the cell till all the data has been retrieved.
- CUBEVALUE returns a #NAME? error result if the connection name is not a valid workbook connection stored in the workbook.
- CUBEVALUE delivers a #NAME? error value if the Online Analytical Processing (OLAP) server is not functioning, is unavailable, or gives an error message.
- If a cell reference is used for member expression and that cell reference contains a CUBE function, member expression utilises the MDX expression for the item in the referred cell rather than the value shown in that referenced cell.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
