How to: Modify Column Mappings in a Prediction Query

You can use the Modify Connections dialog box in Microsoft SQL Server 2005 Analysis Services (SSAS) to modify existing column mappings in the Mining Model Prediction tab of Data Mining Designer.

To modify a column mapping relationship

1. In Data Mining Designer in Business Intelligence Development Studio, select the Mining Model Prediction tab.

2. On the Mining Model menu, select Modify Connections.

   The Modify Mapping dialog box opens. In this dialog box, Mining Model Column lists each column that the selected mining structure contains; Table Column lists the columns from SelectInput Table(s) that are mapped to columns in the mining model.

3. Under Table Column, select the row that corresponds to the row under Mining Model Column for which you want to modify a relationship.

4. Select a new column from the list, or select the blank item in the list to delete the column mapping.

5. Click OK.

   The new column mappings are displayed in the designer. You can remove a connection by selecting the connection and clicking DELETE. You can create a new connection by selecting a column in the Mining Model table and dragging it to the corresponding column in the SelectInput Table(s) table.

See Also

Other Resources

Mining Model Prediction Tab How-to Topics

Help and Information

Getting SQL Server 2005 Assistance