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 > june 2006

Which data mining technique should I use?
Posted by Glenn Vassallo at 6/29/2006 2:32:23 AM
I am attempting to utilise data mining in an effort to determine what role price has played on the consumption of a particular food product. I have historical data that includes the sales of the product (how much was consummed), the price of the product (price per a specific weight). I also ...more >>

Delimiters with AMO
Posted by Thorsten at 6/28/2006 12:00:00 AM
Hi NG, with DSO you can get the delimiters with dsoDataSource.OpenQuoteChar and .CloseQuoteChar. Is there an equivalent in AMO? Any suggestions are greatly appreciated. Thanks in advance. Thorsten ...more >>

Anybody home?
Posted by ManForse at 6/27/2006 12:00:00 AM
Where is some help informatione about this site?...more >>

Cluster Profiles are black
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 6/26/2006 1:40:07 PM
The bars of the sequences-result for my Sequence Clustering are all black. Instead of colored cluster of the users and their way through the website I only see black bars with a differend length. Could it deal with service pack 1? Before I installed sp1 I never had problems like that. Version: 9....more >>

Data Mining Questions
Posted by Joe at 6/26/2006 10:10:05 AM
I have a fair bit of Data Warehouse expeierence but am new to Data Mining. Our agency tracks sort of medical information on clients. We do these huge assesments and ask every type of question there is from "do you ever feel like hurting yourself" to "do you think someone has been taking your ...more >>

Cross Selling and predicting quantity sold?
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 6/22/2006 7:20:07 PM
I've done a lot of web research and read a book on analysis services but still haven't found an example of how to develop a cross selling algorithm that can predict not only what is sold, but how much is predicted to be sold. For instance, If I know customer A has bought 5 units of item 1, 10 un...more >>

Constraints on Predicted Outputs and ScalarMiningStructureColumn Properties
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 6/22/2006 5:40:07 PM
Hi, I was wondering if there is any way to rigidly enforce rules about prediction outputs. For instance, if predicting a continous number, it should always be positive. Also, can anyone elaborate on what you can do with the Classified, Distribution, and ModelingFlags properties of a ScalarMin...more >>

schedule dts at a remote server
Posted by Ricky at 6/22/2006 1:45:57 AM
Hi Can somenone help me build a DTS in SQL Server 2000 that allows to schedule the execution of a executable file in a remote server without sql server?... [] Ricky ...more >>



Error Message Using Neural Network Viewer
Posted by David Gold at 6/21/2006 3:20:24 PM
I try to view my trained model based on Neural Network algorithm with its related viewer. I want to see as output an attribute which has dicrete, numeric values (0, 3, 4). But I only get this error message: "Execution of the managed stored procedure GetAttributeScores failed with the followin...more >>

Re: Datamining web control error
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 6/21/2006 12:40:09 AM
Has there been any resolution to this problem -- I'm running into the same issue....more >>

How to do this calculated column
Posted by Manolis at 6/21/2006 12:00:00 AM
Hi again, I have the following problem. I know how to add a calculated column into my table in the DSV I need to specify an expression that makes an OR expreesion between two booleans. I have boolean column bool1 and bolean column bool2 and I need to write the logical expression if (bool1 =1 ...more >>

in sql server 2000+ is there some stored procedure that shows your current disk space usage?
Posted by Daniel at 6/20/2006 4:18:35 PM
in sql server 2000+ is there some stored procedure that shows your current disk space usage? ...more >>

Creating RFM variables
Posted by p.paauwe NO[at]SPAM ism.nl at 6/20/2006 12:00:00 AM
Hello, Momentarily I'm trying to create recency, frequency, and monetary (RFM) variables from a tranactional database using a named query in the data source view. These RFM variables will subsequently be used to create states as input for the sequence clustering algorithm. As the sequence cluster...more >>

Discrete looking outputs from Continous inputs
Posted by Jon Michaels at 6/19/2006 4:40:08 PM
Hi. I am building a prediction model that has 6 continous inputs and a single continous output. Using decision trees, linear regression, and neural network I constantly get the same 4 or 5 predicted output values. From investigating the decision tree model, it appears that there is a three ...more >>

"Suggest Related Columns"
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 6/17/2006 12:40:28 PM
Is there a way to use the feature "Suggest Related Columns" of the Mining Wizard in a DMX-Statement or by programming? Thanx......more >>

CALL System.Microsoft.AnalysisServices.System.DataMining.Clustering.GetClusterCharacteristics
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 6/16/2006 1:00:24 AM
I did a trace while using the data mining viewers and this MDX is what it's running to get the cluster characteristics: CALL System.Microsoft.AnalysisServices.System.DataMining.Clustering.GetClusterCharacteristics('Customer Clusters','',0.0005) The following DMX is somewhat close: select fl...more >>

automatic cluster naming
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 6/16/2006 1:00:08 AM
Has anyone done any work on writing some code which looks at cluster characteristics to give a cluster a friendly name (like Old, Fat, Australians; not like Age=Old, Weight=Fat, Country=Australia)?...more >>

Sequence clustering - order of the model
Posted by Scott G at 6/14/2006 12:00:00 AM
Hello! I've been reeding about sequence clustering algorithm and found that it uses 1st order Markov models to analyze sequences. What exactly does that mean? I know that 1st order models should only consider the last state in a sequence for prediction, but all the examples I've seen have more th...more >>

AMO DataMining Code
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 6/12/2006 3:00:08 AM
hi I want to add an mdx filter to my mining structure using C# code. I use MiningStructure.FilterComponent to do it. After I created model and opened the resulting XMLA, I saw the filter was added into the <Annotation> field like: <Annotation> <Name>MDXFilterComponent</...more >>

DT question
Posted by Paul at 6/8/2006 3:20:56 PM
Data follows: I'm trying to predict Col2. There is a clear inflection point right in the middle. The DT created finds the proper slope for the first 80 or so and the last 80 or so entries, but has trouble with the 40 in the middle. I am presuming that this is because it is doing some sort...more >>

Text NN
Posted by cyberkill NO[at]SPAM i-c.net at 6/7/2006 8:40:09 PM
I've playing with all the tutorials I could find and read as much as possible. I can get all the tutorials to work great. My problem is I can't get my own data to function. Every time I run my data through SQL 2005 in Business Intelligence Studio removes my fields that are text. I've tried every ...more >>

built in user defined functions?
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 6/6/2006 6:20:09 AM
hi, When I was browsing the book Data Mining with SQL Server 2005, I saw there are some built in user defiend functions for the Naive Bayes algorithm, such as GetPredictableAttributes, GetAttributeDiscrimination, etc. I think they are useful. However, I can not find these functions in...more >>

Error with Sample DMX Queries using Adventure Works DW
Posted by Jacob Zeta at 6/4/2006 11:40:09 AM
I get an error executing the "Sample DMX Queries using Adventure Works DW" in SMS When try to Process the mining structure: "INSERT INTO TargetMail (..." I get the error: "The user 'SERVER\AdminJ' does not have permissions to obtain access to the object 'AdventureWorks DW' or the object do...more >>

Clustering problem
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 6/2/2006 3:40:45 AM
Dear All, SQL server 2005 gives two algorithm for clustering.EM and K- means. I want to know the difference between these two. Also if u can help me to identify the method for cluster below attributes, I would be much thankful to you. If my data set has values like age,district Average score, b...more >>


DevelopmentNow Blog