Groups | Blog | Home


Archived Months
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


all groups > sql server data mining > february 2006 > threads for february 15 - 21, 2006

Filter by week: 1 2 3 4

Association Rules DMX help
Posted by sdejmal NO[at]SPAM gmail.com at 2/21/2006 1:17:28 PM
Hello, Say with AdventureWorks you want to predict products that a customer will purchase based on 1) what is in their shopping cart AND 2) customer attributes such as Gender, Marital Status, Commute Distance, etc. I created an Association Rules mining model with these attributes...more >>

Plugins
Posted by Paul at 2/21/2006 8:52:35 AM
I have a nice plugin going (nifty API you guys!), so I understand at least the basics. Now some questions: 1. Is there a sample plugin that is a clustering style plugin? If not, are there docs somewhere that go into this a little bit? 2. Is there a sample plugin that is a time series style...more >>

Forecasting Model Viewer
Posted by georgiana at 2/21/2006 2:03:40 AM
hi! does anyone know where I can find a free winform control to view a forecasting model developed using Time series algorithm in Sqlserver 2005, from a C# 2005 application. *** Sent via Developersdex http://www.developersdex.com ***...more >>

dmx query: one column coming out empty...
Posted by sqlster at 2/20/2006 10:24:28 PM
Given the content of my oltp tables custlist and custlistpurchase respectively custid gender city ----------- ---------- ---------- 1 male newyork 2 male queens 3 female seatle 4 female phoenix (4 row(s) ...more >>

mining algorithm
Posted by prati at 2/20/2006 9:37:26 PM
hi all based on both relational as well as OLAP data i have created mining models.i want to predict some data as well as i m interested in finding out the association between these data items. i hv teken 1 mining solution n both the algorithms are working fine.now i want to apply As...more >>

MDX in pivot table
Posted by Nicol at 2/20/2006 1:57:58 AM
Hi, I tried to run MDX query in pivot table as a web part in SPS site. It is a valid query that i tetsed in SQL server management studio. but it is not executed in the site... when i set the query string itself. it tooks long time and said "Not respoding" how can i get rid off thi...more >>

How to see sql 2005 dataming models in excel
Posted by thefoolcoder NO[at]SPAM email.it at 2/20/2006 1:31:05 AM
Hi to all, I created several mining models using analysis 2005 and I can easily see them with the viewer in which I built them (the one in visual studio 2005), but how can i spread my data mining models in excel? I discovered it's very straightforward to see a cube in excel just doing an "impor...more >>

web mining
Posted by wessam.maher NO[at]SPAM forislam.com at 2/20/2006 12:00:00 AM
1- how to build a dataminig model on the web as moviepick.com 2- according to the webcast "Introduction to SQL Server 2005 Data Mining" I've made all the steps in this webcast but in the call center report the predictive column its values are constant!!...more >>



RE: SQL Server 2005 Installation On Windows XP and SQL Server 2000
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 2/19/2006 12:00:00 AM
> > Can SQL Server 2005 (Yukon) be installed on the same > Windows XP OS with SQL Server 2000. > > We installed a number of Yukon Data Mining Beta Releases o > Windows XP Machines running SQL Server 2000 and all the > installations failed when we tried to browse the Data > Mining Analys...more >>

A connection cannot be made. Ensure that the server is running
Posted by Naveen S at 2/17/2006 4:20:16 PM
Dear All, I am trying to connect to MS SQL Analysis server 2005 installed on a windows 2003 server using Microsoft.AnalysisServices.AdomdClient provider using C# code. The connection code i have used is as follows: using Microsoft.AnalysisServices.AdomdClient; { AdomdConnection objCon = nu...more >>

Regression
Posted by Paul at 2/17/2006 10:31:40 AM
Key F1 F2 1 100 20 2 99 20.5 3 98 21 4 97 21.5 5 96 22 6 95 22.5 7 94 23 8 93 23.5 9 92 24 10 91 24.5 11 90 25 12 89 25.5 13 88 26 14 87 26.5 15 86 27 16 85 27.5 17 84 28 18 83 28.5 19 82 29 20 81 29.5 21 80 30 22 79 30.5 23 78 31 24 77 31.5 25 76 32 26 75 32.5 27 74 33 2...more >>

possibly "skip" misunderstanding
Posted by ZULFIQAR SYED at 2/17/2006 7:40:30 AM
Book: DAta mining with sql server 2005 Chapter: 9 Page 241 - 242 Possible misunderstanding: Should there be a (skip,movie_name) on the first dmx query insert on page 242 based on movieassociation model on page 241? -- http://zulfiqar.typepad.com BSEE, MCP...more >>

A suggestion to MS Data Mining Clustering Algorithm
Posted by fengjiong NO[at]SPAM hotmail.com at 2/17/2006 12:00:07 AM
I have this scenario: My case table T1 is like (URLID, URL, Title, ...) Here URLID is Primary key My nested table T2 is like (URLID, KeyworID) Here URLID joins with T1. I have about 500k unique URLID, and have about 180k unique KeywordID (both ID are bigint type) Now I can create a mo...more >>

costs of false classification (Naive Bayes) for max. profit
Posted by holy at 2/16/2006 2:55:01 AM
Hallo, can You tell me, how can I put the costs of false classification in a mining model (Naive Bayes), in order to increase my profit. Thanks. ...more >>

ADO.NET Failed to load msxmlsql.dll
Posted by Daniel at 2/15/2006 6:03:03 PM
ADO.NET Failed to load msxmlsql.dll How to fix this error? System.Data.SqlClient.SqlException: Failed to load msxmlsql.dll. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlComm...more >>

DMX Query
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 2/15/2006 1:20:12 PM
Hi, I am having a DMX Query as follows. SELECT [Englishproductname],( SELECT $TIME, [Profit], PredictVariance([Profit]) FROM PredictTimeSeries([Profit],5)) FROM [ProductSales_Forecast] It displays as English productname and the Expression as columns. The expression consists of time, ...more >>


DevelopmentNow Blog