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:
If |
||||||||||||||
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.