Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Server Administration Guide > Working in a Repository's Business Model and Mapping Layer > About Logical Joins >

Defining Logical Joins with the Business Model Diagram

---

The Business Model Diagram shows logical tables and any defined joins between them. You can use the Business Model Diagram to define logical foreign keys and complex joins.

To display the Business Model Diagram

In the Administration Tool, right-click a business model, and then select Business Model Diagram.
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 Logical Foreign Key or Logical Join dialog box appears.

For a logical foreign key, select the joining columns from the left and the right tables.
(Optional) To specify a driving table for the key, select a table from the Driving drop-down list, and an applicable cardinality.

This is for use in optimizing the manner in which the Siebel Analytics Server processes multi-database inner joins when one table is very small and the other table is very large. Do not select a driving table unless multi-database joins are going to occur. For more information about driving tables, see Specifying a Driving Table.

CAUTION:  Use extreme caution in deciding whether to specify a driving table. Driving tables are used for query optimization only under rare circumstances and when the driving table is extremely small, that is, less than 1000 rows. Choosing a driving table incorrectly can lead to severe performance degradation.

Select the join type from the Type drop-down list.
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 save your work.

Bookshelf Home | Contents | Index | Search | PDF