Friday, March 9, 2012

Quick question regarding association rules...

Hello,

I'm new to analysis services and hopefully this is a quick & easy question. I have a couple of quite large (163,000 tuple) tables with columns essentially representing a bit vector. I would like to mine for association rules but the number of '1' values are very, very sparse and they are the only objects of interest. How can I get more control over the algorithmthat is, how can I stipulate that the state of the column must be '1' to be considered? Any help or direction to the proper documentation would be great.

When creating the Data Source View, before building your mining model, you could use a View or a named query which would enable you only to consider columns with your required value. See the following link for information on how to add a named query: http://msdn2.microsoft.com/en-us/library/ms175683.aspx

No comments:

Post a Comment