Adding Parameters

Parameters enable the user to dynamically control block calculation. They can also be used to create block calculation formulas, to set up consumer data filtering and source data filtering.

Calculation block parameters can be added on the Block Parameters page in the calculation block editing wizard:

Add a parameter

Edit parameter

Change parameters order

Delete parameter

Setting Up Parameter

A parameter can be set up in the Object Parameter Properties dialog box:

Specify:

NOTE. After selecting the cube the Dictionary drop-down list will contain only the dictionaries included in the selected cube.

If the dictionary is not displayed in the controlling dimensions list but is included in the cube, dictionary selection or alternative hierarchy is used as parameters values. This dictionary can be selected in the Dictionary drop-down list without specifying the cube in the Source drop-down list.

If the dictionary is displayed in the controlling dimensions list and is a controlled or controlling or controlled and controlling at the same time, add all controlling cube dimensions as calculation algorithm parameters and set selection by the controlling dimension to display dictionary elements selection in the parameter.

See also:

Inserting and Setting Up Calculation Blocks