Working with ETL

Set the data source and target

Admin |

User |

ETL > ETL Domains > Data Source

  1. Define a Data Source. Select the desired source type: specific configuration fields appear.
  2. Associate the Data Source with an extraction task of a routine.
  3. Select the desired of source data.
  4. Click Run.

You can only relate several types of source within the same data source if the information contained is represented in the same way.

Configure the dimension mapping

User |

Admin |

ETL > ETL Domains > Data Source

  1. Access the data source fields definition. Relate the source dimensions to the target dimensions by dragging the columns from the data section of the source to the corresponding row of the target dimension.
  2. Only with target: Data (Amounts, Intercompany), set the management of amounts without a counterparty.
  3. Select the desired previous data deletion policy.
  4. Only with submission processes by scenario/period and Data-type target (Amounts, Intercompany), when the Period length dimension is set to a non-cumulative value, define the desired previous data carry forward policy.