Selecting and Setting Up Data Consumer

A consumer determines an object, to which data will be loaded after a block is calculated.

A data consumer can be selected and set up on the Consumer page in the calculation block editing wizard:

To select and set up a data consumer:

1. Select the data consumer in the drop-down list.
   The following repository objects can be used as a data consumer:

• Standard cube.

• Cube view.

• Virtual cube.

• Automatic cube.

• Time series database.

2. Select calendar role. By default calendar is considered as a calendar dimension and it cannot be used to set filtering or set up calculation formula. To work with calendar as a standard dimension, click the button next to the drop-down list to select a data consumer. Calendar will be displayed in the consumer dimension list and it can be used a standard dimension. To work with calendar as calendar dimension, release the button.

NOTE. Calendar role dimension is available, if formulas are not set for calculation block.

3. Select checkboxes of the consumer dimensions, by which filtering by elements will be executed. Filtering enables the user to calculate only dimension elements. The filtered dimensions are also not used in creating block calculation formulas. Formulas are composed only for non-filtered dimensions.

If the dimension selection is used in calculation formulas, selecting the checkbox returns the confirmation to reset the selection. After confirming the action the selection in formula terms will be reset, and operand element selection method setting from parameter will be reset. The dimension filtering setting will also change for filtering by all dimension elements.

NOTE. After resetting the selection manually edit formula terms.

When the checkbox is deselected, the Fix Selection dialog box opens that is identical to the Delete Link dialog box. Set selection fixation if dimension selection is used in calculation formulas, and click the OK button. After the checkbox is deselected, filtering by data consumer dimension elements is not executed. Calculation formulas will use fixed selection.

NOTE. If the Fix Later radio button is selected on selecting selection fixation, formula is edited manually.

4. Set up filtering by elements for the checked dimension:

• Click the Set Filter button.

• Double-click the dimension with the main mouse button.

The Set Up Filtering dialog box opens, in which determine data consumer dimension filtering settings.

5. Set up filtering by attribute links for dimension. Filtering reduces the number of elements, by which calculation is executed, based on attribute links.
   To apply this filtering type:

1. Select the dimension.

2. Click the Set Attribute Links button. The Filtering by Attribute Links dialog box opens, in which determine filtering settings. For details see the Setting Up Filtering by Attribute Links section.

6. Deselect the Multithreaded Calculation checkbox to speed up calculation block calculation if algorithm calculation takes one second or less. When the checkbox is deselected, single-threaded calculation is executed. If algorithm calculation takes much time, select the Multithreaded Calculation checkbox to speed up calculation block calculation. Multithreaded calculation is available in multi-core processor systems (that is, the number of threads is equal to the number of processor cores). When calculating algorithm, multithreaded calculation is executed for calculation block if the Multithreaded Calculation checkbox is selected on the ribbon.

NOTE. The checkbox is active only if data consumer dimensions are fixed. Checkbox state is saved together with the calculation block.

As a result, the data consumer in the aggregation block will be set up.

Setting Up Data Consumer Dimension Filtering

Filtering enables the user to calculate only dimension elements. Filtered dimensions do not participate in composing block calculation formulas. Formulas are composed only for non-filtered dimensions.

To select dimension elements, by which a block should be calculated, use the Set Up Filtering dialog box:

See also:

Inserting and Setting Up Calculation Blocks