_firstFromSet

Returns the first members found in the set up to "numeric_expression_maximum" + "numeric_expression_overflow". If "numeric_expression_maximum" + "numeric_expression_overflow" is exceeded, then only the maximum number of members are returned. For a set that has only a few members more than the specified numeric_expression_maximum, the numeric_expression_overflow allows the small set of extra members to be included. If the set has more members than the overflow allows, then only the numeric_expression_maximum members will be returned.

Syntax

_firstFromSet ( set_expression , numeric_expression_maximum ,
 numeric_expression_overflow )

Example 1

_firstFromSet ( [great_outdoors_company].[Products].[Products].
[Product line] , 2 , 8 )

Result

Returns the five members in the Product line set. The first two members are returned within the maximum and the following three members are returned as the overflow.

Result data

Camping Equipment
Golf Equipment
Mountaineering Equipment
Outdoor Protection
Personal Accessories

Example 2

_firstFromSet ( [great_outdoors_company].[Products].[Products].
[Product line] , 2 , 2 )

Result

Camping Equipment, Golf Equipment