[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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]