How to: Modify Column Mappings

In Microsoft SQL Server 2005 Analysis Services (SSAS), you can use the Modify Connections dialog box to modify the column mapping that Analysis Services automatically generates in the Column Mapping tab of the Mining Accuracy Chart tab of Data Mining Designer.

To modify a relationship

  1. In Data Mining Designer in Business Intelligence Development Studio, select the Mining Accuracy Chart tab.

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

    The Modify Mapping dialog box opens. In the table in this dialog box, Mining Structure Column lists each column that the selected mining structure contains, and Table Column lists the columns from input tables that are mapped to columns in the mining structure.

  3. Under Table Column, select the row that corresponds to the row under Mining Structure Column for which you want to modify a relationship. Select a new column from the list, or select the blank entry from the list to delete the column.

  4. 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 Structure table and dragging it to the corresponding column in the Input Table(s) table.

See Also

Other Resources

Mining Accuracy Chart Tab How-to Topics

Help and Information

Getting SQL Server 2005 Assistance