To predict the types of products that customers tend to purchase at the same time, you will create two mining models using the Microsoft Association Algorithm using two different values for the MINIMUM_PROBABILTY parameter.

MINIMUM_PROBABILTY is a Microsoft Association algorithm parameter that is important in determining the number of rules that a mining model will contain by specifying the minimum probability that a rule must have. For example, setting this value to 0.4 specifies that no rule with less than forty percent probability of occurring is generated.

You will explore how the effect of changing the MINIMUM_PROBABILTY parameter in a later lesson.

In order to add a mining model that contains a nested table to the mining structure, you use the ALTER MINING STRUCTURE (DMX) statement. The code in the statement can be broken into the following parts:

Identifying the mining structure

Naming the mining model

Defining the key column

Defining the input and predictable columns

Defining the nested table columns

Identifying the algorithm and parameter changes

The following is a generic example of the CREATE MINING MODEL statement:

The next step is to add a new mining model to the Market Basket mining structure based on the Microsoft Association algorithm, and change the default value for MINIMUM_PROBABILTY to 0.01. Changing the parameter will cause the Microsoft Association algorithm to create more rules.

To add an Association mining model

In Object Explorer, right-click the instance of Analysis Services, point to New Query, and then click DMX.

Query Editor opens and contains a new, blank query.

Copy the generic example of the ALTER MINING STRUCTURE statement into the blank query.