O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required