Microsoft® Excel® 2010 Formulas & Functions Inside Out

CUBEKPIMEMBER()

Syntax. CUBEKPIMEMBER(connection,kpi_name,kpi_property,caption)

Definition. This function returns a Key Performance Indicator (KPI) property and displays the KPI name in the cell.

Arguments

• connection (required) A string with the name of the workbook connection to the cube. After you enter the first quotation mark, the existing context-sensitive data connections are displayed (see Figure 14-4, shown later in this chapter in the description of CUBEMEMBER()).

• kpi_name (required) Specifies the name of the KPI in the cube.

• kpi_property (required) A KPI consists of several components that are specified by using an integer (see Table 14-2).

  Table 14-2. Integers for the Third Argument of the CUBEKPIMEMBER() Function

  Integer	MDX expression