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 |
|---|---|
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].[Internet Sales Amount] ON COLUMNS,
Head([Product].[Product Categories].[Category].Members, 5) ON ROWS
FROM [Adventure Works]