In this lesson, we continue with enrichment functionalities of the Universal Model. The next topic is Derivation – a function which helps us to derive certain values based on specified conditions.
What Is Derivation?
Derivation is a data enrichment function used to augment existing data in a dataset by calculating new attributes based on predefined rules or dynamic rules applied at runtime. This process ensures that your data is more comprehensive and valuable for analysis.
Key Functionalities of Derivation
- Rules-Based Enhancement: Enhance your data using both static and dynamic rules.
- CASE WHEN Principle: Derivation rules follow the CASE WHEN principle, allowing for flexible and conditional data transformation.
- Condition and Assignment: Each rule comprises two elements: Condition and Assignment.
- Condition: Works as the CASE part of the rule where selections are defined.
- Assignment: Specifies the resulting value or attribute to be assigned when the condition is met.
Configuration of a Derivation
- You will need to set up your Key Figure, Association and Characteristic Fields.
- Create a model entity that will serve as an Input.
- In Manage Functions, Click on "Create" to Create Derivation Function. Select the environment you were creating the function in and put in "Derivation" Type.
- Fill in "Function" and "Description". Then Click on "Create".
- Go to "Manage Functions" and select the link of the newly created Function. Click on "Edit".
- Fill the "Sender Input". On the "Rules", select "Create".
- Fill in Rule, Description and then add the Selection and in "Assignment" put in the field and to configure the formula.
- Click on "Apply" then "Save".
- Go to the Manage Environment and Activate the environment. Then go to Manage Functions and select the Calculation function then Select "Run".
