Subset (MDX)


Updated: March 2, 2016

Returns a subset of tuples from a specified set.

Subset(Set_Expression, Start [ ,Count ] )  

A valid Multidimensional Expressions (MDX) expression that returns a set.

A valid numeric expression that specifies the position of the first tuple to be returned.

A valid numeric expression that specifies the number of tuples to be returned.

From the specified set, the Subset function returns a subset that contains the specified number of tuples, beginning at the specified start position. The start position is based on a zero-based index; that is, zero (0) corresponds to the first tuple in the specified set, 1 corresponds to the second, and so on.

If Count is not specified, the function returns all tuples from Start to the end of the set.

The following example returns the Reseller Sales Measure for the top five selling subcategories of products, irrespective of hierarchy, based on Reseller Gross Profit. The Subset function is used to return only the first five sets in the result after the result is ordered using the Order function.

SELECT Subset  
      ([Product].[Product Categories].[SubCategory].members  
         ,[Measures].[Reseller Gross Profit]  
   ) ON 0  
FROM [Adventure Works]  

MDX Function Reference (MDX)

Community Additions