HEAD
This documentation is for Kyvos 2026.3.x. To view documentation for other Kyvos versions, click here. |
|---|
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].[Reseller Gross Profit] ON 0,
Head
(Order
([Product].[Product Categories].[Sub Category].members
,[Measures].[Reseller Gross Profit]
,BDESC
)
,5
) ON 1
FROM [AdventureWorksMF]