How to: Add a Nested Table to the Input Tables for the Mining Accuracy Chart
When you test the accuracy of a set of mining models by using external data, if the mining model contains nested tables, the external data must also contain a case table and an associated nested table. This procedure describes how to add a nested table to the testing data set, and how to specify the relationship between the mining model and the nested and case tables in the external data.
If you select the option Use mining model test cases or Use mining structure test cases, you do not need to specify a case table or nested table. With those options, the definition of the test data is stored in the mining structure and the test data is automatically selected when you create the accuracy chart.
For More Information:How to: Select Input Data for an Accuracy Chart
To add a nested table to one or more input tables
Double-click the mining structure to open it in Data Mining Designer in Business Intelligence Development Studio.
Select the Mining Accuracy Chart tab, and then select the Input Selection tab.
In Select data set to be used for accuracy chart, select the option Specify a different data set.
Click the browse button (…) to choose the external data set from a list of data source views on the current server.
Click Select Case Table. In the Select Table dialog box, choose the table from the data source view that contains the case data, and then click OK.
You cannot select a nested table until you have specified the case table. Also, you cannot specify a nested table unless the mining model also uses a case table and nested table structure.
Click Select Nested Table. In the Select Table dialog box, select the table that contains the nested data, and then click OK.
If a relationship already exists, the columns in the mining structure 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.