CUBEKPIMEMBER
Returns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization's performance.
CubeCube & Data Models
What it does
Returns a KPI property from a Cube.
Syntax
CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])
Arguments
connection(text) — Name of the connection to the Cube.kpi_name(text) — Name of the KPI.kpi_property(number) — 1=Value, 2=Goal, 3=Status, 4=Trend.
Examples
Get KPI Status
Retrieve status for 'Sales'.
FORMULA
=CUBEKPIMEMBER("SalesCube", "Total Sales", 3)RESULT
(KPI Status)
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | (Status Icon/Val) |