Page 20 - Unanet AE: Creating Analytic Models Using Query Builder

To edit this relation, select it and use its context menu.

The following commands are available.

• Edit Relation - Allows you to edit the selected relation. Clicking this menu item
opens the Join Editor dialog.

First, check the join type. You can specify it in the Join type combo box (Inner join or
Left outer join). To edit column and table names in the existing condition, click the name
you wish to replace and choose a different name from the popup menu.

Note: The Join Editor dialog will be triggered automatically if you join tables that do not
have a relationship at the database level.

Delete Relation - Removes the selected relation. Note that this action removes the
joined table(s).
• Reverse Relation – Reverses the relationship between the tables.

Edit Column Settings

After you have added the tables and selected the required columns, you can change
settings for each column in the Grid pane.

LESSON 3: Building Queries In the Analytic Dashboard ©2024 Unanet. All rights reserved. 20
Designer