Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
need help using Association Rules Algorithm

Unanswered need help using Association Rules Algorithm

  • Monday, April 30, 2012 1:08 PM
     
     
    Sign In to Vote
    0

    Hi all,

    I have a question and want to understand whether my problem could be solved using SSAS data mining and if yes, which way it does.

    I am using the association algorithm for a market basket analysis (for example for bikes).
    I have a table with orders including columns TransactionID, equipment (color, brake, wheels,...), depending model AS facilities (blue, brake 1, wheel 1323). Based on the TransactionID and the column facilities (nested table) i run the association rules algorithm. As far as well...

    For the end user it might be interesting to get associations that exist between color and brake. As long as i work with the sql server or the bi development studio i could set filter to analyse only those elements or set filter in the miningmodell viewer. for the end user it might be much more friendly to get for example a drop-down-list with the available equipments. after choosing the important elements (color and brake), only the results should be displayed that depending to color an brakes (e.g. the itemset blue + brake 5).

    The big question in this point is how can i implement this scenario with ssas???

    With the excel add-in i don't have the necessary input values (equipment) to filter, but the facilities (as results).

    Using reports, i could use dmx to filter the results, but this could be a difficult... i have no idea which way i could do this, because i have to set the filter in the mininmodell.cases and then... no idea...

     

    Are there any other ways to implement this with ssas?

    in addition for an end user who's not familiar with the sql server, a friendly graphical user interface would be preferred.

    Any help is appreciated.

    Thanks,

    AnalyzerBI

     

All Replies

  • Monday, May 07, 2012 3:02 AM
    Moderator
     
     
    Sign In to Vote
    1

    Hi AnalyzerBI,

    I'd suggest presenting the mining result by using SQL Server Reporting Services(SSRS). In SSRS, you can build a report against data mining. The dataset query could be something like this -

    SELECT PredictAssociation(...)
    From [Model]
    Natrual Prediction Join
    (SELECT
    (SELECT @Param as [color]
     Union SELECT @Param2 as [Brake]) as [Table]) as T

    Then, the users can select color and brake on report and see the mining result.

    Here is a link http://technet.microsoft.com/en-us/library/cc280429(v=sql.100).aspx to describe how to query an association model.

    Thanks,
    Jerry