Data Sourcing

Before the Pillar Two calculations are executed, the financial data is mapped to reporting items and consolidated with the manual data.

Flat hierarchy data is firstly prepared in the Prepare for Flat Hierarchy Generation function. flat hierarchy generation and calculation are performed in the Generate Flat Hierarchy function. This data is consolidated with manual added data in the Prepare Tax Positions for Manual Update function. These values are written in Model Table Tax Position Combined Data using the Writer function Combine Tax Position Values.

This section comprises the following functions:

Prepare for Flat Hierarchy Generation

This View function is used to generate one temporary line for flat hierarchy.

In the header of the function, the following settings were configured:

  • View Type is set to “Explicit Fields”. This way, only specified fields from the different data sources are included.

  • Suppress Initial Results is set to “No” to ensure that it can still be viewed later in reporting.

Generate Flat Hierarchy

This Join function is used to generate flat hierarchy based on GL Account.

In the header of the Join function, the following settings were configured:

  • Join Type is set to the default value “Implicit Fields”. This way, all fields from the different data sources are included automatically.

  • Result Handling is set to “Include enriched data” as the output results should only include data records on which the rule was applied.

  • Suppress Initial Results is set to “No” to ensure that it can still be viewed later in reporting.

  • Include Original Input Data is set to “No” as only produced rows are needed for further calculations.

  • Auto Filling is set to “If Null then First to Last” as in case of a null value, the initial value is returned for that field.

Prepare Tax Positions for Manual Update

This Join function is used to eliminate GL accounts and to join the financial data coming from the system and the manually updated data.

In the header of the Join function, the following settings were configured:

  • Join Type is set to the default value “Implicit Fields”. This way, all fields from the different data sources are included automatically.

  • Result Handling is set to “Include enriched data” as the output results should only include data records on which the rule was applied.

  • Suppress Initial Results is set to “No” to ensure that it can still be viewed later in reporting.

  • Include Original Input Data is set to “No” as only produced rows are needed for further calculations.

  • Auto Filling is set to “No” as all fields are assumed to be filled and left outer joins or lookups are not required to complete the calculation.

Combine Tax Position Values

This Writer function is used to write values to the Tax Position Combined Data Model Table.

In the header of the Writer function, the following settings were configured:

  • Output Function = “Tax Position Combined Data”

  • Model Writer Type = “Delete and Insert”, which means that the system deletes existing data and then inserts new data