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

Defining Physical to Logical Table Mappings

Use the Column Mapping tab of the Logical Table Source dialog box to map logical columns to physical columns. The physical to logical mapping can also be used to specify transformations that occur between the Physical layer and the Business Model and Mapping layer. The transformations can be simple, such as changing an integer datatype to a character, or more complex, such as applying a formula to find a percentage of sales per unit of population.

To map logical columns to physical columns

  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 Column Mapping tab.
  3. In the Column Mapping tab, maximize or enlarge the dialog box to show all the contents, as shown in Figure 12.
  4. In the Physical Table list, select the table that contains the column you want to map.

    When you select a cell in the Physical Table column, a drop-down list appears. It contains a list of tables currently included in this logical table source.

  5. In the Expression list, select the physical column corresponding to each logical column.

    When you select a cell in the Expression column, a drop-down list appears. It contains a list of tables currently included in this logical table source.

  6. To open the Expression Builder, click the ellipsis button to the left of the Expression you want to view or edit.

    NOTE:  All columns used in creating physical expressions must be in tables included in the logical table source. You cannot create expressions involving columns in tables outside the source.

  7. To remove a column mapping, click the delete button next to the Physical Table cell.
  8. After you map the appropriate columns, click OK.
Figure 12.  Logical Table Source Dialog Box
Click for full size image

To remove a column mapping

  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 Column Mapping tab.
  3. In the Column Mapping tab, maximize or enlarge the dialog box to show all the contents, as shown in Figure 12.
  4. To remove a column mapping, click the delete button next to the Physical Table cell.
  5. Click OK.

Unmapping a Logical Column From Its Source

In the Logical Column dialog box, the Datatype tab contains information about the logical column. You can edit the logical table sources from which the column derives its data, or unmap it from its sources.

To unmap a logical column from its source

  1. In the Business Model and Mapping layer, double-click a logical column.
  2. In the Logical Column dialog box, click the Data Type tab.
  3. In the Data Type tab, in the Logical Table Source list, select a source and click Unmap.
  4. Click OK.

 Siebel Analytics Server Administration Guide
 Published: 11 March 2004