Operations

Application database > Analytical Workspaces tile > workspace tile > (Data Transformation Package tab) DTP tile > > Operations

Application database > Navigation panel > Analytic Information Hub > workspace tile > (Data Transformation Package tab) DTP tile > > Operations

Purpose of the page

This page allows you to create operations for DTP activities.

Page structure

Element	Description
List of operations	Shows the list of operations existing in the activity and allows you to change its execution order.
Activity information	Shows contextual information on the activity. - Description: description of the activity - Dataset: description of the target dataset - Typology: typology of the target dataset
Operation attributes	Shows specific properties for the selected operation

Attributes tab

The displayed fields will depend on the type of operation that has been selected.

Element	Description
Operation type	Type of operation to be run. Once defined, it can no longer be changed. For more details on operation types, see Operations.
Operation	Operation ID.
Description	Description of the operation in all system languages.
Execution conditions	Allows you to enter, with SQL syntax, the conditions to be checked in order to run the operation. If not specified, the operation will be performed automatically.
Source dataset	With operations such as Insert from other dataset / Enrichment from other dataset / Insert with reference dataset /Join from other dataset / Check missing keys / Delete missing keys / Insert with unpivot transposition / Insert with pivot transposition / Insert with calculation rules: - allows you to select the dataset or datasource from which to read the data. In case of Insert from another dataset/Enrichment from another dataset, it is not possible to select datasources which have a database other than the current database in their Connection fields.
Typology	With operations such as Insert from other dataset / Enrichment from other dataset / Insert with reference dataset / Join from other dataset / Allocations / Check missing keys / Delete missing keys / Insert with unpivot transposition / Insert with pivot transposition / Insert with calculation rules: - Allows you to select a source dataset typology. Note: if a datasource is set as the source dataset, only the Reporting Layer typology can be selected.
Source filter	With operations Insert from other dataset / Enrichment from other dataset / Insert with reference dataset / Join from other dataset / Allocations / Check missing keys / Delete missing keys / Insert with unpivot transposition / Insert with pivot transposition / *Insert with calculation rules*: - Allows you to insert an SQL filter to be applied to the dataset being read, to reduce the number of records considered as the operation's source.
Target filter	With operations Enrichment from other dataset / Enrichment with formula / Enrichment with formula field / Enrichment with reference dataset / Join from other dataset / Delete multiple keys / Delete missing keys / Check with formula / Check with dictionary / Check with rule / Check missing keys / Checking existence / Check multiple keys: - allows you to insert an SQL filter to reduce the data on which to run the operation.
SQL formula	With Check with formula operations: - allows you to insert the SQL formula to be verified to run the check. With delete with formula operations: - it is used to identify the data to be deleted. AW parameters can be used to make the operation parametric.
All fields with dictionaries	With Check with dictionary operations: - if active, checks all fields containing a dictionary.
Fields to check	With Check with dictionary operations: - allows you to select the fields associated with dictionaries to be checked.
Enrich only null values	With operations Enrichment from other dataset / Enrichment with formula / Enrichment with formula field / Enrichment with reference dataset / Join from other dataset: - When active, the operation only updates fields with empty values. Note: rows containing formulas the results of which have null value will not be changed.
Run row by row	With enrichment from other dataset/enrichmentwith formula operations, only on DB HANA database: - Runs the dataset update with an Update instruction. Note: can only be used for Hana DB at present. Note: cannot be used if there are aliases in the source formula of a field relationship.
Target field	With Enrichment with formula field operations: - allows you to indicate the field to be defined through the formula. With Enrichment with ranking operations: - allows you to specify the field to be enriched with the rank value
Formula field	With Enrichment with formula field operations: - allows you to indicate the field containing a formula with which to define the target field.
Reference dataset	With operations Enrichment with Reference dataset/Insert with reference dataset/Insert with calculation rules : - allows you to insert an SQL filter to apply to the reference dataset. With Check - existence operations: - allows you to insert the reference dataset in which the existence fields and condition fields are indicated.
Reference dataset filter	With operations Enrichment with reference dataset / Insert with reference dataset / Existence check / Insert with calculation rules: - allows you to set an SQL filter with which to filter the reference dataset data.
Advanced settings	With Enrichment with Reference dataset operations: - allows you to insert ranges as condition column values. See Advanced settings page.
Dataset to be allocated	With Allocations type operations: - allows you to select the dataset containing the data to be allocated.
Driver dataset	With Allocations type operations. - allows you to select the dataset to be used as the driver.
Driver typology	With Allocations type operations. - allows you to select the driver dataset typology.
Details	With Allocations type operations. - allows you to insert information on the source and target of the data to be allocated and to define the allocation driver dataset. See Allocation details page.
Checking rule labels	With Check with rule operations: - allows you to select a label related to the checking rule of the target dataset or the datasource. Only checking rules containing the selected label are run. Note: if not specified, the system runs all the rules compatibly with what is defined in Checking rule type.
Checking rule type	With Check with rule operations: - allows you to select a checking rule type: - Coherence: only runs Check - coherence rules. - Congruence: only runs congruence check rules. - Existence: only runs existence check rules. - All: runs all checking rules. See Checking Rules.
Message for the user	With operations Check with formula / Check with dictionary / Check with rule / Check missing keys / Check multiple keys: - allows you to insert the message to be shown in the audit when the outcome of the check is negative. If not specified, the audit will show a default message.
Datasource Mapping	With loading on Analytical Workspace operations: - allows you to select a datasource mapping from which to obtain the operation's target fields.
Special method	With special method operations: - allows you to define a customised operation as an SQL script. Note: a special method can have the same code in all the managed databases. When defined, the Special method parameters tab will appear.
SQL sorting criterion	With Delete multiple keys operations: - allows you to define an SQL sorting criterion for the fields of the dataset being deleted Note: if not set, the entire list of user-defined fields in the target dataset will be used, applying an ascending sort order to each field.
Ranking type	With Enrichment with ranking operations: - allows you to select a type of ranking - Differentiate sorting: corresponds to the ROW_NUMBER function. The ranking number is incremented for each record in the section that has the same values in the fields defined by the sorting criteria The rank value is initialised for each section. - Keep sorting: corresponds to the DENSE_RANK function. The same ranking value is assigned to records within the same section that have identical values in the fields defined by the sorting criteria. The ranking value is increased for each section.
Sorting rule	With Enrichment with ranking operations: - allows you to specify the SQL sorting criterion
Fields Mapping	With operations Insert from other dataset / Enrichment from other dataset / Enrichment with formula / Insert with reference dataset / Join from other dataset / Check missing keys / Delete missing keys / Insert with unpivot transposition / Insert with pivot transposition: - allows you to define correspondence between the fields of a source dataset and a target dataset, to pilot the enrichment of the target dataset fields. See Matching fields page. Note: with Insert from other dataset and insert with pivot transposition operations, it is not necessary to define the matching field. Note: with Insert with reference dataset, in the absence of field relationships, or in the presence of a "All others" field relationship, the target dataset fields are defined using the fields that have the same name and are present, in order, on the reference (attribute) dataset or source dataset.
Key fields	With delete multiple keys / *Check multiple keys operations: - allows you to define which fields of the dataset should form the key used to identify duplicate rows. See Matching Fields page. With Enrichment with ranking* operations: - allows you to define which fields of the dataset should form the key used to identify the data sections to be sorted
Source pivot field	With Insert with Pivot transposition operations: - allows you to select the field of the source dataset from which the values to be transposed as target columns will be taken
Pivot value source field	With Insert with Pivot transposition operations: - allows you to select the field of the source dataset from which the values to be inserted as the contents of the transposed columns will be taken
Pivot value source field - grouping mode	With Insert with Pivot transposition operations: - allows you to select the aggregation function used for the pivot value source field
Pivot attribute target field	With Insert with unpivot transposition operations: - allows you to select the text type field of the target dataset where the aliases of the pivot-type matching field will be written
Pivot value target field	With Insert with unpivot transposition operations: - allows you to select the field of the target dataset where the values corresponding to the transposed column will be written.
Formula operand field	With Insert with calculation rules operations: - allows you to select the field in the source dataset corresponding to the column containing the operands to be used in the script formulas. Note: Must have the same name on both the source and the target
Value field	With Insert with calculation rules operations: - allows you to select the source dataset field corresponding to the column containing the values to be processed Note: Must have the same name on both the source and the target
Calculation rule	With Insert with calculation rules operations: - allows you to select the label associated with the calculation rules to be run. Given a source dataset and the logical dimensions table, the operation takes account of all scripts that are labelled as indicated in the operation. The result will be written into the target dataset indicated in the DTP activity.
Loop	Specifies the loop to which the operation belongs. See Definition of activity and operation loops.

Special method parameters tab

Element	Description
Special method parameters	These allow you to insert values for customised parameters defined in the special methods table (see Special methods page). If there are no customised parameters on the special method, the tab will remain empty.