hi,
can anyone give the usage of block functions. there are two block functions.
_firstfromset:
_remainederset:
i want the explanation of them with the example.
_firstfromset:
Returns the first members found in the set up to numeric_exp_max +
numeric_exp_overflow. If numeric_exp_max + numeric_exp_overflow
is exceeded, then only the max number of members are returned.
For a set that has only a few members more than the specified
numeric_exp_max the numeric_exp_overflow allows the small set of
extra members to be included. If the set has a large number of
members then only the numeric_exp_max members will be returned
as the remainder of the set is greater than the specified overflow
value.
Ex:
_firstFromSet([great_outdoors_company].[Products].[Products].[Prod
uct line],2,2)
Result:
Camping Equipment
Golf Equipment
_remainderSet
The member expression will be included in the returned set when the
size of the set_exp set is greater than numeric_exp. i.e. a new
member will be generated if the number of members in set_exp larger
than the specified numeric_exp
Ex:
_remainderSet(member(aggregate( currentMeasure WITHIN SET
[great_outdoors_company].[Products].[Products].[Product line]),
'Product Aggregate', 'Product Aggregate',
[great_outdoors_company].[Products].[Products]),[great_outdoors_co
mpany].[Products].[Products].[Product line],1)
Quantity
Product Aggregate 2,215,300
can u explain it clearly so that we can understand.
in our words explain it.