You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Current »




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

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: toggle partial load for this table.
    Partial load only loads a part of the whole data model 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.

  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

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.


  • No labels