CUBEKPIMEMBER

Syntax:

CUBEKPIMEMBER ( connection , kpi-name , kpi-property [ , [ caption ] ] )

Description: Fetches from the OLAP cube on the SQL Server designated by connection, 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.

Arguments:

Name	Type	Description
connection	text	The name of the connection to the cube.
kpi-name	text	The name of the KPI in the cube.
kpi-property	number	The KPI component to be returned, truncated to integer; it shall be one of the following: Value Description 1 The actual value 2 A target value 3 The state of the KPI at a specific moment in time 4 A measure of the value over time 5 A relative importance assigned to the KPI 6 A temporal context for the KPI   If 1 is specified, only kpi-name is displayed in the cell.
caption	text	An alternative string whose value is displayed in the cell instead of kpi-name and kpi-property.

 

Return Type and Value: any – The selected key performance indicator.

However, if

• kpi-name is invalid, the return value is unspecified.

• kpi-property is outside the range 1–6, #N/A is returned.

• The connection name is not a valid workbook connection stored in the workbook, the return value is unspecified.

• The OLAP server is not running, not available, or returns an error message, the return value is unspecified.

[Example:

CUBEKPIMEMBER("Sales","MySalesKPI",1)
CUBEKPIMEMBER("Sales","MySalesKPI",2,"Sales KPI Goal")

end example]