Create and Edit Joins (Dimension Wizard)
This step appears only if you selected Snowflake Schema: Multiple, related dimension tables in the second step of the wizard, indicating that you would use more than one table for your dimension.
In this step of the wizard, you can create, edit, and remove joins between your dimension tables. The wizard displays the tables you have selected for your dimension. If two or more tables share a column, the wizard shows that it has automatically created a join by showing a line connecting the matching columns.
Note The Dimension Wizard is designed for use with simple schemas. If you are designing a complex snowflake schema, it is recommended that you use Dimension Editor.
If you need to edit joins but do not have a mouse or pointing device, cancel the Dimension Wizard and create the dimension using Dimension Editor, which provides the Join command on the Insert menu and the Remove Join command on the Edit menu.