Model the Associated Dimension Tables in Separate Dimensions

Instead of modeling the two dimension tables associated with a bridge table in a single dimension, you can choose to model them in separate dimensions.

Before you perform this task, you need to create the required physical joins. See Create Joins in the Physical Layer for Bridge and Associated Dimension Tables.

To model the associated dimension tables in separate dimensions, create a logical join between the fact table and the dimension table that isn't physically joined to the fact table, and then modify the dimension table's logical table source to add the other table mappings. Don't add the bridge table to the logical layer, but add all dimension tables associated with the bridge table. For the example described in About Bridge Tables, you add the Jobs table (dimension table joined to the fact table) and Employee table (dimension table not joined to the fact table), but you won't add the Assignment table (bridge table).

You can create dimensions based on your logical tables, including both logical tables associated with the bridge table.

  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 Logical Layer Logical layer icon.
  4. In the Logical Layer pane, click Create Create icon and then Create Logical Table to create a logical dimension table. Repeat this step to create the required logical dimension tables and to create the logical fact table.
  5. In the Logical Layer pane, Crtl click the fact table and associated dimension tables.
  6. Right-click, hover over Show Logical Diagram, and click Selected Tables Only.
  7. From the fact table, click and drag to draw a join line to the dimension table not joined to the fact table.
  8. In the Logical layer pane, double-click the dimension table you joined to the fact table and in the table, click the Sources tab.
  9. Click Add Physical Table Add physical table icon and then Create Logical Table Source and in the new table source's Name field, enter the name of the bridge table that you created in the physical layer.
  10. Click Add Physical Table and then Create Logical Table Source and in the new table source's Name field, enter the name of the associated dimension table. Repeat this step to add other dimension table.
  11. Click Save.