Viewing and editing the data model

Important:

Always make sure your data model adheres the requirements. See Data model requirements.

1. Select Data model to view the data model of your process app.

See Editing and testing 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

1. Select + Add table. The Add table dialog is displayed.

2. Select the table that defines the new output table.

3. 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

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

   The Edit table panel is displayed.

2. In the Edit table panel, select + Add new to create a new relation.

3. Select the field that you want to use in this table from the Key list.

4. Select the Table you want to connect to and select the field that use to connect from the Key list.

5. Select Apply.

Changing the key for a table

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

   The Edit table panel is displayed.

2. In the Edit table panel, locate the relation for which you want to change the key.

3. Select the new field that is to be used as the Key to join the tables.

4. 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

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

   The Edit table panel is displayed.

2. In the Edit table panel, locate the relation you want to delete and select Delete relation.

3. Select Apply.

Deleting a table

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

   The Edit table panel is displayed.

2. Select Delete table.

   A confirmation message is displayed.

3. 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

1. Select Save to save the data model.

2. 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 and testing data transformations.