What are Logical Table Sources?

Logical table sources define the mappings from a single logical table to one or more physical tables.

Use the physical to logical mapping to specify transformations that occur between the physical layer and the logical layer and to enable aggregate navigation and fragmentation.

In the logical layer, you can open a fact or dimension table and use the Sources tab to open a list of its table sources. From that list, you can select a specific table to view its properties such as table mapping, joins, and column mapping.

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 such as if a query asks for the appropriate level of aggregation on that column.