Enterprise Studio enables an easy way of editing, presenting and reporting data using tables. Various tables are available that can be used for different purposes. The following sections discuss general operations that can be performed on (most of) the tables.
On this page:
Available types of tables
The following tables are available in Enterprise Studio. Click a table below for more information.
- The Property table for showing and editing properties of multiple objects simultaneously.
- The Actor table for easily assigning (inter)actions to actors. Only available for Amber models.
- The Link table for viewing and correcting references and links present in a model.
- The Translation table for adding multiple languages to a model and translating all parts of the model that are language-dependent.
- The CRUD matrix for viewing and editing item relations in the context of being created (C), read (R), updated (U) or deleted (D). Only available for Amber models.
- The Profiles cross-reference table for viewing and editing cross-references between different types of objects based on profile definitions.
- The Relations cross-reference table for viewing and editing cross-references between different types of objects based on the (graphical) relations that are created when drawing relations in a view.
- The Cross-model Relations cross-reference table for viewing and editing cross-references between different types of objects based on cross-model relations that are created when drawing relations in a view.
Defining the selection of a table
To keep the size of the Link table and CRUD matrix (only available to Amber models) limited and manageable, the range of the rows and columns of a table can be restricted to the active diagram or the current selection. If you select active diagram, all parts of the active diagram or view are shown in the table. This is also the default scope.
If you set the scope to current selection, the table or matrix shows the links that are present in the currently selected element. For example, if the focus is on a single object in the active view, the table shows the data belonging to that object. If there is no information available, the table remains empty.
When you change the scope and close the table, Enterprise Studio remembers the scope you last used. This scope will be used the next time you open the table.
(Parts of) hierarchical models can be collapsed or expanded by clicking the + or – sign in a table row or column.
Table sorting
Tables are sorted on number by default (the first column of the table). By clicking the name of a column (for instance the name column) the table is resorted on that property.
Displayed table information
In the Property table, Actor table (only Amber models), and cross-reference tables it is possible to customize the information displayed in the table by using the table's context menu. The menu contains a number of different options for this. Which options are available depends on the type of table and the location in the table's grid where you right-click to open the context menu. The possible options are shown below:
Option | Function |
---|---|
Show no containers | Containers are all model components containing components and that way form a container like models and folders. This option hides all models, folders, layers, and element containers. The table shows only the flat list of objects. |
Show only model containers | Only shows the models and objects. Layers and folders are hidden. |
Show model and layer containers | Shows the models, layers and objects. |
Show model browser | Shows the complete structure of data. |
Expand | Initially, the models and model components are collapsed presented in the table. Use this option to expand the entire structure of data. All data will be shown. |
Expand to non-empty rows and columns | Initially, the model components are collapsed presented in the table. With this option, the existing components are expanded in such a way that all rows and columns that are (partially) filled, are displayed. Any possible following empty rows and columns will not be expanded. If all rows and columns in the table are empty, then the table is completely collapsed. |
Hide empty rows and columns | Leaves out the empty rows and columns from the table. |
Show all hidden rows and columns | Shows all columns and rows you have previously hidden, in the table again. |
Show all hidden columns | Shows all columns you have previously hidden, in the table again. |
Hide all columns except this one | Only leaves the columns visible in which you have clicked, the remaining columns are not displayed. |
Show all hidden rows | Shows all rows you have previously hidden, in the table again. |
Hide all rows except this one | Only leaves the rows visible in which you have clicked, the remaining rows are not displayed. |
Show flat grid (non-empty rows and columns) | Only shows the lowest level model components in the table. The hierarchical position of the components in the model is no longer visible. |
Show hierarchical grid | This option is only available if you previously have activated the option Show flat grid (non-empty rows and columns). With this option, the full model hierarchy is again shown in the table. |
Printing and copying table data
A table can be printed by clicking Print in the table.
By first making a selection in the table, and then clicking Copy or Copy+ the table selection can be copied to the Windows clipboard, respectively without and with the table's header and fixed row lines.
By using the general Windows paste function (Ctrl+V), the table can be pasted to any Office application, like Word, Excel or PowerPoint. To print or copy only a part of the table, first select a part of the table.
Reporting table data
The Property table and the cross-reference tables can also be reported directly to Word by generating an RTF report. You can select the tables you want to include when reporting the model. It can be done on the Tables tab of the reporting window.