CUBEKPIMEMBER function
Summary
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.
Syntax
CUBEKPIMEMBER(connection, kpi_name, kpi_property, [caption])
The CUBEKPIMEMBER function syntax has the following arguments:
• Connection Required. A text string of the name of the connection to the cube.
• Kpi_name Required. A text string of the name of the KPI in the cube.
• Kpi_property Required. The KPI component returned and can be one of the following:
Integer | Enumerated constant | Description
1 | KPIValue | The actual value
2 | KPIGoal | A target value
3 | KPIStatus | The state of the KPI at a specific moment in time
4 | KPITrend | A measure of the value over time
5 | KPIWeight | A relative importance assigned to the KPI
6 | KPICurrentTimeMember | A temporal context for the KPI
• If you specify KPIValue for kpi_property, only kpi_name is displayed in the cell.
• Caption Optional. An alternative text string that is displayed in the cell instead of kpi_name and kpi_property.
• Connection Required. A text string of the name of the connection to the cube.
• Kpi_name Required. A text string of the name of the KPI in the cube.
• Kpi_property Required. The KPI component returned and can be one of the following:
Integer | Enumerated constant | Description
1 | KPIValue | The actual value
2 | KPIGoal | A target value
3 | KPIStatus | The state of the KPI at a specific moment in time
4 | KPITrend | A measure of the value over time
5 | KPIWeight | A relative importance assigned to the KPI
6 | KPICurrentTimeMember | A temporal context for the KPI
• If you specify KPIValue for kpi_property, only kpi_name is displayed in the cell.
• Caption Optional. An alternative text string that is displayed in the cell instead of kpi_name and kpi_property.
Example
=CUBEKPIMEMBER("Sales","MySalesKPI",1)
=CUBEKPIMEMBER("Sales","MySalesKPI", KPIGoal,"Sales KPI Goal")
=CUBEKPIMEMBER("Sales","MySalesKPI", KPIGoal,"Sales KPI Goal")