Rules Tab (Mining Model Viewer)
Applies To: SQL Server 2016
Use the Rules pane in an association model to view the rules that the algorithm extracted from the data. Rules describe how items are related to each other, and can be used to create recommendations.
You can use the options in the viewer to filter the number of rules that are displayed in the viewer.
For More Information: Microsoft Association Algorithm, Browse a Model Using the Microsoft Association Rules Viewer
Refresh viewer content
Reload the mining model in the viewer.
Choose a mining model to view that is contained in the current mining structure. The mining model will open in its associated viewer.
Choose a viewer to use to view the selected mining model. You can use the custom viewer for each mining model, or the Microsoft Generic Content Tree Viewer. You can also use plug-in viewers if available.
Change this value to set the minimum probability required for a rule to be displayed in the viewer. Increasing the value for probability will reduce the number of rules that are displayed.
Change this value to set the minimum importance required for a rule to be displayed in the viewer. Increasing the value for importance will reduce the number of rules that are displayed.
Type a string value to filter the number of rules that appear in the viewer.
You can also type .NET regular expressions as filter criteria. For example, the following expression returns all rules that contain 'Road Bottle Cage' on the left side of the rule:
Note that you might need to refresh the view to see the filter criteria apply. You can also toggle the Show long name option on and off to refresh the list.
By default the filter criteria applies to the full name of the attribute-value combination; therefore, if you are viewing the attribute name only, it might not be obvious that the filter criteria has applied correctly. Use the Show dropdown list to select Show attribute name and value, and verify that the list of itemsets is filtered correctly.
Adjust the way that the rule is displayed in the viewer. You can select one of the three following options:
Show the attribute name and value
Show the attribute value only
Show the attribute name only
Show long name
Show the full name of the rule as it appears in the mining model content.
Limit the number of rules that are displayed in the viewer.
This column in the chart displays the probability for each rule.
You can click the column heading to sort by probability.
This column in the chart displays the importance for each rule.
You can click the column heading to sort by importance.
This column in the chart displays the text description for each rule, according to the format specified by using the options, Show and Show long name.
You can click the column heading to sort by the text of the rule.