Fields definition - CCH Tagetik Data Target
Admin | 
ETL > ETL Domains > DataTarget link > FielCCH Tagetikds definition
Note: if the ETL domain is locked, the window will open in read-only mode.
Purpose of window¶
This window allows you to indicate, for every field of the table onto which data will be loaded, whether, during the loading step, it must be populated from the values present in a field of the staging table, related to a dimension of the ETL domain, or from an individual value.
IMPORTANT: if the name of a field of a table in the CCH Tagetik application database is deleted or edited, you must edit the fields definition of every Data target: CCH Tagetik in which the reference to that field is present.
Actions on this page
| Element | Description |
|---|---|
| This filters the data displayed on the page. | |
| This adds a row in order to insert a new field | |
| This duplicates the selected row with all the information inserted, except for the code. | |
| Deletes the element contained in the selected row. | |
| Enables/Disables the grid modify function. This allows you to change the characteristics of the selected elements directly in the table, and to hide the configuration tabs. | |
| Enables multi-row selection to allow mass changes. | |
| Selects the columns to be shown/hidden in the table and those to be locked when scrolling the table. | |
| Exports the data in Excel format so they can be edited and reimported into CCH Tagetik. | |
| Imports data from a previously prepared Excel file. |
Attributes tab
The following elements can be defined in this tab:
| Field | Description |
|---|---|
| Field | Name of the field to be processed, belonging to the table defined in the Data target: CCH Tagetik. Mandatory |
| Update type | Field population method. Mandatory. Available options: - By dimension: field populated with values present in the field of the staging table related to a dimension of the ETL domain. - By value: field populated with a fixed value. |
| Size | If the Update type By dimension option is active, it indicates the dimension of the ETL domain related to the field of the staging table containing the data to be loaded onto the Field |
| Value | - If the Update type By value option is active, it indicates the value to be set for the Field for all loaded records. |
| Update policy | indicates how the population of the Field on the target table must be managed during an update operation. Mandatory. Possible values: - Always substitute Target dimension value with Source value: the value of the field is always edited, even if its value in the source table is NULL; - Substitute Target dimension only if Source value is not Null: the value of the field will only be edited if the new value is not NULL; - Sum if loading value is not null (only for numeric field): if the new value is not NULL, it will be added to the old value present on the field. |
| Group by | Only active if the Update type By dimension is enabled, indicates that the staging table data, before being loaded, must be grouped by the field of the staging table related to the dimension of the ETL domain defined in the Dimension field; |
| Aggregate function | Indicates that the field in the staging table related to the ETL Environment Dimension defined in the Dimension field must have the configured aggregation function applied. Only active in two cases: - the Update Type is From Dimension - the Value Type is Override current date IMPORTANT: once the Group by option has been activated or a Aggregate function has been indicated for a field, it is necessary to set one of the two fields for all the other records whose Update type is set to By dimension |