About Logical Tables

Logical tables provide a dimensional view of your business' data.

A logical table is sourced from one or more physical tables through mappings. There are three types of logical tables: fact, dimension, and lookup. The logical schema defined in each business model must contain at least two logical tables, and you must define relationships between the logical tables.

Each logical table is associated with one or more logical columns and one or more logical table sources. You can add a new logical table source, edit or delete an existing table source, create or change mappings to the table source, or define when to use logical table sources.

In most cases when you need to create a logical table, you drag and drop tables from the physical layer to the logical layer. In some situations you need to create a logical table manually. See Create a Fact, Dimension, or Lookup Logical Table.

When you drag and drop physical tables from the physical layer to the logical layer, the columns in the table are also added to the logical table along with join relationships. Primary keys and joins are created that mirror the keys and joins in the physical layer. After adding objects to the logical layer, you can modify the objects in the logical table without affecting the objects in the physical layer.

If you create tables manually or drag tables from the physical layer to the logical layer, then you must create the logical mappings between the new or newly dragged tables and the previously dragged tables.

After you add a logical table, you can perform tasks such as change a table's name, reorder the logical table sources, and configure logical joins.