Context

A function that enriches data by mapping fields of the input function (data set 1) to target fields of the output function. Generic and key figure results are the mapping categories of this function.

Characteristic mapping can only have a 1 to 1 relationship and will not allow mapping of several input fields to a single target field. However, key figure mapping allows n to 1 relationships. The value of input fields is totaled and assigned as an output field value.

Prerequisites

You must provide two functions with data (source data) under the Environment function or a Calculation Unit function. One function is the input function (data set 1), and one function is the output function (data set 2), to which the results are to be transferred using the Mapping Function. In business scenarios, mapping functions are used by customers to map the results from a calculation unit to a business unit, or from a calculation unit to another calculation unit.

Steps

1. On the Mapping page, under the Properties roadmap step, choose a Mapping Category from the dropdown list.

   • Generic – allows both Characteristic and Key Figure mapping

   • Key Figure Results - only allows Key Figure mapping.

2. Choose the Map roadmap step

3. On the Map roadmap page, choose an Input from the list of functions. The characteristics and/or key figures of that function will be entered automatically in the Fields column of the table.

   • If on step 1, Generic was chosen: The system fills the Fields column with characteristics and/or key figures.

   • If on step 1, Key Figure Results was chosen: The system fills the Fields column with key figures of the input function ID only and will not display the characteristics.

4. On the Map roadmap page, choose a Target Function from the list of Output Function IDs. The characteristics and/or key figures of the chosen function will then be adopted by the Target Fields column of the table, which can then be used for mapping.

5. To execute mapping, choose a row or field to be mapped, then open the dropdown list for the target field.

6. Choose the target field that is intended to adopt the value of the input field.

7. If the changes are meant to be preserved, choose Save.

8. To generate, choose Generate.

9. For a preview, choose Test.

Example of Mapping