Max

Returns the maximum of values found in the tuples of a set.

Syntax

Max ( set [,numeric_value_expression ] )

set The set to search for values.
numeric_value_expression Optional numeric value expression.

Description

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

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
Max Qtr2 Sales
Colas 27187
Root Beer 27401
Cream Soda 25736
Fruit Soda 21355
Diet Drinks 26787

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com