In the Graphic editor of the Data Model Editor, you will see all tables of your Data Model. You can move the tables with Drag & Drop. 

To use the tables for an analysis in SAP Process Mining by Celonis, you need to define relations by using primary - and foreign keys.

 

As an example, we displayed the relations between the activity table and the case table. As you can see in the following screenshot, they are placed next to each other for now.

To search for a key column, use the search field.

 

Click and hold the left mouse button on the key - symbol of your desired key collumn (here: num_id in the Activities Table) to establish a connection to the key of the other table (here: case_num_id), by moving the mouse to the key symbol.

 

This step needs to be done with all other tables for the whole data model. 

Alternatively, the foreign keys can be displayed in a list in the Keys tab of the Data Model Editor:

 

By clicking on  , new foreign keys can be generated. To do so, select the tables in the first line's dropdowns. After a click on  a new selection possiblity for the table's columns will appear in the next line. Select the columns that should be used for the foreign key relationship. Multiple columns for the foreign key relationship can be chosen here. 

 

Keep in mind!

Keep in mind that only one to many relationships between tables will result in a working data model.

To edit or delete an already existing foreign key, click on the hover-buttons:

  • No labels