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

Creating and Administering Logical Table Sources (Mappings)


One logical table source folder exists for each logical table. The folder contains one or more logical table sources. These sources define the mappings from the logical table to the physical table. Complex mappings, including formulas, are also configured in the logical table sources.

Logical tables can have many physical table sources. A single logical column might map to many physical columns from multiple physical tables, including aggregate tables that map to the column if a query asks for the appropriate level of aggregation on that column.

When you create logical tables and columns by dragging and dropping from the Physical layer, the logical table sources are generated automatically. If you create the logical tables manually, you need to also create the sources manually.

For examples of how to set up aggregate navigation, see Setting Up Aggregate Navigation.

This section includes the following topics:

Siebel Analytics Server Administration Guide