CUBEKPIMEMBER

Definition: CUBEKPIMEMBER is a function that returns a key performance indicator (KPI) value from an online analytical processing (OLAP) cube.

Syntax: =CUBEKPIMEMBER(connection, kpi_name, [kpi_property], [member_expression])

Situation: This formula is suitable when you need to retrieve a KPI value from an OLAP cube.

Example: If you have an OLAP cube connected to Excel and want to retrieve the value of a KPI named “Sales Growth”, the formula =CUBEKPIMEMBER(connection, “Sales Growth”) can be used.