CUBEVALUE
Returns an aggregated value from a cube.
Syntax
CUBEVALUE(connection, [member_expression1], [member_expression2], ...)
Parameters
- connection: Required. A text string of the name of the connection to the cube
- member_expression1: Optional. A text string of a multidimensional expression that evaluates to a member or tuple within the cube
- member_expression2: Optional. Additional member expressions
Example
=CUBEVALUE("Sales", "[Measures].[Revenue]", "[Time].[2024]")