TechNet
Export (0) Print
Expand All

Drill Through to Case Data from a Mining Model

 

Applies To: SQL Server 2016

If a mining model has been configured to let you drill through to model cases, when you browse the model, you can retrieve detailed information about the cases that were used to create the model. Moreover, if the underlying mining structure has been configured to allow drillthrough to structure cases, and you have the appropriate permissions, you can return information from the mining structure. This can include columns that were not included in the mining model.

If the mining structure does not allow you to drill through to the underlying data, but the mining model does, you can view information from the model cases, but not from the mining structure.

System_CAPS_ICON_note.jpg Note


You can add the ability to drillthrough on an existing mining model by setting the property AllowDrillthrough to True. However, after you enable drillthrough, the model must be reprocessed before you can see the case data. For more information, see Enable Drillthrough for a Mining Model.

Depending on the type of viewer you are using, you can select the node for drillthrough in the following ways:

Viewer namePane or tab nameSelect node
Microsoft Tree ViewerDecision Tree tabClick a tree node.

 Note Avoid using drillthrough on the All node, because it may take a very long time to return results.
Microsoft Cluster ViewerCluster DiagramClick a cluster node.
Microsoft Cluster ViewerCluster ProfilesClick anywhere in cluster column.
Microsoft Association ViewerRules tabClick a row that contains a set of rules.
Microsoft Association ViewerItemsets tabClick a row that contains an itemset.
Microsoft Sequence Clustering ViewerRules tabClick a row that contains a set of rules.
Microsoft Sequence Clustering ViewerItemsets tabClick a row that contains an itemset.
System_CAPS_ICON_note.jpg Note


Some models cannot use drillthrough. The ability to use drillthrough depends on the algorithm that was used to create the model. For a list of the mining model types that support drillthrough, see Drillthrough Queries (Data Mining).

To view drillthrough data from a mining model

  1. In SQL Server Data Tools (SSDT), open the mining structure that contains the mining model you want.

  2. In Data Mining Designer, click the Mining Model Viewer tab.

  3. Select the model from the Mining Model drop-down list.

  4. Select a viewer from the Viewer drop-down list, and right-click the specific node.

  5. Select Drill Through, and then select either Models Columns Only, or Model and Structure Columns to open the Drill Through window.

  6. To copy the data to the Clipboard, right-click any row in the table, and select Copy All.

Drillthrough Queries (Data Mining)

Community Additions

ADD
Show:
© 2016 Microsoft