| Groups | Blog | Home |
sql server data mining : Report Generation.
Hi Fellows,
It's been quite sometime! Please I need your help as regards SQL Server 2000's Analysis Manager. After creating a mining model and browsing it, I want to generate a report-like detail of the rules on which the classification was made by the Analysis Manager. The model was created based on Decision Tree algorithm.
To get the content of a tree model in rowset form you can issue the query
"SELECT * FROM <modelname>.CONTENT" - if you need a tool to issue queries, check out the DMSample application at http://groups.msn.com/AnalysisServicesDataMining The Node_Description column of the content provides human readable rules that you can usen - you could simply issue the statement "SELECT NODE_DESCRIPTION FROM <modelname>.CONTENT" as a reporting services source query and see what you get. If you provide more details we will be able to give more specific help - e.g. do you want all rules, the most probable for a certain outcome, etc. etc. -- -Jamie MacLennan SQL Server Data Mining This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "saomot2000" <saomot2000@discussions.microsoft.com> wrote in message news:2B402539-63E1-4F24-A031-3A13F2A49CEA@microsoft.com... > Hi Fellows, > It's been quite sometime! > Please I need your help as regards SQL Server 2000's Analysis Manager. > After creating a mining model and browsing it, I want to generate a > report-like detail of the rules on which the classification was made by the > Analysis Manager. > The model was created based on Decision Tree algorithm. > Thanks in cooperation of your help. Need is urgent.
A sample file using SQL Server Reporting Services for SQL Server 2000 Data
Mining is also available in "File" section of http://groups.msn.com/AnalysisServicesDataMining/. -- Peter Kim This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "saomot2000" <saomot2000@discussions.microsoft.com> wrote in message news:2B402539-63E1-4F24-A031-3A13F2A49CEA@microsoft.com... > Hi Fellows, > It's been quite sometime! > Please I need your help as regards SQL Server 2000's Analysis Manager. > After creating a mining model and browsing it, I want to generate a > report-like detail of the rules on which the classification was made by > the > Analysis Manager. > The model was created based on Decision Tree algorithm. > Thanks in cooperation of your help. Need is urgent.
Thanks Jamie & Peter,
I appreciate your response. I have checked the link provided but the content of the link has been moved to a new site. After searching for such content as you recommended and found none from the new site, I decide to beckon on you again for help with regards to the content that has details on my previous request. Please kindly provide me with a url that has the content on report generation for Analysis Manager models. Thank you. [quoted text, click to view] "Peter Kim [MS]" wrote:
> A sample file using SQL Server Reporting Services for SQL Server 2000 Data > Mining is also available in "File" section of > http://groups.msn.com/AnalysisServicesDataMining/. > > -- > Peter Kim > This posting is provided "AS IS" with no warranties, and confers no rights. > > "saomot2000" <saomot2000@discussions.microsoft.com> wrote in message > news:2B402539-63E1-4F24-A031-3A13F2A49CEA@microsoft.com... > > Hi Fellows, > > It's been quite sometime! > > Please I need your help as regards SQL Server 2000's Analysis Manager. > > After creating a mining model and browsing it, I want to generate a > > report-like detail of the rules on which the classification was made by > > the > > Analysis Manager. > > The model was created based on Decision Tree algorithm. > > Thanks in cooperation of your help. Need is urgent. > >
Hi Jamie,
Thanks for your reply. From where can I run the query you gave above("SELECT * FROM <modelname>.CONTENT")...Query Analyzer, EM, or ...? In answer to your question on my being more specific, I want all the rules and the most probable for a certain outcome reports. I will also appreciate it if you can give me another url handle to this http://groups.msn.com/AnalysisServicesDataMining because http://groups.msn.com/AnalysisServicesDataMining has been relocated and I did not find the content you directed me to. Thanks. [quoted text, click to view] "Jamie MacLennan (MS)" wrote:
> To get the content of a tree model in rowset form you can issue the query > "SELECT * FROM <modelname>.CONTENT" - if you need a tool to issue queries, > check out the DMSample application at > http://groups.msn.com/AnalysisServicesDataMining > > The Node_Description column of the content provides human readable rules > that you can usen - you could simply issue the statement "SELECT > NODE_DESCRIPTION FROM <modelname>.CONTENT" as a reporting services source > query and see what you get. > > If you provide more details we will be able to give more specific help - > e.g. do you want all rules, the most probable for a certain outcome, etc. > etc. > > -- > > -Jamie MacLennan > SQL Server Data Mining > This posting is provided "AS IS" with no warranties, and confers no rights. > "saomot2000" <saomot2000@discussions.microsoft.com> wrote in message > news:2B402539-63E1-4F24-A031-3A13F2A49CEA@microsoft.com... > > Hi Fellows, > > It's been quite sometime! > > Please I need your help as regards SQL Server 2000's Analysis Manager. > > After creating a mining model and browsing it, I want to generate a > > report-like detail of the rules on which the classification was made by > the > > Analysis Manager. > > The model was created based on Decision Tree algorithm. > > Thanks in cooperation of your help. Need is urgent. > >
That's strange. The link didn't move to a new web site.
-- Peter Kim This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "saomot2000" <saomot2000@discussions.microsoft.com> wrote in message news:203E5A87-2D32-41B2-9726-8862EF27A240@microsoft.com... > Thanks Jamie & Peter, > I appreciate your response. > I have checked the link provided but the content of the link has been > moved > to a new site. After searching for such content as you recommended and > found > none from the new site, I decide to beckon on you again for help with > regards > to the content that has details on my previous request. > Please kindly provide me with a url that has the content on report > generation for Analysis Manager models. > Thank you. > > "Peter Kim [MS]" wrote: > >> A sample file using SQL Server Reporting Services for SQL Server 2000 >> Data >> Mining is also available in "File" section of >> http://groups.msn.com/AnalysisServicesDataMining/. >> >> -- >> Peter Kim >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> "saomot2000" <saomot2000@discussions.microsoft.com> wrote in message >> news:2B402539-63E1-4F24-A031-3A13F2A49CEA@microsoft.com... >> > Hi Fellows, >> > It's been quite sometime! >> > Please I need your help as regards SQL Server 2000's Analysis Manager. >> > After creating a mining model and browsing it, I want to generate a >> > report-like detail of the rules on which the classification was made by >> > the >> > Analysis Manager. >> > The model was created based on Decision Tree algorithm. >> > Thanks in cooperation of your help. Need is urgent. >> >> >>
Thanks Peter,
I must have ignored the "file" link before now, but I have seen the file and I'm impressed. I am grateful. [quoted text, click to view] "Peter Kim [MS]" wrote:
> That's strange. The link didn't move to a new web site. > > -- > Peter Kim > This posting is provided "AS IS" with no warranties, and confers no rights. > > "saomot2000" <saomot2000@discussions.microsoft.com> wrote in message > news:203E5A87-2D32-41B2-9726-8862EF27A240@microsoft.com... > > Thanks Jamie & Peter, > > I appreciate your response. > > I have checked the link provided but the content of the link has been > > moved > > to a new site. After searching for such content as you recommended and > > found > > none from the new site, I decide to beckon on you again for help with > > regards > > to the content that has details on my previous request. > > Please kindly provide me with a url that has the content on report > > generation for Analysis Manager models. > > Thank you. > > > > "Peter Kim [MS]" wrote: > > > >> A sample file using SQL Server Reporting Services for SQL Server 2000 > >> Data > >> Mining is also available in "File" section of > >> http://groups.msn.com/AnalysisServicesDataMining/. > >> > >> -- > >> Peter Kim > >> This posting is provided "AS IS" with no warranties, and confers no > >> rights. > >> > >> "saomot2000" <saomot2000@discussions.microsoft.com> wrote in message > >> news:2B402539-63E1-4F24-A031-3A13F2A49CEA@microsoft.com... > >> > Hi Fellows, > >> > It's been quite sometime! > >> > Please I need your help as regards SQL Server 2000's Analysis Manager. > >> > After creating a mining model and browsing it, I want to generate a > >> > report-like detail of the rules on which the classification was made by > >> > the > >> > Analysis Manager. > >> > The model was created based on Decision Tree algorithm. > >> > Thanks in cooperation of your help. Need is urgent. > >> > >> > >> > >
You can also find the sample at
http://www.sqlserverdatamining.com/DMCommunity/SQLServer2000/default.aspx. -- Raman Iyer SQL Server Data Mining [Please do not send email directly to this alias. This alias is for newsgroup purposes and is intended to prevent automated spam. This posting is provided "AS IS" with no warranties, and confers no rights.] .. [quoted text, click to view] "saomot2000" <saomot2000@discussions.microsoft.com> wrote in message news:F1ED12FB-BA95-4292-B266-EFE8DE3EAC2B@microsoft.com... > Thanks Peter, > I must have ignored the "file" link before now, but I have seen the file and > I'm impressed. > I am grateful. > > "Peter Kim [MS]" wrote: > > > That's strange. The link didn't move to a new web site. > > > > -- > > Peter Kim > > This posting is provided "AS IS" with no warranties, and confers no rights. > > > > "saomot2000" <saomot2000@discussions.microsoft.com> wrote in message > > news:203E5A87-2D32-41B2-9726-8862EF27A240@microsoft.com... > > > Thanks Jamie & Peter, > > > I appreciate your response. > > > I have checked the link provided but the content of the link has been > > > moved > > > to a new site. After searching for such content as you recommended and > > > found > > > none from the new site, I decide to beckon on you again for help with > > > regards > > > to the content that has details on my previous request. > > > Please kindly provide me with a url that has the content on report > > > generation for Analysis Manager models. > > > Thank you. > > > > > > "Peter Kim [MS]" wrote: > > > > > >> A sample file using SQL Server Reporting Services for SQL Server 2000 > > >> Data > > >> Mining is also available in "File" section of > > >> http://groups.msn.com/AnalysisServicesDataMining/. > > >> > > >> -- > > >> Peter Kim > > >> This posting is provided "AS IS" with no warranties, and confers no > > >> rights. > > >> > > >> "saomot2000" <saomot2000@discussions.microsoft.com> wrote in message > > >> news:2B402539-63E1-4F24-A031-3A13F2A49CEA@microsoft.com... > > >> > Hi Fellows, > > >> > It's been quite sometime! > > >> > Please I need your help as regards SQL Server 2000's Analysis Manager. > > >> > After creating a mining model and browsing it, I want to generate a > > >> > report-like detail of the rules on which the classification was made by > > >> > the > > >> > Analysis Manager. > > >> > The model was created based on Decision Tree algorithm. > > >> > Thanks in cooperation of your help. Need is urgent. > > >> > > >> > > >> > > > > > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |