CUBEKPIMEMBER Function in Excel: Syntax, Examples and Free Practice
CUBEKPIMEMBER is an Excel Cube function. Returns a key performance indicator property from a cube.
CUBEKPIMEMBER syntax
Arguments
connection: The name of the data connection to the cubekpi_name: The name of the key performance indicatorkpi_property: Which property of the KPI to returncaption: The display text to use instead of the raw name (optional)
When to use CUBEKPIMEMBER
Used only when a workbook is connected to an external OLAP data cube (e.g. via SQL Server Analysis Services) — not relevant for typical spreadsheet work.
Practice CUBEKPIMEMBER online, free
Open the live Excel-style spreadsheet and try CUBEKPIMEMBER yourself. No Excel install or sign-up needed to start.
Practice CUBEKPIMEMBER now →More Cube functions
Frequently asked questions
What does the CUBEKPIMEMBER function do in Excel?
Returns a key performance indicator property from a cube.
What is the syntax of CUBEKPIMEMBER in Excel?
The syntax is =CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption]). connection: The name of the data connection to the cube; kpi_name: The name of the key performance indicator; kpi_property: Which property of the KPI to return; caption: The display text to use instead of the raw name (optional).
Where can I practice CUBEKPIMEMBER online for free?
Open the free live spreadsheet on Cellgrids and try CUBEKPIMEMBER yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Cube functions · Excel case studies · Excel tutorials · Excel shortcuts