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:
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.
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.
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.
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:
Select the dimension.
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.
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. Multithreaded calculation is available in multi-core processor systems: the number of threads is equal to the number of processor cores. If calculation block contains formulas that are calculated for a long period of time and the number of iterations in formulas are greater than the threads number, select the Multithread Calculation checkbox to improve performance and speed up block calculation using parallel iteration calculation.
Multithread block calculation will be executed on algorithm calculation, if the Multithread Calculation checkbox is selected on 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.
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:
Setup order:
Select elements, by which a block should be calculated. Select one of the radio buttons:
All Elements. A block is calculated by all dimension elements.
Selected Elements. A block is calculated by dimension elements selected in this list.
From Parameter. A block is calculated by elements specified by a parameter. The option is available if a block contains parameters.
If it is required that a block is calculated by all the elements except for the selected ones, select the Exclude Selected Elements checkbox.
To set the conditions, with which element attributes must satisfy on block calculation, use the Advanced Filter group of parameters. Working with this group of parameters is similar to working with the Advanced Filter dialog box.
After executing the operations the block is calculated only by the elements corresponding to the filter.
See also:
Inserting and Setting Up Calculation Blocks