Parameters window

Admin |

ETL > ETL Domains > Parameters

Note: if the ETL domain is locked, the window will open in read-only mode.

Actions on this page

Element	Description
	This filters the data shown on the page.
	This adds a row in order to insert a new parameter.
	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

Please find below the most important fields.

Field	Description
Mandatory attributes
Code	Unique ID of the parameter
Description	Description of the parameter in the languages enabled in the application environment
Type	Parameter type: - From Dimension dictionary: range of possible values from among those contained in the dictionary defined for the indicated dimension; - From imported data: the range of values are those contained in the dimension indicated when the parameter is defined. This type of parameter can only be used after the Extraction step. - Free: The value of the parameter is indicated manually by the user. In cases of Multiselection the values must be separated by a comma; - Imported data intersection: identifies the range obtained from the combinations of values of other dimensions defined on other From imported data type parameters which have the same Parameter Code defined in the Parent field. For example, to be able to filter with the possible Scenario/Period pairs, you can: define a “Scenario” parameter and a “Period” whose typeis From imported data; define a “Scenario/Period” parameter whose typeis Imported data intersection; associate the “Scenario/Period” parameter with “Scenario” and “Period”, parameters as the Parent parameter: thus, the values of the “Scenario/Period” parameter are the possible combinations of the values of the “Scenario” and “Period” parameters. - From Tagetik: values contained in a field of a CCH Tagetik table. For example, you can create a Parameter whose values are the entity codes present in the Entity table. In this case, you must define the Table attribute as ENTITY and the Field as COD_AZIENDA;
Detailed attributes
Dimension	- Mandatory for all parameters, except those whose type is Imported data intersection; indicates the date format that the data to be imported will have.
Parent	- Only enabled for parameters whose type is From imported data; indicates the Imported data intersection type parameter shared by other parameters with the same Parent.
Table	- mandatory for parameters whose type is From Tagetik; indicates the table from which to load the selectable values.
Field	- mandatory for parameters whose type is From Tagetik; indicates the field from which to load the selectable values.
Multiselection	- if it is possible to select more than one value for the parameter.

All parameters are used to filter (exclude/delete records depending on where they are used), except for those whose type is From Tagetik and Imported data intersection with the Multiselection option deactivated that are used in a Parameter choice type transformation task. In that case, the selected value is used not to delete the records which have a different value, but to override the definition of the field for the dimension related to the parameter for all records present at that time in the staging table.

Example

If the dimension related to a parameter defined in the Identity field (see Dimensions and Dictionaries window) is one of the Entity, Scenario, Period, Event scenario, Category, Custom Dimensions values, the system will display the values defined in the process, and those for which the current user has visibility, in the range of values.

In the case of a user who only has visibility rights over entities A01, A02 and A03, to be able to select only the entities visible to them, just define a parameter whose type is From Tagetik with the Table field defined as the ENTITY value, the Field field defined as the COD_AZIENDA value and associate it with a Dimension which has its as its Identity the Entity value.