Returns the value of a KPI for a given cross section of the cube.

Syntax

XL3KpiLookup( Connection, KpiName, KpiPart, [Hierarchy1], [Member1],…, [Hierarchy100], [Member100] )

Parameters

ParameterDescription
ConnectionConnection number to use.
KpiNameThe name of the KPI to use.
KpiPart

The part of the KPI to display. Possible values are:

  • Value
  • Goal
  • Status
  • Trend
Hierarchy1,…, HierarchyNName of the hierarchy that the member applies to. For example, "Measures" or "[Customer].[Customer Geography]".
Member1,…, MemberNEither a single-member's unique name or an XL3Member formula.