Returns the value of a KPI for a given cross section of the cube.
Syntax
XL3KpiLookup( Connection, KpiName, KpiPart, [Hierarchy1], [Member1],…, [Hierarchy100], [Member100] )
Parameters
| Parameter | Description |
| Connection | Connection number to use. |
| KpiName | The name of the KPI to use. |
| KpiPart | The part of the KPI to display. Possible values are:
|
| Hierarchy1,…, HierarchyN | Name of the hierarchy that the member applies to. For example, "Measures" or "[Customer].[Customer Geography]". |
| Member1,…, MemberN | Either a single-member's unique name or an XL3Member formula. |
