Data Mining in a Report!?

After I make a data mining, how can I put it on a report to see on the Internet Explorer?

For certain models and for some specific data presentations, you can use reporting services to render the content of a mining model. An example on how to do this is available in the two following tips:

http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/4566.aspx

http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/3422.aspx

You might also use the Data Mining Addin for Office 2007 and use the Visio component to generate and annotate data mining diagrams. The visio drawings can be saved as web pages and deployed on the web. Some examples of these reports are available at :

http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/4237.aspx

Finally, you can always save the Mining Model Viewer from our product as an image and embed in a web page. You can also query and extract the mining model content yourself (using ADOMD.Net) and render custom report using any web technology (ASP.Net)

Please let me know if you have any questions

|||

Thank you very much,

By the way, specifically for association rules, which method you indicate?

|||For association rules, if you want to display the itemsets and rules in a tabular format, you can use Reporting Services. The Visio Addin does support the dependency network view of the rules involving size 2 itemsets only. For any other visualization, you have to query the content and set up your own web application to display the rules.|||Thanks a lot, helped very much, but would you have a tutorial or some place with an example where I can read to use reporting server with association rules? I just can′t get it by myself!|||

We don't have a tutorial for this specific scenario. To create the dataset for reporting services, use the DMX content query

SELECT NODE_DESCRIPTION from [Assoc_Model].CONTENT where NODE_TYPE=8

Once you have the dataset, you can use any reporting service tutorial to set up the table that displays rules. You can refer to the following tip that shows how to display a decision tree in reporting services as a expandable tree, but yours is more straightfoward than this.

http://www.sqlserverdatamining.com/DMCommunity/TipsNTricks/3422.aspx

Let me know if you have any additional questions

|||PERFECT - THANK YOU VERY MUCH