Excel like a finance pro.
Cube function
CUBEKPIMEMBER
Returns a key performance indicator property from an OLAP cube and shows its name in the cell.
When to use it
Returns a KPI property from a cube (value, goal, status, trend, weight, or current time member) so it can be used in CUBEVALUE. Displays the KPI name in the cell.
The shape of it
- Syntax
=CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])
Worked examples
KPI value member
=CUBEKPIMEMBER("Sales","Revenue KPI",1) → Revenue KPI
Property 1 is the KPI value; the cell shows the name.
KPI goal
=CUBEKPIMEMBER("Sales","Revenue KPI",2,"Revenue goal") → Revenue goal
Property 2 is the goal, with a caption.
Use it in CUBEVALUE
=CUBEVALUE("Sales",A1,"[Date].[2025]") → 4,850,000
A1 holds the KPI member; CUBEVALUE returns its number.
Worth knowing
- Properties: 1 value, 2 goal, 3 status, 4 trend, 5 weight, 6 current time member.
- KPIs must be defined in the cube or data model.
- Combine with CUBEVALUE for the actual figures.
Where it goes wrong
- #N/A when the KPI name does not exist or the connection is offline.
- Requires an OLAP source with KPIs; Power Pivot models rarely define them.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.