Open the Physical Diagram from 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.

You can add or modify physical 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 Logical Layer.
4. Locate and right-click the table that you want logical-to-physical mappings information about, 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. Double-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.