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 translations Article translations
Article ID: 941859 - View products that this article applies to.
Expand all | Collapse all

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:
http://msdn2.microsoft.com/en-us/library/ms174916.aspx

Properties

Article ID: 941859 - Last Review: January 2, 2008 - Revision: 1.1
APPLIES TO
  • Microsoft SQL Server 2005 Analysis Services
Keywords: 
kbsql2005bi kbsql2005as kbprb kbexpertiseadvanced kbtshoot KB941859

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com