Essbase @MAXRANGE

Returns the maximum value of the specified member across the specified
range of members.

Syntax

@MAXRANGE (mbrName [ ,XrangeList])
Parameter Description
mbrName Any valid single member name or member combination, or a function that
returns a single member or member combination.
XrangeList A valid member name, a comma-delimited list of member names, cross-dimension
members, or a member set function or range function (including @XRANGE) that
returns a list of members from the same dimension. If XrangeList is
not specified, Essbase uses the level 0 members from
the dimension tagged as time.

Notes

Depending on the values in the list, @MAXRANGE may return a zero(0)
or #MISSING value. For full control over skipping or inclusion
of zero(0) and #MISSING values, it is recommended to use @MAXSRANGE instead
of @MAXRANGE.

Example

In the Sample Basic database:

Qtr1 = @MAXRANGE(Sales,@CHILDREN(Qtr1));

produces the following report:

           Colas   New York   Actual
          Jan     Feb     Mar     Qtr1
          ===     ===     ===     ====
Sales     678     645     675     678

See Also

  • @MAXSRANGE
  • @MAXS
  • @MINSRANGE