Max

The MDX Max function for Essbase returns the maximum of values found in the tuples of a set.

Syntax

Max ( set [,numeric_value_expression ] )

Parameters

set

The set to search for values.

numeric_value_expression

Optional numeric value expression (see MDX Grammar Rules).

Notes

The return value of Max is #MISSING if either of the following is true:

• The input set is empty.

• All tuple evaluations result in #MISSING values.

Example

WITH
MEMBER [Measures].[Max Qtr2 Sales] AS
  'Max (
    {[Year].[Qtr2]},
    [Measures].[Sales]
  )'
SELECT
{ [Measures].[Max Qtr2 Sales] } on columns,
{ [Product].children } on rows
FROM Sample.Basic

Table 4-111 Output Grid from MDX Example

(axis)	Max Qtr2 Sales
Colas	27187
Root Beer	27401
Cream Soda	25736
Fruit Soda	21355
Diet Drinks	26787