head
Returns the first "index_expression" elements of "set_expression". The default for "index_expression" is 1.
Syntax
head ( set_expression [ , index_expression ] )Example 1
head ( members ( [great_outdoors_company].[Products].[Products].
[Product line] ) )Result
Camping Equipment
Example 2
head ( members ( [great_outdoors_company].[Products].[Products].
[Product line] ) , 2 )Result
Returns the top two members of the Product line set.
Result data
Camping Equipment
Mountaineering Equipment