Siebel Analytics Server Administration Guide > Creating and Administering the Business Model and Mapping Layer in a Repository > Creating and Administering Logical Table Sources (Mappings) >

Creating or Removing a Logical Table Source

Use the General tab of the Logical Table Source dialog box to define general properties for the logical table source.

To create a logical table source

  1. In the Business Model and Mapping layer, right-click a logical table and choose New Object > Logical Table Source.
  2. In the Logical Table Source dialog box, click the General tab, type a name for the logical table source.
  3. Click Add.
  4. In the Browse dialog box, you can view joins and select tables for the logical table source.

    When there are two or more tables in a logical table source, all of the participating tables must have joins defined between them.

  5. To view the joins, in the Browse dialog box, select a table and click View.
    • In the Physical Table dialog box, review the joins, and then click Cancel.
  6. To add tables to the table source, select the tables in the Name list and click Select.

To remove a table as a source

  1. In the Business Model and Mapping layer, right-click a logical table and choose New Object > Logical Table Source.
  2. In the Logical Table Source dialog box, click the General tab.
  3. In the tables list, select the table you want to remove and click Remove.
  4. After removing the appropriate tables, click OK.

 Siebel Analytics Server Administration Guide
 Published: 11 March 2004