Bookshelf Home | Contents | Index | Search | PDF

Siebel Analytics Server Administration Guide > Creating and Administering the Business Model and Mapping Layer in a Repository > Creating and Administering Logical Tables >

Creating Logical Tables

---

Typically, you create logical tables by dragging and dropping a physical table from the Physical layer to a business model in the Business Model and Mapping layer. If a table does not exist in your physical schema, you would need to create the logical table manually.

Drag and drop operations are usually the fastest method for creating objects in the Business Model and Mapping layer. If you drag and drop physical tables from the Physical layer to the Business Model and Mapping layer, the columns belonging to the table are also copied. After you drag and drop objects into the Business Model and Mapping layer, you can modify them in any way necessary without affecting the Physical layer.

When you drag physical tables (with key and foreign key relationships defined) to a business model, logical keys and joins are created that mirror the keys and joins in the physical layer. This occurs only if the tables that you drag include the table with the foreign keys. Additionally, if you create new tables or subsequently drag additional tables from the Physical layer to the Business Model and Mapping layer, the logical links between the new or newly dragged tables and the previously dragged tables must be created manually.

For more information about joins, see Defining Logical Joins with the Joins Manager and Defining Logical Joins with the Business Model Diagram.

To create a logical table by dragging and dropping

1. Select one or more table objects in the Physical layer.

   You must include the table with the foreign keys if you want to preserve the keys and joins from the physical layer.

2. Drag and drop the table objects to a business model in the Business Model and Mapping layer.

   When you drop them, the table objects, including the physical source mappings, are created automatically in the Business Model and Mapping layer.

To create a logical table manually

1. In the Business Model and Mapping layer, right-click the business model in which you want to create the table and select New Object > Logical Table.

   The Logical Table dialog box appears.

2. In the General tab, type a name for the logical table.
3. If this is a bridge table, select the option Bridge table.

   For information about bridge tables, see Bridge Tables to Model Many-to-Many Relationships.

4. (Optional) Type a description of the table.
5. Click OK.

NOTE:  After creating a logical table manually, you must create all keys and joins manually.

Bookshelf Home | Contents | Index | Search | PDF