If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

about block functions

Started by subhash, 26 Nov 2007 11:07:05 PM

Previous topic - Next topic

subhash

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.


Venu_Gollapudi

_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

subhash

can u explain it clearly so that we can understand.

in our words explain it.