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

    Description ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.