Adding or Editing Joins Manually

  To add or edit a join:

1. If not already opened, open the minischema (see Opening a Minischema).

2. Perform one of the following tasks:

   • To add a join, select the table in the minischema to which you want to add a join, right-click, and select Add Joins.

     The table you selected is displayed in the left Table drop-down list of the Edit Properties of Minischema Join dialog box.

     Note:

     Because you can only create self joins in minischemas created from Oracle BI EE and text file data sources, the selected table displays in both the left and right Table text box, and neither is editable.

     Alternatively, you can right-click in the background of the minischema and select Add Joins, but, in this case, no table names are displayed in either Table drop-down lists. You select the tables you want to join.

     Note:

     For self joins in minischemas created from Oracle BI EE or text file data sources, only the left Table drop-down list box is active. Once you select a table in the left Table drop-down list box, the right Table text box displays that table name.

   • To edit a join, double-click a join line in the minischema to display the Edit Properties of Minischema Join dialog box.

     Note:

     For self joins, the left and right Table text box is not selectable.

3. In the right Table drop-down list, select the table to which you want to establish a join.

   Note:

   For minischemas built from Oracle BI EE or text file data sources, you can only perform self-joins; therefore, the Table drop-down list box is not selectable.

4. If you are adding a join, click the + button.

   Note:

   If you are editing a join, or adding the first join, skip this step and proceed to step 5.a.

   Alternatively, you can delete joins from the list by selecting the join pair from the Column grid and clicking the red X button.

5. To work with joins; for example, joins from relational data sources:

   1. In the Column grid, point the mouse into the left cell of the first empty row in the grid and click to display a list of the column names associated with that table.

      Alternatively, if you are editing an existing join, click in the left cell of the join pair that you want to edit to display the list of column names.

   2. Select a column to begin the join.

   3. In the Column grid, point the mouse into the right cell of the same row of the grid and click to display a list of the column names associated with that table.

      Alternatively, if you are editing an existing join, click in the right cell of the join pair that you want to edit to display the list of column names.

   4. Select a column to complete the join.

   5. Optional: If this is an outer join, select the Outer check box, and then choose an option:

      • Left

      • Full

      • Right

   6. Optional: Repeat step 2 through step 5.e for each join combination that you want to create.

   7. Optional: Repeat step 4 through step 5.e for each join you want to add for the currently selected pair of tables.

6. To work with self joins; for example, self joins from relational, Oracle BI EE, or text file data sources:

   1. In the left Column drop-down list, select the column name to being the join.

   2. In the right Column grid, select the column name to complete the join.

   3. Optional—If this is an outer join, select the Outer check box and then choose one of the following options:

      • Left

      • Full

      • Right

   4. Optional: Repeat step 2 through step 6.c for each new self join pair you want to create.

   5. Optional: Repeat step 5.a through step 6.c for each self join you want to add for the currently selected table.

7. To save your join additions and edits, right-click in the minischema work area and select Save Minischema.