Create Joins in the Physical Layer for Bridge and Associated Dimension Tables

To model bridge tables in the physical layer, create joins between the bridge table and the associated dimension tables.

After you've completed creating joins in the physical layer, you then add the needed associated dimension tables to the logical layer and model them in either a single dimension or separate dimensions.
  1. On your home page, click Navigator Navigator icon and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Physical Layer Physical layer icon.
  4. In the Physical Layer pane, browse for and Ctrl click the fact, bridge, and associated dimension tables.
  5. Right-click, hover over Show Physical Diagram, and click Selected Tables Only.
  6. From the bridge table, click and drag to draw a join line to a dimension table.
  7. Add joins from the bridge table to the other associated dimension tables.
  8. Confirm that one of the associated dimension tables is joined to the fact table.
  9. Click Save.