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
- In the Business Model and Mapping layer, right-click a logical table and choose New Object > Logical Table Source.
- In the Logical Table Source dialog box, click the General tab, type a name for the logical table source.
- Click Add.
- 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.
- 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.
- To add tables to the table source, select the tables in the Name list and click Select.
To remove a table as a source
- In the Business Model and Mapping layer, right-click a logical table and choose New Object > Logical Table Source.
- In the Logical Table Source dialog box, click the General tab.
- In the tables list, select the table you want to remove and click Remove.
- After removing the appropriate tables, click OK.
|