Overview of the Domain Designer

The Domain Designer is a tool for defining the components of a Domain. Tabs let you choose schemas and tables in your data source, join tables, pre-filter data, and choose the data to present to report creators and users. You can also create calculated fields and derived tables, and upload text files to translate static text or apply security to the Domain.

Figure 2: User Interface of the Domain Designer

The following image shows the UI of the Domains Designer when you select a Trino-based data source.

Figure 3: User Interface of the Domain Designer for a Trino-based data source

Domain Designer Tabs

Use the tabs at the top of the Domain Designer to view and edit various aspects of the design. To navigate among tabs, click a tab name at the top of the Domain Designer:

Data Management tab – Select schemas and tables you want to use in the Domain, including tables you refer to but might not want to expose. See The Data Management Tab for more information.
Joins tab – Define joins between any included tables and/or derived tables. See The Joins Tab for more information.
Pre-filters tab – Set conditions on field values to limit the data accessed through the Domain. See The Pre-filters Tab for more information.
Data Presentation tab – Create sets that specify tables, columns, and items to expose to users. Optionally define or change display properties, such as names and descriptions. See The Data Presentation Tab for more information.
Security tab – Create or upload files in the security file. See The Security Tab for more information.
Locales tab – Upload locale bundles for translating elements of the Domain. See The Locales Tab for more information.

All tabs except the Security and Locales have at least two panels, from left to right:

Data Structure panel, which displays the schemas, tables, columns, and joins available on the current tab. Use the search bar at the top of the Data Structure tab to locate a Domain element. Not all elements are available on all tabs.
A design panel on the right, with a working area specific to the current task. In some cases, the design panel is divided into sub-panels.

Domain Designer Tool Bar

Use the icons on the tool bar to create derived tables and calculated fields, change the data source, save the Domain, and import and export Domain design files.

Domain Designer Tool Bar Icons

Icon

Name

Description

More

Click to choose one of the following:

Create a global constant field
Create a derived table
Choose a different data source or reload data from your existing data source
Clear all data in the Domain
Save Place the cursor over this icon to display a menu of options for saving the Domain.
Export Click this icon to export a Domain design file.
Import Click this icon to import a Domain design file.
Undo Click this icon to undo the most recent action.
Redo Click this icon to redo the most recently undone action.
Undo All Click this icon to revert the Domain to its state when you last saved.
Close Domain Click this icon to close the Domain and return to the previous screen.

Before you can save the design, you must add at least one table to the Domain. The button on the tool bar validates the design and saves it in the location you specify. For more information, see Domain Validation. After saving a Domain, you can continue modifying it using the Domain Designer.

The Data Structure Panel

The Data Structure panel contains a hierarchical view of the available schemas, tables, columns, and joins. The available elements and the layout depend on the current tab. A search bar lets you search for items in the panel by name.

Figure 4: Examples of Data Structure panel on Data Management and Joins tabs

The following image shows the UI of the Domains Designer when you select a Trino-based data source to create the domain.

            

Figure 5: Examples of Data Structure panel on Data Management and Joins tabs for a Trino-based data source

The following icons to indicate element type can appear on the Data Structure panel or elsewhere in the Domain Designer:

Icon Description
The data source for the Domain. There is only one data source for a Domain.
A database schema that has been added to the Domain.
A database schema that has been added using an attribute for the schema name.
A table that has been added to the Domain.
A column (field) in the Domain.
Constant Fields. Only appears if you have created one or more constant calculated fields.
A calculated field or constant field that has been added to the Domain. Constant fields appear under the Constant Fields node; other calculated fields appear under the join or table where they were created.
Derived Tables. Only appears if you have created one or more derived tables.
A derived table that has been added to the Domain.

A join tree. A Domain may contain many join trees, but when a user creates an Ad Hoc view from a Domain, they can only select one join tree to use in the view.

A data island. A data island contains the tables and columns from a specific join tree that you have chosen to expose to users. Data Islands are only visible on the Data Presentation tab.

A set, that is, a named collection of items grouped together for ease of use in the Ad Hoc Editor. Sets are visible only on the Data Presentation tab.
An item, that is, the representation of a database field or a calculated field along with its display name and formatting properties. Items are visible only on the Data Presentation tab. Items can be grouped in sets and are used in the creation of Ad Hoc views.
A catalog that has been added to the Domain (only for Domains that are created from a Trino data source).

The following icons represent items on the Data Presentation tab. An item is the representation of a database field or a calculated field along with its display name and formatting properties. Items can be grouped in sets and are used in the creation of Ad Hoc views.

Icon

Description

Boolean field

Boolean measure

calculated field
calculated measure
date field
date measure
numeric field
numeric measure
string field
string measure