Returns the value at the specified position of a ranking. To return the member's name instead, use the XL3RankLookup formula.

Syntax 

XL3ValueRankLookup( Connection, Position, TopOrBottom, MaxCount, Measure, RankHierarchy, RankMembers, Hierarchy1, Member1,…, [Hierarchy100], [Member100] )

Parameters

ParameterDescription
ConnectionConnection number to use
PositionPosition in the ranking to return
RankingType

The ranking type. Use the sum of the possibilities below:

  • 0 - Use defaults
  • 1 - Retrieve the lowest values instead of the highest
  • 2 - Exclude nulls from the results
  • 4 - Exclude zeros from the results

For example, to return a ranking excluding both nulls and zeros, use 6.

MaxCountThe maximum number of members to return in the ranking
MeasureThe measure on which to rank
RankHierarchyName of the hierarchy that the following member applies to.  For example,  "Measures" or "[Customer].[Customer Geography]".
RankMembersAn XL3MemberSet formula used to specify what to rank over
Hierarchy1,…, HierarchyNName of the hierarchy that the following member applies to. For example, "Measures" or "[Customer].[Customer Geography]".
Member1,…, MemberNEither a single member's unique name or an XL3Member formula to filter the ranking across.