ETL 05 · Tagetik Application

Routines 1source
Sources: MAP_MAPPATURA, MAP_IMPORT

Code	Description	Extractions	Transformations	Loadings
`010`	Trial Balance Extract	1	6	1

ETL Dimensions 17source
Sources: MAP_DIMENSIONE

Semantic mapping of staging fields (CAMPO1…CAMPO130) to functional meanings within this domain. Dimension codes appear in operation input/output and lookup table definitions.

Code Description Acronym Type Identity Usages

1 Year YR S — 2 usages

Type	Field role	Code
Transf. Routine — Transformation	SQL body (CAMPO)	010 #30
Src.fmt Source Format	Input field	01

2 Month MN S 03 2 usages

Type	Field role	Code
Src.fmt Source Format	Input field	01
Output Output Target	→ COD_PERIODO	010

3 Entity ENT S 01 3 usages

Type	Field role	Code
Transf. Routine — Transformation	SQL body (CAMPO)	010 #40
Src.fmt Source Format	Input field	01
Output Output Target	→ COD_AZIENDA	010

4 GL Account ID GL S — 2 usages

Type	Field role	Code
Lookup Lookup Table	Input dim	01
Src.fmt Source Format	Input field	01

5 GL Account Description GLD S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	01

6 Cost Center CC S — 2 usages

Type	Field role	Code
Src.fmt Source Format	Input field	01
Output Output Target	→ COD_DEST1	010

7 Product PRD S — 2 usages

Type	Field role	Code
Src.fmt Source Format	Input field	01
Output Output Target	→ COD_DEST2	010

8 Customer CST S — 2 usages

Type	Field role	Code
Src.fmt Source Format	Input field	01
Output Output Target	→ COD_DEST3	010

9 Invoice Number INNUM S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	01

10 Invoice Date INDATE D — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	01

11 Supplier SUP S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	01

12 Amount AMNT N — 3 usages

Type	Field role	Code
Src.fmt Source Format	Input field	01
Output Output Target	→ IMPORTO	010
Output Output Target	→ IMPORTO_VALUTA_ORIGINARIA	010

13 Invoice INV S — 1 usage

Type	Field role	Code
Src.fmt Source Format	Input field	01

14 Scenario SCN S 02 2 usages

Type	Field role	Code
Transf. Routine — Transformation	Output dim	010 #30
Output Output Target	→ COD_SCENARIO	010

15 TGK ACCOUNT TGK S — 4 usages

Type	Field role	Code
Transf. Routine — Transformation	Output dim	010 #10
Transf. Routine — Transformation	SQL body (CAMPO)	010 #25
Lookup Lookup Table	Output dim	01
Output Output Target	→ COD_CONTO	010

16 Currency CURR S — 3 usages

Type	Field role	Code
Transf. Routine — Transformation	Output dim	010 #40
Output Output Target	→ COD_VALUTA	010
Output Output Target	→ COD_VALUTA_ORIGINARIA	010

17 Error Message ERRMSG S — 1 usage

Type	Field role	Code
Transf. Routine — Transformation	Output dim	010 #25

Parameters 4source
Sources: MAP_PARAMETRO

Domain-level parameters available as {P_xxx} tokens in filter expressions.

Code Description Type Multi-select Related dimension Source detail Usages

010 Year From imported data — 1 Year From imported data —

020 Entity From imported data — 3 Entity From imported data 1 usage

Type	Field role	Code
Load. Routine — Loading	Filter param	010 #10

030 Period From imported data — 2 Month From imported data 1 usage

Type	Field role	Code
Load. Routine — Loading	Filter param	010 #10

040 Scenario From imported data — 14 Scenario From imported data 1 usage

Type	Field role	Code
Load. Routine — Loading	Filter param	010 #10

Source Formats 1source
Sources: MAP_FORMATO_INPUT, MAP_FORMATO_INPUT_DIMENSIONE

Input data formats read by extractions in this domain.

Code Description Type Fields

01 Upload File XLSX 13

Used by routines 010 Trial Balance Extract

Field mapping

#	Dimension	XLSX column
1	Year	`Year`
2	Month	`Month`
3	Entity	`Entity`
4	GL Account ID	`GL Account ID`
5	GL Account Description	`GL Account Description`
6	Cost Center	`Cost Center`
7	Product	`Product`
8	Customer	`Customer`
9	Invoice Number	`Invoice Number`
10	Invoice Date	`Invoice Date`
11	Supplier	`Supplier`
12	Amount	`Amount`
13	Invoice	`Invoice`

Output Targets — Tagetik 1source
Sources: MAP_EASY_OUTPUT, MAP_EASY_OUTPUT_DIMENSIONE

Tagetik tables written by loadings in this domain.

Code Description Target table Fields

010 Upload into main Table of Facts DATI_SALDI_LORDI 14

Written by routines 010 Trial Balance Extract

Target column	Update	Source — dimension or value	Aggregation
`COD_PERIODO`	By dimension	`2` Month	Group by
`COD_AZIENDA`	By dimension	`3` Entity	Group by
`COD_DEST1`	By dimension	`6` Cost Center	Group by
`COD_DEST2`	By dimension	`7` Product	Group by
`COD_DEST3`	By dimension	`8` Customer	Group by
`IMPORTO`	By dimension	`12` Amount	SUM
`IMPORTO_VALUTA_ORIGINARIA`	By dimension	`12` Amount	SUM
`COD_SCENARIO`	By dimension	`14` Scenario	Group by
`COD_CONTO`	By dimension	`15` TGK ACCOUNT	Group by
`COD_VALUTA`	By dimension	`16` Currency	Group by
`COD_VALUTA_ORIGINARIA`	By dimension	`16` Currency	Group by
`COD_CATEGORIA`	By value	`010`	Group by
`COD_DEST4`	By value	`EE_500`	Group by
`COD_DEST5`	By value	`NA`	Group by

Lookup Tables 1source
Sources: MAP_REGOLA_TAB, MAP_REGOLA_TAB_ELEMENTO

Code Description Type Dims in/out Rows

01 Mapping of Local Accounts to Corporate CoA Manual 1 → 1 32

Used by routines 010 Trial Balance Extract

Dimension mapping

Input

4GL Account ID

Output

15TGK ACCOUNT

Mapping content

32 rows

GL Account ID (4)	TGK ACCOUNT (15)
5151010	50010
5551900	50010
5391010	50010
6278900	50015
50330000	65035
50330001	65035
50330003	65035
50330004	65035
50330002	65035
6191010	65075
6191011	65075
6191210	65075
7101901	75010
7019010	75010
7101900	75010
65020-5I	65025
65020-5	65025
6503001	65030
6503005	65030
6503002	65030
70010-10	70010
70010-15	70010
70015	70015
7502002	75020
7502003	75020
7502001	75020
120120	10020
120130	10020
120110	10020
20010010	20010
20010020	20010
20010030	20010

05

Routines 1sourceSources: MAP_MAPPATURA, MAP_IMPORT

ETL Dimensions 17sourceSources: MAP_DIMENSIONE

Parameters 4sourceSources: MAP_PARAMETRO

Source Formats 1sourceSources: MAP_FORMATO_INPUT, MAP_FORMATO_INPUT_DIMENSIONE

Output Targets — Tagetik 1sourceSources: MAP_EASY_OUTPUT, MAP_EASY_OUTPUT_DIMENSIONE

Lookup Tables 1sourceSources: MAP_REGOLA_TAB, MAP_REGOLA_TAB_ELEMENTO