Min
The MDX Min function for Essbase returns the minimum of values found in the tuples of a set.
Syntax
Min ( 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 Min is #MISSING if either of the following is true:
-
The input set is empty.
-
All tuple evaluations result in #MISSING values.
Example
For every quarter, the following query displays the minimum monthly sales value.
WITH MEMBER
[Measures].[Minimum Sales in Quarter]
AS
'Min ([Year].CurrentMember.Children, [Measures].[Sales])'
SELECT
{[Measures].[Minimum Sales in Quarter]}
ON COLUMNS,
[Year].Children
ON ROWS
FROM Sample.BasicThis query returns the grid:
Table 4-114 Output Grid from MDX Example
| (axis) | Minimum Sales in Quarter |
|---|---|
| Qtr1 | 31538 |
| Qtr2 | 32917 |
| Qtr3 | 33073 |
| Qtr4 | 31971 |