HEAD

Description:

It is used to return the first specified number of elements in a set, while retaining duplicates.

Syntax:

Head(Set_Expression [ ,Count ])

Return Type:

SET

Parameters:

Parameter	Description

Parameter	Description
Set_Expression	It is a valid MDX expression that returns a set.
Count	It is a valid numeric expression that specifies the number of tuples to be returned.

Example:

SELECT   
[Measures].[Reseller Gross Profit] ON 0,  
Head  
   (Order   
      ([Product].[Product Categories].[Sub Category].members  
         ,[Measures].[Reseller Gross Profit]  
         ,BDESC  
      )  
   ,5  
   ) ON 1  
FROM [AdventureWorksMF]