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

Defining Logical Joins with the Joins Manager

You can use the Joins Manager to view logical join relationships and to create logical foreign keys and complex joins.

This section includes the following topics:

Creating a Logical Foreign Key

Use this procedure to create a logical foreign key.

To create a logical foreign key

  1. In the Administration Tool tool bar, select Manage > Joins.

    2. The Joins Manager dialog box appears.

  2. Select Action > New > Logical Foreign Key
  3. In the Browse dialog box, double-click a table.

    4. The Logical Foreign Key dialog box appears.

  4. Enter a name for the foreign key.
  5. In the Table drop-down list on the left side of the dialog box, select the table that the foreign key references.
  6. Select the columns in the left table that the foreign key references.
  7. Select the columns in the right table that make up the foreign key columns.
  8. (Optional) To specify a driving table for the key, select a table from the Driving drop-down list, and an applicable cardinality.

    9. 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.

  9. Select the join type from the Type drop-down list.
  10. To open the Expression Builder, click the button to the right of the Expression pane.

    11. The expression displays in the Expression pane.

  11. Click OK to save your work.

Creating a Logical Complex Join

Use this procedure to create a logical complex join.

To create a logical complex join

  1. In the Administration Tool tool bar, select Manage > Joins.

    2. The Joins Manager dialog box appears.

  2. Select Action > New > Logical Complex Join.

    3. The Logical Join dialog box appears.

  3. Enter a name for the complex join.
  4. In the Table drop-down lists on the left and right side of the dialog box, select the tables that the complex join references.
  5. (Optional) To specify a driving table for the key, select a table from the Driving drop-down list, and an applicable cardinality.

    6. 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.

  6. Select the join type from the Type drop-down list.
  7. To open the Expression Builder, click the button to the right of the Expression pane.

    8. The expression displays in the Expression pane.

  8. Click OK to save your work.

 Siebel Analytics Server Administration Guide 
 Published: 23 June 2003