Add a parameter

Edit parameter

Change parameters order

Select displayed columns

Delete parameter

Setting Up Parameter

To set up a parameter, set values of the properties corresponding to table columns:

• Type. Select parameter type:

• String. A character string is used as a parameter value.

• Integer. An integer number is used as parameter value.

• Real. A real number is used as a parameter value.

• Date. A date is used as a parameter value.

• Selection. It is used by default. Dictionary selection is used as a parameter value.

• Name. A parameter name should be meaningful and explain parameter functionality. The property is set to ITEM1 by default. The property is mandatory.

• Identifier. A parameter identifier should be unique. An identifier should consist of Latin letters. It may contain numbers and underscore characters, and must start with a letter. The property is set to ITEM1 by default. The property is mandatory.

• Source. If required, select the cube containing controlling dimensions that control elements of other dimensions in this cube. The field is available only for a parameter with the Selection type.

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.

To undo cube selection as a value of the Source parameter, click the Clear button next to the cube name.

• Dictionary. Select a dictionary, to which a parameter will be bound. Dictionary selection or alternative hierarchy will be used as parameter values. The field is available only for a parameter with the Selection type and is mandatory for it.

NOTE. If a cube is selected in the Source drop-down list, the Dictionary drop-down list displays only the dictionaries contained in the selected cube.

• Selection Type. Select dictionary elements' selection type in the drop-down list:

• None. Selection type is not set. The MultiSelect selection type is used by default.

• SingleSelect. Single selection: only one element at a time can be selected.

• SingleSelectNullable. Single selection with the ability to select empty value.

• MultiSelect. Multiple selection.

Click the element to invert its selection.

Click an element while holding down the SHIFT key to deselect all elements and select the elements (except for collapsed ones) that are located between the focused element and the clicked element.

Click while holding the CTRL key to select or deselect an element and all its child elements. When the context menu is opened in the element area, the element is focused but not selected.

• MultiSelectStandart. Multiple selection. Clicking an element selects only selected element.

To select multiple elements, hold down the SHIFT or CTRL keys while clicking elements.

Click an element while holding down the SHIFT key to deselect all elements and select the elements (except for collapsed ones) that are located between the focused element and the clicked element.

Click an element while holding down the CTRL key to set or remove element selection.

• Default Value. Select the default parameter value in the drop-down list or enter it by means of keyboard.

NOTE. When parameter type changes, the default value is reset.