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.
- On the Home page, click Navigator and then click Semantic Models.
- In the Semantic Models page, click a semantic model to open it.
- Click Logical Layer
.
- 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.
- Hover over Show Physical Diagram and click Selected Tables Only or Selected Tables and Direct Joins.
- 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.
- Right-click a table and select Show Direct Joins to display the tables that join to the table.
- Double-click a join to access the Edit Physical Join dialog box to view or modify the join's properties.
- 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.