Hi,
I am a novice at Data Mining realm on SQL Server.
Scenario:
I have created a Time Series model and deployed it into SQL Server. I hope users can see forecast based on the up-to-date data residing in data source rather than the old ones used to train the model. In a addition, the interface provided for users is a .aspx.
Problems:
What ADO APIs should I exploit to dynamically process the model, perform the forecast and retrieve the results.
Any help would be appreciated.
Best Wishes,
Ricky.
You would likely use ADOMD.NET, not ADO.NEt, but the results would essentially be the same. You would likely want to create models on the fly for this solution, much the same way we do for the Excel addins. You can download the addins and use the trace mechanism to see what commands we send to the server.
Essentially, you want to use CREATE SESSION MINING MODEL, INSERT INTO (you can use an input rowset, or an openquery if your data is in a database), and then SELECT PredictTimeSeries(...) to get the forecast.
Using a session model will cause the model to automatically be deleted on disconnection. Note that you will have to turn on the server property to allow session models.
|||Thanks a lot, Jamie.
Could you give a tutorial or exmaple code to see the deatils?
Regards,
Ricky.
|||The sample here (http://www.sqlserverdatamining.com/DMCommunity/LiveSamples/1866.aspx) creates and trains models dynamically|||Many Thanks, Jamie
Regards,
Ricky.
|||mr jamie...
this link seems to be dead
please send in the link again
|||http://www.sqlserverdatamining.com/DMCommunity/LiveSamples/1866.aspx
|||hi jamie..
could u look into this thread plz...
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1449395&SiteID=1
;m stuck at thiz prb...
i've reinstalled the dm viewer controls.......
now here is wat i read in the readme file as to how to use the dm viewer controls:
In the Winform designer, right click on the Toolbox and select 'Choose Items...' menu item. Hit the Brows button and select file 'Microsoft.AnalysisServices.Viewers.dll'. Hit the OK button to add all the viewer controls to your toolbox.
the prob is tat i can't find this file:'Microsoft.AnalysisServices.Viewers.dll'
do u think i've gone wrong somewhr in the installation of the viewer controls?
or is there somethin else that i must do?
