Open the Physical Diagram from the Physical Layer

The physical diagram provides a graphic view of the physical table or tables that you selected. From the diagram you can view a table's columns, show direct joins, and add, modify, or delete physical joins.

You can select what you want the diagram to contain:

• Selected Tables Only - Displays only the selected physical tables. Physical joins display only if they exist between the tables that you selected.

• Selected Tables and Direct Joins - Displays the selected physical tables and any physical tables that join to the table or tables that you selected.

You can open the physical diagram from the physical layer or the logical layer. Opening the physical diagram from the logical layer helps you understand the model's logical-to-physical mappings, and shows you the physical objects that are associated with a particular logical object.

For information about adding or modifying joins from the physical diagram, see Add and Define Physical Joins.

1. On the Home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Physical Layer.
4. Locate and right-click a table, or use Shift click or Ctrl click to select more than one table and right-click.
5. Hover over Show Physical Diagram and click Selected Tables Only or Selected Tables and Direct Joins.
6. In the physical diagram, double-click a table to view a list of column names with column type icons. Double-click the list to collapse it.
7. Right-click a table and select Show Direct Joins to display the tables that join to the table.
8. Click a join to access the Edit Physical Join dialog box to view or modify the join's properties.
9. Click a table to select it and on the right side of the table, grab its handle and drag to another table to create a physical join and specify its properties.
10. Click Add.
11. Click Save.