Groups | Blog | Home
all groups > sql server data mining > january 2006 >

sql server data mining : market basket combinations


anonymous_user NO[at]SPAM sqlserverdatamining.com
1/6/2006 5:40:06 AM
Dear All,
Once run the market basket with SQL server 2005 data mining Business intelligent studio it only gives support of 1,2 and 3 combinations of items.

if there are 3 items(ink,milk,pen)
Support item set
3 pen
2 pen, ink
1 ink,milk,pen(This combination is not given)



If there are 5 it does not give customers those who buy all 5 items. If anybody knows how to get that one help me to clarify this matter.
Jamie MacLennan (MS)
1/6/2006 10:04:25 AM
Change the association rules parameter MAXIMUM_ITEMSET_SIZE to 5. The
default is 3

--

-Jamie MacLennan
SQL Server Data Mining
This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view]

anonymous_user NO[at]SPAM sqlserverdatamining.com
1/9/2006 9:40:11 AM
[quoted text, click to view]
from
Randi
[quoted text, click to view]

AddThis Social Bookmark Button