Creating Logical Table Sources

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

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.

You also add new logical table sources when multiple physical tables can be the source of information. For example, many tables could hold information for revenue. You might have three different business units (each with its own order system) where you get revenue information. In another example, you might periodically summarize revenue from an orders system or a financial system and use this table for high-level reporting.

Use the General tab of the Logical Table Source dialog to define general properties for the logical table source.

To create a logical table source:

1. In the Business Model and Mapping layer of the Administration Tool, right-click a logical table and select New Object, then select Logical Table Source.
2. In the Logical Table Source dialog, in the General tab, type a name for the logical table source.
3. Select Disabled to make this logical table source inactive, or leave it deselected to make the logical table source active.
4. Select Allow Unmapped Tables to enable this logical table source to have physical tables that are not mapped to logical columns. This option is useful for snowflake physical tables in an A > B > C configuration, where a logical table only maps to columns in A and C, but B needs to be included in the logical table source because it is in the join path between A and C.
5. Click the Add button. In the Browse dialog, 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.
6. To view the joins, in the Browse dialog, select a table and click View. After reviewing the joins in the Physical Table dialog, click Cancel.
7. To add tables to the table source, select the desired tables in the Name list and click Select.
8. Optionally, in the Priority Group field, enter a priority group number for this logical table source. See Setting Priority Group Numbers for Logical Table Sources for more information.
9. In the Logical Table Source dialog, click the Column Mapping tab and complete the fields. See Defining Physical to Logical Table Source Mappings and Creating Calculated Items for instructions.
10. In the Logical Table dialog, click the Content tab and complete the fields. See Defining Content of Logical Table Sources for instructions.
11. Click OK.