Data Model Designer Workspace
The Data Model Designer workspace is where you build and refine a data model in SEI. It combines visual and tabular tools that let you select tables, define joins, choose fields, and apply filters.
You can arrange tables in the Design Graph, connect them with joins, and choose the fields you want in your model. Use the Fields Table to configure field properties, visibility, and formats. The WHERE Clause lets you define filters so that analysis includes only relevant data. The toolbar provides quick access to common actions, enabling you to make changes, preview results, and save your work directly from the workspace. All components work together to define the structure of your data, enabling accurate reporting and analysis.
Access the data model designer
- Select Data Models and Views from the navigation panel.
- Right-click the data model you want to edit, and select Design Data Model.
Save your work periodically, including before leaving the page. If you leave the workspace without saving, your changes will be lost.
Main sections
The workspace consists of three main sections:
| Component | Description |
|---|---|
| Design Graph | A visual pane showing tables and joins. You can add new tables, define joins, and arrange objects to fit your workflow. |
| Fields Table | A tabular view of selected fields. Configure column headings, data types, formats, visibility levels, and descriptions. |
| WHERE Clause | A pane for defining filter conditions that limit the data returned by the model. |
There are also four main data model elements:
- Tables – Contain the raw data from the selected data source.
- Joins – Define the relationships between tables.
- Fields – Specify which columns from each table are used in the data model.
- Filters – Limit the data returned based on conditions.
Toolbar
The toolbar is located above the Design Graph. Each button provides quick access to specific actions in the Data Model Designer. Hover over a button to see its tooltip, then select the button to open the related topic in the help.
| Action | Description | |
|---|---|---|
| Save Data Model | Save your current changes to the data model. | |
| Data Model Properties | View and edit properties such as model name and associated data source. | |
| Toggle graph pane | Show or hide the Design Graph pane. | |
| Toggle fields pane | Show or hide the Fields Table pane. | |
| Toggle where pane | Show or hide the WHERE Clause pane. | |
| Add Calculated Column | Create a new column based on a calculation or expression. | |
| Add Table | Insert an additional table from the data source into the model. | |
| Fit Column Width with the Values | Automatically adjust column width to fit data values. | |
| Increase column width | Expand selected column width incrementally. | |
| Decrease column width | Reduce selected column width incrementally. | |
| Data Model Scripts | Manage scripts linked to the data model. | |
| Manage Mandatory Parameters | Set and modify parameters that users must provide when running the model. | |
| Dimensions and Measures | Define fields as dimensions or measures for reporting purposes. | |
| Data Model Preview | View sample data returned by the current data model definition. | |
| SQL Statement | Display the SQL statement generated from the model definition. |