Information in this tab’s grid (Fig.) is system-generated and displays every field from two previous tabs and their respective aliases used by the system to identify the origin of the selected column.
The read-only pane on the left side of the tab lists fields involved in Aggregation broken down by three categories:
2. Calculated Fields
3. Auxiliary Fields
Field Mapping Parameters Pane
Displays mapping detail for each field. Each row in the pane’s grid represents a Data Model involved in the Aggregation.
Displays the names of models assigned to the current Aggregation.
As a rule, Mapping is done automatically. The system searches through the data models involved in the Aggregation identifying the columns that correspond to the selected details and calculation fields.
You can modify by-default mapping by selecting other column names from the lookup.
1. Click on button to open the lookup window.
2. Select an appropriate column name from the lookup and click OK
If the system fails to map a data attribute to a column in one or several data models, the corresponding cells will be left blank. In this case, the mapping should be done either manually or using the lookup button and following the above-described steps.
The system allows you to fine-tune the mapping by writing an SQL expression into the Expression field.
For example, you may want to insert an expression for currency conversion, Buy/Sell indicator selection, etc. The lookup, in this case, will provide you with referenced column names preceded with the $ sign.
Note: In order to appear in the Lookup, reference columns must be set up as auxiliary fields.
This field becomes active when a Calculation formula is used. You are enabled to select the appropriate Data format from the arrow button menu (Fig.).
This field becomes active when a Calculation formula is used and Value Type is set on ‘Character’. Input here indicates what number of characters the value in the field would NOT exceed.
This field becomes active when a Calculation formula is used. Check Mark here will allow nulls in the Calculated field.