CUBEVALUE
Returns an aggregated value from a cube.
CubeCube & Data Models
What it does
Retrieves a specific aggregated value (measure) from the cube, filtered by members.
Syntax
CUBEVALUE(connection, [member_expression1], ...)
Arguments
connection(text) — Connection name.member_expression1(text) — Slicer/Filter member.
Examples
Get Sales Value
Get Sales for 2023.
FORMULA
=CUBEVALUE("Sales", "[Measures].[Total]", "[Time].[2023]")RESULT
50000
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | 50000 |