Defining Analysis Services Dimensions - SQL Server Analysis Services 2012 Cube Development - page 27

2. To create a new relationship, you must click on the Foreign Key column in the
fact table and drag it to the dimension table's Primary Key. Alternatively, you
can right-click on the blank area within the DSV and select New Relation-
ship ; this will bring up the Edit Relationship dialog (as shown in the preced-
ing screenshot).
Tip
Note the Reverse button on the Edit Relationship dialog; if you happen to
mistakenly drag the Primary Key column from a dimension to a fact table,
you can easily correct the relationship by clicking on Reverse.
3. The DSV we created in the previous section has multiple relationships from
some fact tables to DimDate . For example, the FactResellerSales table has
OrderDateKey , ShipDateKey , and DueDateKey columns, each referencing
the DateKey column in the DimDate table.