Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Remove Columns from a Mining Structure

You can use Data Mining Designer to remove columns from a mining structure after the structure has already been created. Reasons to remove a mining structure column might include the following:

  • The mining structure contains multiple copies of a column and you want to avoid the use of duplicate data in a model.

  • The data should be protected, but drillthrough has been enabled.

  • The data is unused in modeling and should not be processed.

Deleting a column from the mining structure does not change the column in the data source view or in the external data; only metadata is deleted. However, when you change the columns used in a mining structure, you must reprocess the structure and any models based on it.

To remove a column from the mining structure

  1. Select the Mining Structure tab in Data Mining Designer.

  2. Expand the tree for the mining structure, to show all the columns.

  3. Right-click the column that you want to delete, and then select Delete.

  4. In the Delete Objects dialog box, click OK.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2014 Microsoft. All rights reserved.