You are currently offline, waiting for your internet to reconnect

The default value of the MINIMUM_SUPPORT parameter does not limit the cases for the Microsoft Association algorithm in 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 "Applies to" section.
REFERENCES
For more information about the Microsoft Association Algorithm, visit the following Microsoft Developer Network (MSDN) Web site:
association algorithm mining model MINIMUM_SUPPORT parameter
Properties

Article ID: 941859 - Last Review: 01/02/2008 17:22:59 - Revision: 1.1

Microsoft SQL Server 2005 Analysis Services

  • kbsql2005bi kbsql2005as kbprb kbexpertiseadvanced kbtshoot KB941859
Feedback
='ms.dqp0';m.content='true';document.getElementsByTagName('head')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?"> ml>