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 |