Skip to main content

CPM46

Tables

The Tables section offers a list of all included tables in your data model. It allows you to change general settings of each table, reload the table columns, and preview the table content.

General

34439939.png

The General tab shows you the general settings of the selected table.

  1. Navigation: switch between the 'General', 'Columns', 'Process' (only displayed if the selected table is marked as an activity table), and 'Preview' tabs.

  2. Name and description: change the name of the selected table and add an optional description to it.

  3. DB Connection: modify the database from which the data is fetched.

  4. Source Tabelle: modify the table in the database that originates the selected table.

  5. Loader pool: in this field you can assign the table to a specific loader pool.

    Loader pools allow you to control the degree of parallelism for the loading of specific tables. Each pool can do a configurable number of table loads in parallel. This way you can assign, fast and easy to load tables to a loader pool with a high number of parallel loads. In contrast, you can assign computational heavy views to a pool with a low number of parallel loads to improve database system stability.

  6. Partial Load: Include this table in partial loads.

    Partial Load only loads a part of the whole data model (only selected tables) from the source system. This can be useful if you have tables which are rarely changed and others which are frequently changed in one data model. The frequently changed tables can be frequently loaded as part of a partial load while the rarely changing tables are only loaded with the full load, which reduces the load on the source system. In the Loading tab, a load schedule can be defined for the partial loads. Partial doads can only be triggered with scheduled data model reloads.

  7. Hide table in analysis: hides the table in the analysis view (not available for the activity table).

  8. Table role: assign the role of the selected table (between 'Activity', 'Cases', and 'No Role' tables).

  9. Remove table: deletes table from the data model.

Columns

34439938.png

The Columns tab allows you to modify the properties of your table columns.

  1. Synchronize Columns: click on the button to synchronize the columns between your database and you data model. This is especially useful when incompatibilities between these columns cause errors when reloading from datasource in the Status screen.

  2. Index: change the order in which the table elements are displayed in the Case Explorer. This is of special interest if you are using a table with a large amount of entries and would like to structure your initial analysis.

  3. Technical name: modify the name of the table columns.

  4. Type: displays the data types identified in each column.

  5. Hidden: the column won't appear in any analysis that is created using this data model.

  6. Default: the column will be applied automatically to the initial view of the Case Explorer.

Process

34439937.png

The Process is only displayed when viewing the settings of the Activity Table. The tab allows you to modify the main columns of your activity table and optionally set other of its properties.

  1. Case ID column: assign the column from your activity table that contain all the case IDs (obligatory).

  2. Activity column: assign the column from your activity table that contain all the activity names (obligatory).

  3. Timestamp column: assign the column from your activity table that contain all the event times (obligatory).

  4. End timestamp column: assign the column from your activity table that contain the time in which each event ends (optional).

  5. Resource configuration: assign the column that contains information on the costs of your activities and the users who performed them. Tagging these columns are required to use the cost and user components, respectively.

  6. Respect sorting column: add the sorting column to manually assign the order in which activities will be sorted.

  7. Respect parallel processes: assign tables that contain parallel subprocesses ('Subprocess-ID') and the relations between them ('Parent-ID').

Preview

34439936.png

The Preview screen displays a preview of the Case Explorer. The displayed columns follow the order set on the 'Columns' tab (see item 2 of the Columns sections). The preview screen is useful for structuring your data model even before the deployment of your analysis.