Here's the question :
1 database, lets call it "Data"
3 data tables, T1, T2, T3
All tables have the same columns : ID, F1, F2, ... Fm

I am trying to use decision trees to analyze my data in the microsoft
sql server 2005 ctp, in the business intelligence development studio,
after running the mining structures wizard the project won't compile
with the error "the datasource "mydatasource_here" contains an

I applied the SQL SP4 on my Laptop WinXP sp2 with latest patches.
I setup a couple of cubes under SQL server Developer editions.
After I applies SQL sp4, I can't choose the cubes when I defines the new
OLAP datasource. It only give me the default cubes without the others cubes.

SQL 2005 will not have English Query.
I am using english Query to query the Analysis services's Data Warehouse.
Is there any Microsoft product or 3rd party product to replace the english
query?

Any problem with http://www.sqlserverdatamining.com?
Service Unavailable
Regards,
Andres

(warning - newbie questions :)
I'm trying to follow the Data Mining Tutorial, and have the following
questions
1. In Lesson2, the tutorial asks you to select CustomerKey as the key,

I'm having trouble with the following with June CTP of SQL Server 2005:
1. The Adventure Works.sln in ":\Program Files\Microsoft SQL
Server\90\Tools\Samples\AdventureWorks Analysis Services Project"
doesn't deploy although it builds fine. (I'm also getting this error

Is there some way of executing an MDX query interactively within Analysis
Manager? (Like the way you can execute an SQL query in the query analyzer).
Thanks

What does the node path mean when browsing a mining model cluster?
I created a sample data set of 10 rows each with a unique case id.  I have
two attributes color and shape that describe each row.  There are 3 colors
(Red, Blue, Green) and 4 shapes (Square, Circle, Cube, ...

I got a single SP that searches the indexed fields.
But i am only able to use
contains(name, @key)
property of the indexed fields. @key is the the keywords of the user that he

Sorry for the crosspost in OLAP on this, my mistake.
I'm having a problem with "Browse Dependancy Network" in Data mining for a
decision tree model.  Everytime I right click the model, and click "Browse
Dependacy Network" I get the following error description.

I am trying to find the instances in a field containg specific keywords or
strings of information.  My table name is History, and my field name is
Notes.  So what I am tryingto do is find every record where History.Notess
conatins;

All:
A pivot table is made from the query listed below. The query ran when I had
less then 10MM records to consolidate. Now that it is up to 17MM it does
not run at all.

Hi Fellows,
Please I need your help as regards SQL Server 2000's Analysis Manager.
After created a mining model on Decision Tree algorithm in SQL Server 2000's
Analysis Manager, I want to generate the report-like detail of the rules on

I am new to this field. I have good proficiency with SQL Server. I want
to develope model for Data Mining for # of users per month.
Can anyone lead me to the good knowledge repository ?
Thanks