Assume this scenario as an example: the AdventureWorks company wants to identify a set of products that are usually purchased together. The company can use this information to put these products beside each other or add similar items next to each other in a store to achieve higher sales. This is known as market-basket analysis because it relates to the analysis of products in a single basket in each purchase. In this example, we will use the AdventureWorksDW2012
database.
Open the AdventureWorksDW2012 data source view from the previous example.
Right-click on an empty area in the data source view and select Add/Remove Tables.
In the Add/Remove Tables window, add vAssocSeqOrders and vAssocSeqLineItems to the DSV.
After adding these views, create a relationship between the two views in this manner: drag-and-drop the Order Number column from vAssocSeqLineItems to vAssocSeqOrders as shown in the following screenshot: