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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|