lunedì 30 aprile 2012 13:08
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.
Tutte le risposte
lunedì 7 maggio 2012 03:02Moderatore
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 -
Natrual Prediction Join
(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.