CUBEKPIMEMBER
Returns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell
Syntax
CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])
Parameters
- connection: Required. A text string of the name of the connection to the cube
- kpi_name: Required. A text string of the KPI name in the cube
- kpi_property: Required. The KPI component returned (1=Value, 2=Goal, 3=Status, 4=Trend, 5=Weight, 6=Current Time Member)
- caption: Optional. A text string displayed in the cell instead of the KPI name and property
Example
=CUBEKPIMEMBER("Sales", "Revenue", 1)