Show TOC

Enrich Data

The enrichment of data can be done separately per calculation unit to determine the analytic key figure and characteristic values, which are needed for a certain closing unit or calculation purpose. In general, the following functions are used for this:

  1. Transfer Structure

    Transfer structures are used to pivot amounts of accounting-like data, such as business transactions or postings from a vertical representation into horizontal semantic key figures, such as disbursements, commissions, or premiums.

  2. Derivation

    Derivations use “if-then-else” rules and/or formulas to determine the value of characteristics and key figures. Derivations are typically used to complete data with information, which is not already given by the source, for example, analytical or calculation purpose-specific attributes.

  3. Lookup

    Lookups use rules in combination with lookup tables to complete missing data and to add analytical information.

  4. Views

    Views are used to project or aggregate data including necessary selections by filters, calculations by formulas, and field mappings. They are typically placed “on top” of sample read functions to transform the data into the needed format and granularity.