How to: Map Input Columns to Model Columns

Before you can create an accuracy chart that uses an external data source, you must map the columns in the data mining model to the columns in the testing data. If the column names match exactly, or if you are using the holdout test data that is stored with the mining structure, the designer will automatically create the relationships. If the column names do not match exactly, you can manually adjust the relationships.

If you select the option to use the mining structure test data or mining model cases, you do not need to map columns. Analysis Services will automatically provide the test data for the chart.

To map input columns to the columns in the testing data

  1. Double-click the mining structure that contains the models you want to chart, to open the structure and models in Data Mining Designer.

  2. Select the Mining Accuracy Chart tab, and then select the Input Selection tab.

  3. In the Input Selection tab, under Select data set to be used for Accuracy Chart, select Specify a different data set.

  4. Click the browse button (…) to open a dialog box and build the definition of the external data set.

  5. In the Select Mining Structure dialog box, select the mining structure that contains the models you want to work with, and then click OK.

  6. On the Select Input Table(s) table of the Mining Accuracy Chart tab, click Select Case Table to open the Select Table dialog box.

  7. In the Select Table dialog box, select a data source from the Data Source list. Choose a table that contains the data that you want to use in the prediction queries to determine the accuracy of the models.

  8. In the Table/View Name box, select the table that contains the data that you want to use to test the models.

  9. Edit the mappings, if necessary. Columns in the mining structure are automatically mapped to the columns with the same name in the input table. To manually create mappings, click a column in the Select Input Table(s) table and drag it onto the corresponding column in the Mining Structure table. To delete a mapping, click the line that links the column in the Mining Structure table to the mapped column in the Select Input Table(s) table, and then press DELETE.

  10. Click OK.

See Also

Other Resources