How to: Add a Nested Table to the Input Tables of a Prediction Query
In Microsoft SQL Server 2005 Analysis Services (SSAS), the data that is used for a prediction query is sometimes contained within a case table and a nested table. You can add a nested table to the Select Input Table(s) table of the Mining Model Prediction tab in Data Mining Designer by using the Select Table dialog box. For more information about how to add a case table to Select Input Table(s), see How to: Select Input Tables for a Prediction Query.
To add a nested table to the input tables of a prediction query
On the Select Input Table(s) table of the Mining Model Prediction tab in Data Mining Designer in Business Intelligence Development Studio, click Select Nested Table.
The Select Table dialog box opens.
In the Select Table dialog box, select a data source from the Data Source list.
In the Table/View Name box, select the table that contains the data that you want to predict against.
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. If a relationship does not already exist between the nested table and the case table, the Specify Nested Join dialog box opens. For more information about how to use the Create Relationship dialog box, see How to: Modify a Join in a Prediction Query.
See Also
Other Resources
Mining Model Prediction Tab How-to Topics