Forecasting Model Viewer - Help -- sql server data mining

anonymous_user NO[at]SPAM sqlserverdatamining.com
2/1/2006 12:00:00 AM

Hai ZhaoHui,
Tx for ur reply.
Actually I am having my .dmm file i.e. the mining model file.
I need a tool/viewer to open that mining model to show the client.

Tx
Nicol

[quoted text, click to view]

ziga
2/1/2006 12:00:00 AM

Hi.

You should try Data mining web controls library. I am not sure it supports viewers for all SQL Server Data Mining Algorithms.
URL:http://msdn2.microsoft.com/en-us/library/ms160727.aspx

[quoted text, click to view]

ZhaoHui Tang
2/1/2006 3:28:11 PM

Does this tool need to be thin client? We do have winform controls available
for free.

[quoted text, click to view]

anonymous_user NO[at]SPAM sqlserverdatamining.com
2/2/2006 12:00:00 AM

Hi Tang,
Tx for ur reply.
I need a thin client tool.
since I need the forecasting minig model file to be dispalyed in my "share point web site".
I required a tool to open my forecasting mining model in my web site.

I am able to open cluster viewer, decision tree viewer and naive bayes's viewer in my web site.

Like that, I need to open my forecasting model developed by Time series algorithm.
I am not able to find a viewer for it.

I know that windows form viewer is there.
But i need in webform as a web control in my Share point site.

Jamie MacLennan (MS)
2/2/2006 9:40:01 AM

We currently do not have a thin client viewer sample for Time Series. You
should be able to use any charting package and provide the data returned by
the model.

You will need to do a SELECT * FROM MyModel.CONTENT to get the historical
data and then do a prediction query e.g.

SELECT PredictTimeSeries(MySeries, 5) FROM MyModel

to get the predicted results.

Assuming your charting control accepts datatables, append these results
together in a datatable and provide to your control.

--

-Jamie MacLennan
SQL Server Data Mining
This posting is provided "AS IS" with no warranties, and confers no rights.
[quoted text, click to view]

nicol NO[at]SPAM sqlserverdatamining.com
2/3/2006 12:00:00 AM

Hai,
Could u give me some samples or some url for this.

anonymous_user NO[at]SPAM sqlserverdatamining.com
2/3/2006 12:00:00 AM

HiJamie,
As u said, I tried with chart control.
I gave the DMX query to my chart control which is present in my Share point website.It took very long time to execute that(No respone). My website hangs and then it says "Not responding".

What I have to do for this?
Am I in the right way?
But the query I gave to the chart control works fine when I run the same query in my Analysis service.

Help me in this regard

Tx in advance

Bogdan Crivat [MSFT]
2/6/2006 2:31:37 PM

Hello,

You can also try to create your own chart rendering control, rather than
loading OWC on the client.
Some instructions and some sample code are available here:
http://www.eggheadcafe.com/articles/20021223.asp
The idea is:
- instantiate OWC in the web control
- execute the query then feed the chart control with data
- save the newly created chart as a GIF in the web directory
- return an HTML pointing to that GIF: <IMG src="name of the saved GIF
file"/>
- erase all temporary GIF files that are older than a few minutes

This should be relatively easy to implement. Further on, you can make your
solution better by:
- changing the architecture to stream directly into the HTTP response from
your control, on request (you will need to add a custom web handler to
ohandle the requests for charts)
- changing the rendering to generate VML script instead of a GIF with the
charts

Hope this helps
--
--
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email directly to this alias. It is for newsgroup
purposes only.

thanks,
bogdan

[quoted text, click to view]

Nicol
2/6/2006 9:48:29 PM

Hi Bogan,
Tx for your reply. shall I able to use MDX/DMX query in chart
control?

Bogdan Crivat [MSFT]
2/8/2006 6:42:42 AM

Hi
If you use the solution I suggested, you can fill in your OWC control with
any data (from DMX / MDX queries, or from SQL, or even from your own
application). Then, you plot the data with OWC and save that data as a GIF.

--
--
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email directly to this alias. It is for newsgroup
purposes only.

thanks,
bogdan

[quoted text, click to view]

Tim Kuz
12/9/2006 12:39:28 AM

How can I view mining model in visual studio 2005 Form (desktop
application)?? Can Data mining web controls be used with windows form?

Bogdan Crivat [MSFT]
12/11/2006 9:55:52 AM

yes, dm viewers can be used in a windows form. Details here:
http://www.sqlserverdatamining.com/dmcommunity/_downloads/1361.aspx

--
--
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email directly to this alias. It is for newsgroup
purposes only.

thanks,
bogdan

[quoted text, click to view]

handra
1/18/2007 9:43:00 PM

[quoted text, click to view]

May i know what control did you use to show the decision tree over the
web browser? It's urgent ...

Thanks .....

--

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server data mining

sql server data mining : Forecasting Model Viewer - Help