Configuring the Data Model
Configuring the Data Model is necessary to use fields from different tables within a single visualization component and to ensure proper filtering. Data models are used in dashboards. On this page, global workspace indicators and processes are also configured.
To create a new Data Model, select which table will be used as the fact table — i.e., which table will be the first table in the link. Click on the + Add link below it.
For the second table which will serve as the reference table, click the link icon. You can also create a link by dragging the fact table onto the reference table.
In the dialog box that opens, specify the fact column (the column from the first table that will be used to establish the link) and the reference column (the column from the second table to which the fact column will be linked).
To swap the fact table with the reference table, click the Swap button.
If the tables being linked have many fields, use the column name search for convenience.
The process will become invalid if you swap the fact table and the reference table.
When creating a link, you need to choose the link type.
"Many to one" is a link between two tables where one value from the first table corresponds to multiple values from the second table.
"Many to many" is a link between two tables where one value from the first table corresponds to multiple values from the second table, and one value from the second table corresponds to multiple values from the first table. Thus, the link is bidirectional.
The "Many to many" link is only considered during table filtering and when calculating indicators using the process function.
Confirm adding. The link has been created.
You can establish links between multiple tables.
In the Data Model, a cyclic link cannot be created where the first table is linked to the second, the second to the third, and the third back to the first. This restriction is necessary for the proper functioning of components.
The link becomes invalid if the column involved in the link is modified or deleted via a script. If the link was used in a process, that process also becomes invalid.
You can delete a link in two ways:
- Click on the column involved in the link, and select Delete in the dialog box that appears
- Right-click on the link and select Delete
To delete the whole link table, click the context menu icon and select Delete.
Viewing Table Data
To view the table data, click on it. The console will appear at the bottom.
For convenience, you can expand the console by dragging its top border. To hide the console, click the X icon.
Was the article helpful?