Bookshelf v7.5: Defining Physical Joins in the Physical Table Diagram

Siebel Analytics Server Administration Guide > Working in a Repository's Physical Layer > About Physical Joins >

Defining Physical Joins in the Physical Table Diagram

The Physical Table Diagram shows physical tables and any defined joins between them. You can use the Physical Table Diagram to define foreign keys and complex joins between tables, whether or not the tables are in the same database.

To display the Physical Table Diagram

Right-click on a database in the Physical layer of the Administration Tool, and select one of the following options from the shortcut menu:


Physical Diagram Menu	Description
Selected object(s) only	Displays the selected objects only. Joins are displayed only if they exist between the objects selected.
Object(s) and direct joins	Displays the selected objects, as well as any tables that join to the selected objects.
Object(s) and all joins	Displays the selected objects, as well as each object that is related directly or indirectly to the selected object through some join path. If all of the objects in a schema are related, then using this option will diagram every table, even if only one table is selected.

You can add other tables to the diagram by selecting other physical tables, schemas, or databases, and executing the Physical Table Diagram command from the right-click menu.

To define a foreign key join or complex join

In the Physical layer of the Administration Tool, select one or more tables and execute one of the Physical Diagram commands from the right-click menu.

The Physical Table Diagram window appears.

To add another table to the diagram window, select the table you want to add (with the diagram window still open) and execute one of the Physical Diagram commands from the right-click menu.

Repeat this process until all the tables you are interested in appear in the diagram window.

Click one of the following buttons on the Administration Tool tool bar:

New foreign key

New complex join

With this button selected, move the cursor to the first table in the join (the one of the one-to-many join).

Left-click and move the cursor to the table to which you want to make the join (the many of the one-to-many join), and then left-click on the second table.

The Physical Foreign Key or Physical Join dialog box appears.

Select the joining columns from the left and the right tables.

The SQL join conditions appear in the expression pane of the window.

NOTE: The driving table feature is shown on this window, but it is not available for selection because the Siebel Analytics Server implements driving tables only in the Business Model and Mapping layer. For more information about driving tables, see Specifying a Driving Table.

If appropriate, specify a database hint.

For information about database hints, see Using Database Hints.

To open the Expression Builder, click the button to the right of the Expression pane.

The expression displays in the Expression pane.

Click OK to apply the selections.

The join link appears in the diagram window with the crow's feet pointing to the many part of the one-to-many join.