Create offline cube files (.cub) with OlapCube. Download Now!


table of contents

Max

Returns the maximum value of a numeric expression evaluated over a set.

Syntax

Max(«Set»[, «Numeric Expression»])

Remarks

The Max function returns the maximum value of a numeric expression, specified in «Numeric Expression», evaluated from a set specified in «Set».

Example

If the respective values in the Sales measure for the USA, CANADA and MEXICO members are 1000, 2000, and 3000, the following example returns 3000:

Max({USA, CANADA, MEXICO}, Sales)