Results Reporting Preparation

This section contains the following functions that combine data for reporting purposes:

Update Group Currency Amounts

This Transfer Structure function is used to prepare data for reporting purposes.

The results of the calculation have been saved in additional key figure fields. To ensure the good presentation, the key figures are transformed (unpivoted) in the characteristic “Key Figure” of field Amount in Group Currency, and in specific values of the characteristic “Tax Position Top Node”.

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

  • Transfer Structure Type is set to the default value “Transfer Structure” to transfer the values to columns.

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

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

  • Ensure Distinct Results is set to “No” as only produced rows are needed for further calculations.

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

  • Retain Fields is set to “All Fields” to retain all fields used in this function.

  • Aggregate Result is set to “Group Characteristics”, key figures are automatically aggregated using all input characteristics as grouping fields.

Calculate Results

This Join function is used to consolidate results for reporting purposes.

This Join function is an executable function that triggers the calculation run. The calculation functions defined in node Processing will be triggered through this function.

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 (IIR or UTPR) 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”, because all fields are assumed to be filled and it does not need to engage left outer joins or lookups to complete them.

Update Calculated Run

This Join function is an executable function. It is used as the final step to call the Writer functions that update a dataset in specific model tables.

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 (IIR or UTPR) 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.