Could someone send me the syntax for an If then else construction in a named calcualtion
I keep getting errors when I write
If gender="1" then "m" else "f"
end if

I need to recommend method calls that are commonly used with a given
method call in Java Code. I do not have any user specific data. All I
have is a set of methods that get used together by browsing
repositories.

I've started reading the book "Data Mining with SQL Server 2005" and find it very good.  However, on page 149 of that book, where it discusses Decision Tree splitting based on entropy, the four entropies shown are (0.946 + 0.629), (0.814 + 0.918 + 0.684), (1.0 + 0.845) and (0.896 ...

Is there any tutorial available about how to mine the "reuters corpora" datasets. And direction in this too would be helpful.
Thanks

I am working on page 161 example of data mining w/sql server 2005 book.
Instead of writing a singleton query as follows, I would like to run selects
from
the new tables: cust_new and movies_new. How would I write that query??

I have a question about executing DMX on the server. I would like to create some data mining models and make some predictions programatically. Is it possible to do it in a way similar to stored procedures. Like I just call a stored procedure on the server which executes the code ...

I'm trying to use Excel functions to pull out the Categorys from the node_description in  itemsets produced with Association Rules. I am trying to use SUBSTITUTE to eliminate the " = Existing" from the node_description.
This works in Excel to pull the first Category:

Hi, is it possible to use a sql server 2005 mining model for example in campain management in SAP to address potential churner? How I can do that? Are there standard-interfaces or I have to use native XML/A to access the models?
Thanx

I'm trying to run DMX queries against an Association model for market analysis. As usual, the basket items are in a nested table. Unfortunately, most of the really interesting DMX functions only take scalar columns. Here is the puzzle:
If if use
select flattened ...

Hi Jamie and All,
I have been using SQL Server 2005 data mining for quite a while. They work
fine until recently when I use a big database. For example for the market
basket analysis, we have 3.6 million of cases and it failed to process the

I am writing couple of utility procs for AS. I want to be able to add a data
source and a data source view to an existing database without crating a
project, by simply using a stored procedure in AS. After that I can create
Data Mining models using DMX, therefore I can do ...