The Graphic Editor is the base for any operations that are performed with the data in your data model. It gives you a graphical map of all tables with their foreign-key relations, which link the single tables of a data model together.
To use the tables for an analysis in CPM 4, you need to define relations by using primary - and foreign keys.
Graphic editor components
The Graphics Editor shows your current connected tables and allows you to assign the relations between them and which of their columns you which to display. You can also freely move the tables with Drag & Drop without affecting their relations.
Two tables may be linked on the graphic editor by combining their foreign keys.
Process:
Click with left mouse button on the key symbol (1) of your first table.
Move the mouse to the key symbol of the second table (2) and click to select it. The selected key should be the corresponding foreign key which allows the establishment of a connection between the two tables.
To cancel a selection before the connection was made, simply click on any blank space on the screen. After the connection was made, cancel it by clicking on the corresponding x button.
Connections between columns of two databases may only be done in pairs (that is, a column of a certain database should not be connected to more than one column of another database). If the connection requires the concatenation of two columns of a same database, this must be done previously on your database system before importing it to the Celonis engine. |