Microsoft KB Archive/941859

= The default value of the MINIMUM_SUPPORT parameter does not limit the cases for the Microsoft Association algorithm in SQL Server 2005 Analysis Services =

Article ID: 941859

Article Last Modified on 1/2/2008

-

APPLIES TO


 * Microsoft SQL Server 2005 Analysis Services

-



SYMPTOMS
Consider the following scenario in Business Intelligence Development Studio. You use Microsoft SQL Server 2005 Analysis Services to create a mining model. When you do this, you use the Microsoft Association algorithm. Then, you accept the default value of the MINIMUM_SUPPORT parameter to create an association mining model. In this scenario, when you view the itemsets in the Mining Model Viewer view, itemsets that are contained in every case are displayed on the Itemsets tab. However, you expect only the itemsets that have at least 3 percent of the cases to be displayed.

Note The default value of the MINIMUM_SUPPORT parameter is 0.03.

This problem does not occur when you explicitly specify the value of 0.03 for the MINIMUM_SUPPORT parameter.



CAUSE
This problem occurs because the default value of the MINIMUM_SUPPORT parameter and the explicit value of the MINIMUM_SUPPORT parameter are processed differently in the Microsoft Association algorithm.



WORKAROUND
To work around this problem, explicitly specify the value of 0.03 for the MINIMUM_SUPPORT parameter.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

