This function can be used to monitor the performance as it returns a KPI property and displays the KPI name in the cell, where KPI refers to the Key Performance Indicator.
CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])
This function has the following arguments:
| Argument | Description |
|---|---|
| connection | Refers to the string data specifying the name of the connection to the cube. |
| kpi_name | Refers to the string data specifying the name of the KPI in the cube. |
| kpi_property | Refers to the Enumerated Constants used to return the KPI component. |
| caption | [Optional] Refers to the string data specifying the alternative text to display in cell instead of kpi_name and kpi_property. |
This function returns a temporary message "#GETTING_DATA..." in the cell while being evaluated and before all the data in the cell is retrieved.
Accepts only string data.
CUBEKPIMEMBER("Product_Sales","ProductSalesKPI",1)
CUBEKPIMEMBER("Product_Sales","ProductSalesKPI", KPIGoal,"Product Sales KPI Goal")
This function is available in product version 11.0 or later.