.png)
Min (MDX)
SQL Server 2012
Returns the minimum value of a numeric expression that is evaluated over a set.
If a numeric expression is specified, the specified numeric expression is evaluated across the set and then returns the minimum value from that evaluation. If a numeric expression is not specified, the specified set is evaluated in the current context of the members of the set and then returns the minimum value from that evaluation.
Note
|
|---|
|
Analysis Services ignores nulls when calculating the minimum value in a set of numbers. |
Example
The following example returns the minimum quarterly sales for each subcategory and each country in the Adventure Works cube.
WITH MEMBER Measures.x AS Min
([Date].[Calendar].CurrentMember.Children
, [Measures].[Reseller Order Quantity]
)
SELECT Measures.x ON 0
,NON EMPTY [Date].[Calendar].[Calendar Quarter]*
[Product].[Product Categories].[Subcategory].members *
[Geography].[Geography].[Country].Members
ON 1
FROM [Adventure Works]
