Processing Association Rules model on SQL 2005 Standard edition produced following error:
"Error (Data mining): The 'WO_3' mining model has 6690 attributes. This number of attributes exceeds the attribute limit of 5000 allowed by the current version of the algorithm associated with the mining model."
How can I limit number of attributes in a model
Thank you
limit number of attributes in a model
nmfl
worked!!
Thank you
aamer4u
You need to limit the attributes you feed to the model from the source data. In this case you are using a nested table, let's assume "Products". Each nested key e.g. "Product Name" becomes an attribute. You need to limit the product set you want to use to the 5000 attribute limit.
There are a variety of ways you can do this. The simplest is just to determine (using a select distinct in SQL) the top 5000 products and filter the transaction table to those products. There may be products you could group together - e.g. "Green Beans" "Black Beans" and "Pinto Beans" could all become "Beans". The reduction is up to you to determine the best way.
The other workaround is to upgrade to Enterprise Edition which does not have an attribute limit.