Hi My company would like to buy a data mining tool. Do all of you have some suggestions to me? I hope that the tool can provide the following functions 1. Cleaning and transformation of dat 2. Can do clustering, decision tree, association, sequence mining, regression (not necessary to contain a...more >>

Hi, Do you kown what is the maximum quantity of columns that Analisys Services supports for a Relational, clustering data mining model? ...more >>

Hi, Will appreciate replies to the following: 1) Need a good tutorial/starting point (but with examples) to learn and get started on the topic of DATA MINING. 2) Will someone kindly explain the relationship between BI and Data Mining? 3) And last but not least, if one is doing OLAP (...more >>

I have another question related to the NULL IGNORE clause one. Do you know how the Null values are treated in a clustering relational data mining model? Can the user control this behaviour? For example, I have the following table: Car Model Feature 1 Feature 2 ...more >>

Thank you for your reply. =20 =20 I understand your point, however I cannot filter records=20 that have null fields because I need them. What I need is to make a segmentation based on the fields=20 that have values only. I did a segmentation but some of=20 the clusters have a description that...more >>

It seems that this clause is not supported in SQLServer=20 2000. Do you know how can I ignore null values in a Clustering=20 mining model ? Thanks, C=E9sar...more >>

Hello I have a sql update statement thats quite large with several "select nests". It generally takes an hour to run when I need to effect a lot of records. In VB6 using ADO, I issue the statement and sometimes the update doesn't actually preform the write (I think when I get over a certain ...more >>

Hi, I have a server machine. It has SQL Server 2k with analysis services running. Now can i write an application on a client machine to say read the content of a cluster data mining model ? My client machine does not have SQL Server installed. Is there any requirements the client has to sati...more >>

Hi I am using SQL Server 7.0 to create Web based reports for global clients using Business Objects. I need to show line numbers(row numbers) for each record retrieved. Is there any function to achieve this in SQL(parallel to Oracle's rank() over rowid function) ? Any kinda help will be appreciated ...more >>

I wanted to use SQL Server's Analysis Manager to create a new data mining model. I was already running the wizard, until I got an error message which says "Unable to get list of data mining algorithms. Operation is not allowed when the object is closed. How do I solve this problem and get my model...more >>

Hello there, Our db designer is storing dates (date_field) as nvarchar (yyyymmdd) and not as smalldate. So I usually need to use the syntax RIGHT() to display the dates in an user reading friendly format such as dd-mm-yy and the CAST(date_field AS int) to order and search for them. How...more >>

Dear folks I am a SQLserver rookie, when I run a time consuming query, how I can cancel the query while it is running? Thank you for your time ...more >>

I have 5 fields: Name SpendAmount RecommendedAmount AmountOver Compliant Jo 5000 3000 2000 Yes Donna 2000 4000 ...more >>

i dont know if this is the right group ,therefore sorry for any inconvenience. i didn't work on data mining before,now i want to implement an algortihm as a beginning. When i search through the net, i see lots of algorithms. My aim is to find relations between data in a database. but i dont ...more >>

Does anybody knows why the ClusterDistance() function doesn't produce an output when used in a clustering prediction query? The functions Cluster() and ClusterProbability work OK....more >>

hi i WOULD LIKE TO KNOW how to create CUBE ROLES using vb./c#(.net)coding. any body has any idea? any help would be highl;y appreciated, thnx in advance Prasad *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for ...more >>

I need a function equivalent to the excel CHIDIST function. This function calculates the one-tailed probability of the chi-squared distribution. I don't think there is a built in function for it in SQL server, so would I calculate it? Is there a third-party tool that can do this? Does an...more >>

I have a trained clustering model based on a cube with two dimensions. The training produced clusters of the case dimension (A) elements, based on the existence of records in the cube that associate (via foreign keys) a record from A with a record from dimension B (I am not interested in ...more >>

Hi, I have to convert a field from a VARCHAR to a float on existing client databases. I am using IsNumeric to determine whether the column is a number and if it is using CONVERT to change it to a float. However IsNumeric seems to allow certain characters such as the $ sign and commas and...more >>

SQL 2K We have a data-warehouse server which loads data from different databases which resides in a different server, perform business logic and load into a FACT table. I created 4 SQL jobs which does the above same thing from different databases and writing to same table. This job is schedu...more >>

Hi All, I have a need for a query where the WHERE clause checks multiple fields against a subquery. The following example returns the results I want: SELECT * FROM MyTable WHERE Column1 IN (subquery) OR Column2 IN (subquery) OR Column3 IN (subquery) In reality, ...more >>

Hi All, Please refer to following table ------------------------------------------------------------- ID Title Genre LeadCast SupportingCast Director ------------------------------------------------------------- 01 Queen of the Damned 1 1 1 1 02 Little W...more >>

Pivot Table – Date Orderin I analyse data for the NHS where the financial year apr-mar is use (all data within a month is ‘aggregated’ to the first of the month – ie all events during May are shown with the data 1st may) In Analysis Manager and Data View I can show months in the desired ...more >>

I think the main advantage is that data mining helps bring to light the trends that are within your data but are not so obvious while doing simple analysis e.g. browsing a cube. I also think that Data Mining also includes some kind of forecasting and users can use this facility to generate ...more >>

Hi, I tried to find some articles or titles of the books in which I could see the actual algorithms, explained in details, used for data mining. If you have any good material for the topic, please reply. Thanks, Mario. --- Posted using Wimdows.net NntpNews Component - Post Made fr...more >>

Hi, I tried to find some articles or titles of the books in which I could see the actual algorithms, explained in details, used for data mining. If you have any good material for the topic, please reply. Thanks, Mario. --- Posted using Wimdows.net NntpNews Component - Post Made fr...more >>

Hi all, i am from Business Intelligence group, domain is media. my current assignment is to find out similar movie title for new release based on attributes like genre, lead cast, supporting cast, language. we are using ms analysis service 2k for data warehousing & data mining. ms analysis service...more >>

Received the following error during processing a relational mining model. Analysis Server Error: COM (OLE) error '(Microsoft® OLE DB Provider for Data Mining Services) Query column [No of Cards] cannot be converted to model type' ; Time:4/7/2004 11:59:21 AM Thanks John Jayaseelan *** Se...more >>

Hi all, I don't want how to compare datetime and smalldatetime in where clause Could you teach me? Thanks eg table test no | date 1 | 09/03/2004 2 | 10/03/2004 3 | 11/03/2004 if i want to get no 3 from test, what i should include in ...more >>

We have a proble within a cube measure. We ant to design acube containing something like a "running sum". I am quoting this, beacause i didn´t fin any similar expression for this. So, if the column "Sum" is the expression we wanted, we want to get this result in the cube. (TIme is a dimension...more >>

Which PMML mining model does SQL Server support (both as a producer and = a consumer)? Thanks...more >>

Is it possible to generate a password column by putting an expression into the formula field when defining the column, to combine other fields? e.g. (left([varcharcol1],2) &[integeridentitycol] & right([varcharcol2],1)) Thanks Sean. ...more >>

Hi, I am trying to create a view but am having problems. I have 3 tables Contact1, Conthist, Cal (contact info, History (1:M), and Calendar (1:M)) The primary key is accountnno (in all 3 tables) I am not really interested in contact data but I think I need the table for linking purposes (...more >>

Hi, I have an employee data base. I applied the clustering algo and now have the model. But now i need to answer the following question: Given an employee id, which cluster does he belong to, and who are the other employees in that cluster? How do I write the query for this? Select from mode...more >>

Hi, I setup a new server (Windows 2000 Server) and installed SQL Server 2000. For some odd reasons every 3 or 4 days it shuts down at nights and causes too many problems for us. Because our clients are suppose to send information at nights. The only error message I got so far (one day that...more >>

I just installed Analysis Server, and tried to view the FoodMart mining models. These mining models have to be processed first, but processing them I get "Error -2147221425: The object structure is not valid (Invalid procedure call or argument)". Creating a new mining model, I get the er...more >>