ETL 01 · Tagetik Application

Routines 1source
Sources: MAP_MAPPATURA, MAP_IMPORT

Code	Description	Extractions	Transformations	Loadings
`01`	Upload of Marketing Expenses from Transactional Form	1	2	1

ETL Dimensions 13source
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 SCENARIO SCE S 02 2 usages

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

2 ENTITY ENT S 01 3 usages

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

3 COST CENTER CC S — 2 usages

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

4 INITIATIVES INIT S — 2 usages

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

5 ACCOUNT ACC S — 2 usages

Type	Field role	Code
Lookup Lookup Table	Output dim	01
Output Output Target	→ COD_CONTO	01

6 PRODUCT CD2 S — 2 usages

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

7 CUSTOMER CD3 S — 2 usages

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

8 EMPLOYEES CD4 S — 2 usages

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

9 MISC CD5 S — 2 usages

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

10 CATEGORY CAT S — 1 usage

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

11 PERIOD PERIOD S 03 2 usages

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

12 AMOUNT AMOUNT N — 3 usages

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

13 CURRENCY CURRENCY S — 3 usages

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

Parameters 3source
Sources: MAP_PARAMETRO

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

Code Description Type Multi-select Related dimension Source detail Usages

01 SCENARIO Tagetik — 1 SCENARIO SCENARIO.COD_SCENARIO 2 usages

Type	Field role	Code
Extr. Routine — Extraction	Filter param	01 #1
Load. Routine — Loading	Filter param	01 #1

02 ENTITY Tagetik — 2 ENTITY AZIENDA.COD_AZIENDA 2 usages

Type	Field role	Code
Extr. Routine — Extraction	Filter param	01 #1
Load. Routine — Loading	Filter param	01 #1

03 PERIOD From imported data Yes 11 PERIOD From imported data —

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 Data Extraction from Transactional Form Database 11

Used by routines 01 Upload of Marketing Expenses from Transactional Form

DB typeQ

Database query

select cod_scenario,'01' as cod_periodo, cod_azienda, cod_dest1, cod_dest2,cod_dest3,cod_dest4,cod_dest5,'010' as cod_categoria, TESTO_2, IMPORTO_6 AS IMPORTOFROM FORM_DATI WHERE COD_PROSPETTO = 'TR_010'UNION ALLselect cod_scenario,'02' as cod_periodo, cod_azienda, cod_dest1, cod_dest2,cod_dest3,cod_dest4,cod_dest5,'010' as cod_categoria, TESTO_2, IMPORTO_7 AS IMPORTOFROM FORM_DATI WHERE COD_PROSPETTO = 'TR_010'UNION ALLselect cod_scenario,'03' as cod_periodo, cod_azienda, cod_dest1, cod_dest2,cod_dest3,cod_dest4,cod_dest5,'010' as cod_categoria, TESTO_2, IMPORTO_8 AS IMPORTOFROM FORM_DATI WHERE COD_PROSPETTO = 'TR_010'UNION ALLselect cod_scenario,'04' as cod_periodo, cod_azienda, cod_dest1, cod_dest2,cod_dest3,cod_dest4,cod_dest5,'010' as cod_categoria, TESTO_2, IMPORTO_9 AS IMPORTOFROM FORM_DATI WHERE COD_PROSPETTO = 'TR_010'UNION ALLselect cod_scenario,'05' as cod_periodo, cod_azienda, cod_dest1, cod_dest2,cod_dest3,cod_dest4,cod_dest5,'010' as cod_categoria, TESTO_2, IMPORTO_10 AS IMPORTOFROM FORM_DATI WHERE COD_PROSPETTO = 'TR_010'UNION ALLselect cod_scenario,'06' as cod_periodo, cod_azienda, cod_dest1, cod_dest2,cod_dest3,cod_dest4,cod_dest5,'010' as cod_categoria, TESTO_2, IMPORTO_11 AS IMPORTOFROM FORM_DATI WHERE COD_PROSPETTO = 'TR_010'UNION ALLselect cod_scenario,'07' as cod_periodo, cod_azienda, cod_dest1, cod_dest2,cod_dest3,cod_dest4,cod_dest5,'010' as cod_categoria, TESTO_2, IMPORTO_12 AS IMPORTOFROM FORM_DATI WHERE COD_PROSPETTO = 'TR_010'UNION ALLselect cod_scenario,'08' as cod_periodo, cod_azienda, cod_dest1, cod_dest2,cod_dest3,cod_dest4,cod_dest5,'010' as cod_categoria, TESTO_2, IMPORTO_13 AS IMPORTOFROM FORM_DATI WHERE COD_PROSPETTO = 'TR_010'UNION ALLselect cod_scenario,'09' as cod_periodo, cod_azienda, cod_dest1, cod_dest2,cod_dest3,cod_dest4,cod_dest5,'010' as cod_categoria, TESTO_2, IMPORTO_14 AS IMPORTOFROM FORM_DATI WHERE COD_PROSPETTO = 'TR_010'UNION ALLselect cod_scenario,'10' as cod_periodo, cod_azienda, cod_dest1, cod_dest2,cod_dest3,cod_dest4,cod_dest5,'010' as cod_categoria, TESTO_2, IMPORTO_15 AS IMPORTOFROM FORM_DATI WHERE COD_PROSPETTO = 'TR_010'UNION ALLselect cod_scenario,'11' as cod_periodo, cod_azienda, cod_dest1, cod_dest2,cod_dest3,cod_dest4,cod_dest5,'010' as cod_categoria, TESTO_2, IMPORTO_16 AS IMPORTOFROM FORM_DATI WHERE COD_PROSPETTO = 'TR_010'UNION ALLselect cod_scenario,'12' as cod_periodo, cod_azienda, cod_dest1, cod_dest2,cod_dest3,cod_dest4,cod_dest5,'010' as cod_categoria, TESTO_2, IMPORTO_17 AS IMPORTOFROM FORM_DATI WHERE COD_PROSPETTO = 'TR_010'

Field mapping

#	Dimension	Database column
1	SCENARIO	`COD_SCENARIO`
2	ENTITY	`COD_AZIENDA`
3	COST CENTER	`COD_DEST1`
4	INITIATIVES	`TESTO_2`
6	PRODUCT	`COD_DEST2`
7	CUSTOMER	`COD_DEST3`
8	EMPLOYEES	`COD_DEST4`
9	MISC	`COD_DEST5`
10	CATEGORY	`COD_CATEGORIA`
11	PERIOD	`COD_PERIODO`
12	AMOUNT	`IMPORTO`

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

01 Upload into main Table of Facts DATI_SALDI_LORDI 14

Written by routines 01 Upload of Marketing Expenses from Transactional Form

Target column	Update	Source — dimension or value	Aggregation
`COD_SCENARIO`	By dimension	`1` SCENARIO	Group by
`COD_AZIENDA`	By dimension	`2` ENTITY	Group by
`COD_DEST1`	By dimension	`3` COST CENTER	Group by
`COD_CONTO`	By dimension	`5` ACCOUNT	Group by
`COD_DEST2`	By dimension	`6` PRODUCT	Group by
`COD_DEST3`	By dimension	`7` CUSTOMER	Group by
`COD_DEST4`	By dimension	`8` EMPLOYEES	Group by
`COD_DEST5`	By dimension	`9` MISC	Group by
`COD_PERIODO`	By dimension	`11` PERIOD	Group by
`IMPORTO`	By dimension	`12` AMOUNT	SUM
`IMPORTO_VALUTA_ORIGINARIA`	By dimension	`12` AMOUNT	SUM
`COD_VALUTA`	By dimension	`13` CURRENCY	Group by
`COD_VALUTA_ORIGINARIA`	By dimension	`13` CURRENCY	Group by
`COD_CATEGORIA`	By value	`010`	Group by

Lookup Tables 1source
Sources: MAP_REGOLA_TAB, MAP_REGOLA_TAB_ELEMENTO

Code Description Type Dims in/out Rows

01 Mapping of Initiatives to GL Account Manual 1 → 1 4

Used by routines 01 Upload of Marketing Expenses from Transactional Form

Dimension mapping

Input

4INITIATIVES

Output

5ACCOUNT

Mapping content

4 rows

INITIATIVES (4)	ACCOUNT (5)
1	66020
2	66025
3	66015
4	66010

01

Routines 1sourceSources: MAP_MAPPATURA, MAP_IMPORT

ETL Dimensions 13sourceSources: MAP_DIMENSIONE

Parameters 3sourceSources: 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