Data Mining in a Report!? Again!

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

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

Data Lost-Merge Replication

We are using merge replication over internet to repliacte our data b/w 2 servers located at 2 different branch offices. But the strange thing is we are losing data i.e. data is being automatically deleted during replication.

any idea/help for fixing it would be hihgly appreciated

thank in advanceProbably failed insert at subscriber poss due to Referential Integrity Failure.

Because SQL Must make publisher & Subscriber with same data it will come back & delete publisher row

Keep an eye on the conflicts