How to: Modify a Join in a Prediction Query

In Microsoft SQL Server Analysis Services, you can modify the joins between a case table and a nested table that are used as inputs to a prediction query, by using the Specify Nested Join dialog box. For more information about how to add a nested table to the Select Input Table(s) table of the Mining Model Prediction tab in Data Mining Designer, see How to: Add a Nested Table to the Input Tables for the Mining Accuracy Chart.

To remove a relationship between input tables

  1. On the Select Input Table(s) table of the Mining Model Prediction tab in Data Mining Designer in Business Intelligence Development Studio, click Modify Join.

    The Specify Nested Join dialog box opens.

  2. Select a relationship.

  3. Click Remove Relationship.

  4. Click OK.

    The relationship between the case table and the nested table has been removed.

To create a new relationship between input tables

  1. On the Select Input Table(s) table of the Mining Model Prediction tab in Data Mining Designer, click Modify Join.

    The Specify Nested Join dialog box opens.

  2. Click Add Relationship.

    The Create Relationship dialog box opens.

  3. Select the key of the nested table in Source Columns.

  4. Select the key of the case table in Destination Columns.

  5. Click OK in the Create Relationship dialog box.

  6. Click OK in the Specify Nested Join dialog box.

    A new relationship has been created between the case table and the nested table.