Siebel Business 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, and then type a name for the logical table source and click Add.
3. 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.

4. 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.
5. To add tables to the table source, select the tables in the Name list and click Select.
6. In the Logical Table Source dialog box, click the Column Mapping tab and complete the fields using the instructions in Defining Physical to Logical Table Source Mappings.
7. In the Logical Table dialog box, click the Content tab and complete the fields using the instructions in Defining Content of Logical Table Sources.
8. Click OK.

To remove a table as a source

1. In the Business Model and Mapping layer, right-click a logical table source and choose Properties.
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.

Example of Creating Sources for Each Level of Aggregated Fact Data

In addition to creating the source for the aggregate fact table, you should create corresponding logical dimension table sources at the same levels of aggregation.

NOTE:  If the sources at each level already exist, you do not need to create new ones. You need to have at least one source at each level referenced in the aggregate content specification.

For example, you might have a monthly sales table containing a precomputed sum of the revenue for each product in each store during each month. You need to have the following three other sources, one for each of the logical dimension tables referenced in the example:

• A source for the Product logical table with one of the following content specifications:
  • By logical level: ProductDimension.ProductLevel
  • By column: Product.Product_Name
• A source for the Store logical table with one of the following content specifications:
  • By logical level: StoreDimension.StoreLevel
  • By column: Store.Store_Name
• A source for the Time logical table with one of the following content specifications:
  • By logical level: TimeDimension.MonthLevel
  • By column: Time.Month