process-mining
latest
false
Process Mining
Automation CloudAutomation Cloud Public SectorAutomation SuiteStandalone
Last updated Oct 15, 2024

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.
  • Required output tables

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.