Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Drill Through Dialog Box (Mining Model Viewer)


Applies To: SQL Server 2016 Preview

When you view a mining model by using the Mining Model Viewer tab of Data Mining Designer, you can drill through into details about the case data, provided the model has drillthrough enabled. Moreover, if the underlying mining structure has drillthrough enabled, you can also see columns in the mining structure, even if those columns were not included in the mining model. In the column list, the structure columns are prefixed by the "Structure." label.


You cannot enable drillthrough on an existing mining structure. Instead, you must re-create the mining structure and enable drillthrough during the creation process.

For information about how to access case data from each of the mining model viewers that support drillthrough, see Drill Through to Case Data from a Mining Model.

Cases Classified To

Displays the definition of the rule, itemset, and cluster that are contained in the selected node.

Column list

Displays the columns in the model, followed by the structure columns.

Note   Structure columns are displayed only if drillthrough is enabled on the mining structure, and if you selected the option, Model and Structure Columns. Moreover, you must have drillthrough permissions on both the mining model and the mining structure to view the columns.

Structure columns that are not included in the model appear as Structure.<column name>.


You can right-click anywhere in the column grid and select Copy All to copy the drillthrough data, in tab-delimited format, to the Clipboard. The copied data includes only the case data, not the node definition.


Click the green arrow button to refresh the data.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft