To work with the tool in Foresight Analytics Platform 10, use the new interface.
A consumer determines an object, which data will be aggregated and 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 aggregation block editing wizard:
To select and set up a data consumer:
Set up filtering of the selected dimension. To do this:
Click the Set Filter button.
Double-click the dimension.
The Filtering Setup dialog box opens, in which determine data consumer dimension filtering settings.
As a result, the data consumer in the aggregation block is set up.
To select dimension elements, by which a block should be calculated, use the Filtering Setup 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 only by selected dimension elements. The elements list is generated in the Selected Elements area using the buttons:
Select Elements. It adds elements selected in the All Elements area to the Selected Elements area.
Exclude Elements. It removes selected elements from the Selected Elements area.
Filtering will be executed by all elements contained in the Selected Elements area. If it is required to execute calculation by all elements, except for those contained in the Selected Elements area, select the Exclude Selected Elements (N) checkbox, where N is the number of selected elements.
To work with dimension element selection use context menu items. If selection schema is applied to elements in the All Elements area, it is taken into account on moving elements to the Selected Elements area.
To search for an element in each area, start typing name of the searched element in the Search box. When the entire name or its part are entered, the area displays the elements, which names contain the searched character combination.
NOTE. If a parametric cube is selected as a filter, and a link between cube parameter and calculation algorithm parameter is set, the All Elements radio button will be automatically selected if parameter value changes.
From Parameter. A block will be calculated by elements specified via the parameter of the Selection type. The method is available if a block contains parameters of the Selection type.
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. Work with this group of parameters is similar to the work with the Advanced Filter dialog box.
After executing the operations the block is calculated only by the elements corresponding to the filter.
See also:
Getting Started with the Calculation Algorithms Extension in the Web Application | Inserting and Setting Up Aggregation Blocks