Skip to main content

Celonis Product Documentation

Data Model Definition

In the "Model" section you can add tables to the data model and define foreign key relationships.

50726629.png
  1. The Data Model graph shows you how the tables are linked in your Data Model. You can click on the connections or the cogwheel next to the linking columns to modify the relationship.

  2. In the context menu of the Data Model table you have the following options:

    • Edit

    • Remove

    • Set Activity Table

  3. Additionally the following actions become available once a table has been set as an activity table:

    • Set as default activity table: makes the table the default activity table (e.g. used by a unconfigured Process Explorer)

    • Assign case table: assigns an explicit case table to this activity table

    • Remove activity configuration: removes the activity configuration and makes this a normal table

  4. If you have multiple activity tables, you can turn on the 'Eventlog automerge' toggle. In this case, an additional unified activity table will be created when loading the data model. With the cogwheel next to the toggle you can decide if the function MERGE_EVENTLOG or MERGE_EVENTLOG_DISTINCT should be used to merge the multiple activity tables. More details on the different functions are available here and on the automerge in general here.

50726628.png

In the foreign key editor you have the option to define the linking columns of the two tables.

Based on your selection, the table header shows whether the table was selected as a dimension table with cardinality 1 or as a fact table with cardinality n. This can be changed by clicking on "Swap Tables". If your selection does not match the table data, loading the data model can swap the tables accordingly.