How to: Add a Nested Table to the Input Tables of a Prediction Query
In Microsoft SQL Server Analysis Services, the data that is used for a prediction query is sometimes contained within a case table and a nested table. This procedure describes how to specify a case table and nested table when you create prediction queries on a model that requires a nested table for input.
For more information about creating prediction queries, see Mining Model Prediction Tab: How-to Topics.
To add a nested table to the input tables of a prediction query
On the Mining Model Prediction tab in Data Mining Designer, click Select Case Table to open the Select Table dialog box.
Note
You cannot add a nested table until you have specified a case table. Also, you cannot use a nested table unless the mining model that you are using to make predictions was also built using a case table and nested table.
In the Select Table dialog box, select a data source from the Data Source list, and select the table in the data source view that contains the case data. Click OK.
Click Select Nested Table to open the Select Table dialog box.
In the Select Table dialog box, select a data source from the Data Source list, and select the table in the data source view that contains the nested data. Click OK.
If a relationship already exists, the columns in the mining model are automatically mapped to the columns that have the same name in the input table. You can modify the relationship between the nested table and the case table by clicking Modify Join, which opens the Create Relationship dialog box.