process-mining

latest

false

Process Mining

DELIVERY:

Automation Cloud Automation Cloud Public Sector Automation Suite Standalone

Last updated Feb 28, 2025

Data models

Data model requirements

A data model can only be saved when it adheres to the following requirements:

The data model includes no more than 40 tables.
All tables are connected to the overall data model.
There are no circular relations in the data model.
A maximum of four direction changes are allowed in one relation path.

Tip:

A direction change is a one-to-many relation followed by a many-to-one relation, or vice versa.

Important:

If you require a larger data model than the "Max four direction changes" limitation allows, contact UiPath® Customer Support to turn off the limitation for your organization.

Note that turning this limitation off might have a performance implication for your dashboards.

Required output tables

A data model must have a Cases, Event_log, Tags, and Due_dates table.

Note:

Depending on the app template, the Cases table has a process-specific name, for example, Purchase_order_items, or Incidents.

The Cases, Event_log, Tags, and Due_dates table must have the following output fields.

Note:

All the fields are required. However, some fields are allowed to contain only NULL values.

Table	Required output field
`Cases`	`Case_ID`*
`Event_log`	`Case_ID`*
	`Event_start`
	`Event_end`
	`Activity`
	`Activity_order`
	`Automated`
	`Event_cost`
	`Event_processing_time`
`Tags`	`Tag_ID`
	`Case_ID`*
	`Tag`
	`Tag_type`
`Due_dates`	`Case_ID`*
	`Due_date`
	`Due_date_type`
	`Actual_date`
	`Expected_date`
	`On_time`
	`Cost`
	`Difference`

*) Depending on the app template, Case_ID can be called differently, for example, Purchase_order_item_ID, or Incident_ID.

Viewing and editing the data model

Important:

Always make sure your data model adheres the requirements. Check out Data model requirements.

Locate the Output section in Data transformations and select Data model to view the data model of your process app.

Check out Editing data transformations for more information on how to change the data model.

Validation checking

A notification is displayed if your data model does not meet the requirements.

Refer to Data model requirements for details.

Adding a table

Select + Add table. The Add table dialog is displayed.
Select the table that defines the new output table.
Select the Primary key for the new table, and select Done.

Refer to Adding tables for more information on how to add a table in the transformations.

Adding relations

Select the table that you want to relate to another table.

The Edit table panel is displayed.
In the Edit table panel, select + Add new to create a new relation.
Select the field that you want to use in this table from the Key list.
Select the Table you want to connect to and select the field that use to connect from the Key list.
Select Apply.

Changing the key for a table

Select the table for which you want to change the key.

The Edit table panel is displayed.
In the Edit table panel, locate the relation for which you want to change the key.
Select the new field that is to be used as the Key to join the tables.
Select Apply.

Note:

If you change the primary key, the field that you select as the new primary key is duplicated in the table. You can delete the original field in Data Manager.

Primary keys can be set to null.

Deleting a relation

Select the table for which you want to delete an outgoing relation.

The Edit table panel is displayed.
In the Edit table panel, locate the relation you want to delete and select Delete relation.
Select Apply.

Deleting a table

Select the table that you want to delete in the data model editor.

The Edit table panel is displayed.
Select Delete table.

A confirmation message is displayed.
Select Delete to continue.

The table and the relations are deleted from the data model.

Making the new data model available for use in dashboards

Select Save to save the data model.
Select Apply to dashboards to run the transformations and make new the table available for use in dashboards.

Note:
This may take several minutes. If the run finishes successfully, the changes to the data model will show up in the Data Manager.

Note:

The Save option is only enabled, after you made any changes to the data model.

Preview panel

You can select a table to see the fields and the data contents in the Preview panel. The data preview enables you to check if the data looks as expected.

Note:

The Preview panel shows the data of the last data run in which this table was recalculated. If you have made recent changes, then start a new data run to view its results, refer to Editing data transformations.