I have been reading chapter on decision tree algorithm in sql server 2005 data mining book. Even though it discusses the algorithm parameters very well, is there any other source where I could read up on algorithm parameters? Here is the case I am working on. I have a customer demographi...more >>

Can you tell me the different types of machine learning please? Thanks, ...more >>

http://datashaping.com/data_mining_related_keywords.shtml Please let me know if I am missing important concepts. ...more >>

http://datashaping.com/data_mining_related_keywords.shtml Please let me know if I am missing important concepts. ...more >>

Hello, Last year, I have developped 2 specific Viewers for my algorithms Plug-In and it was working (depending of the algorithm I can display the right Viewer). But since the last SQL2005 dev official version, I have problems to retrieve the right Viewer for the right Algoritm. Are there some c...more >>

what is the datatype that enable a sequential number?...more >>

Hi! In Analysis services data mining I found these three medthods for discretizing continuous attributes:automatic, cluster and equal_areas. In some literature I detected also methods equal_ranges and treshold but I couldn't find them in SQL Server 2005 SSAS DM. How is it with these two methods?...more >>

According to this website (http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx ) there are data mining advanced features present in the Enterprise but not in the the Standard edition. Which are those feautres? Are there any other differences? Can I develop and test models with all...more >>

I am trying to simulate mining model creation in SQL Server 2005, in .NET. When I tried to reference Microsoft.AnalysisServices.dll and Microsoft.DataWarehouse.Interfaces.dll in my project directly, they failed saying "Not a valid assembly or COM component". Plz help me Thanks in advanc...more >>

I have a SQL 2005 database with 4 million+ rows. One table in particular has about 35 columns. I have implemented a paged data grid results view for them. They want to be able to sort on the majority of the columns. When they sort they want all the results sorted not just the visible r...more >>

Using Analysis Services with a Sybase database, I have the following message when I try to create a new mining model : 'unable to get list of data mining algorithms' Do I need to install something in the sybase db ?...more >>

Hi all, In BI Development studio after setting up my cube and dimensions (using the wizard), I can't tab to the Browsing tab of dimensions and the cube. Basically the Browser tab does not work for me. I get an error saying that a connection can not be made and that I have to make sure that ...more >>

Say I have 3 columns: X, Y and Time. X and Y are cartesian coordinates. If X, Y and Time are all linearly related, is it possible to set up the data mining engine to predict X and Y based on an input of Time? I can do it regressing X against Time or Y against Time, which makes sense, but ...more >>

Since IS and Data Mining are so married, I thought I'd ask this here. I created a plugin that implements an algorithm that is good at removing outliers for my data. I've now created an IS package that prescrubs the data and then creates a prediction from it. I've played with the Data Mining...more >>

Could some one please address the question that I posted couple of days ago under the heading: Subject: dmx query: one column coming out empty... Any brief hint or idea would do... Thank you in advance....more >>

Dear All, Help. I am a beginner of implementing Data mining program. Now, I would like to find a the result that when someone buy product A, they mostly will buy product B and C too, so that I am implementing something related to the Association Rules? But I don't know what tools, softwar...more >>

may i know that the MS SQL Server 2005 developer edition has text mining feature? Where can I find this feature in developer edition? Thanks for sharing. ...more >>

I made a relational model using vb. I've created the code based on Claude seidmann book. well it's process well. but when i want to browse the tree result in analysis Manager there's an error message : " Unable to browse the mining model PMB_RDBMS object or provider is not capable of performing re...more >>

Hello, Say with AdventureWorks you want to predict products that a customer will purchase based on 1) what is in their shopping cart AND 2) customer attributes such as Gender, Marital Status, Commute Distance, etc. I created an Association Rules mining model with these attributes...more >>

I have a nice plugin going (nifty API you guys!), so I understand at least the basics. Now some questions: 1. Is there a sample plugin that is a clustering style plugin? If not, are there docs somewhere that go into this a little bit? 2. Is there a sample plugin that is a time series style...more >>

hi! does anyone know where I can find a free winform control to view a forecasting model developed using Time series algorithm in Sqlserver 2005, from a C# 2005 application. *** Sent via Developersdex http://www.developersdex.com ***...more >>

Given the content of my oltp tables custlist and custlistpurchase respectively custid gender city ----------- ---------- ---------- 1 male newyork 2 male queens 3 female seatle 4 female phoenix (4 row(s) ...more >>

hi all based on both relational as well as OLAP data i have created mining models.i want to predict some data as well as i m interested in finding out the association between these data items. i hv teken 1 mining solution n both the algorithms are working fine.now i want to apply As...more >>

Hi, I tried to run MDX query in pivot table as a web part in SPS site. It is a valid query that i tetsed in SQL server management studio. but it is not executed in the site... when i set the query string itself. it tooks long time and said "Not respoding" how can i get rid off thi...more >>

Hi to all, I created several mining models using analysis 2005 and I can easily see them with the viewer in which I built them (the one in visual studio 2005), but how can i spread my data mining models in excel? I discovered it's very straightforward to see a cube in excel just doing an "impor...more >>

1- how to build a dataminig model on the web as moviepick.com 2- according to the webcast "Introduction to SQL Server 2005 Data Mining" I've made all the steps in this webcast but in the call center report the predictive column its values are constant!!...more >>

> > Can SQL Server 2005 (Yukon) be installed on the same > Windows XP OS with SQL Server 2000. > > We installed a number of Yukon Data Mining Beta Releases o > Windows XP Machines running SQL Server 2000 and all the > installations failed when we tried to browse the Data > Mining Analys...more >>

Dear All, I am trying to connect to MS SQL Analysis server 2005 installed on a windows 2003 server using Microsoft.AnalysisServices.AdomdClient provider using C# code. The connection code i have used is as follows: using Microsoft.AnalysisServices.AdomdClient; { AdomdConnection objCon = nu...more >>

Key F1 F2 1 100 20 2 99 20.5 3 98 21 4 97 21.5 5 96 22 6 95 22.5 7 94 23 8 93 23.5 9 92 24 10 91 24.5 11 90 25 12 89 25.5 13 88 26 14 87 26.5 15 86 27 16 85 27.5 17 84 28 18 83 28.5 19 82 29 20 81 29.5 21 80 30 22 79 30.5 23 78 31 24 77 31.5 25 76 32 26 75 32.5 27 74 33 2...more >>

Book: DAta mining with sql server 2005 Chapter: 9 Page 241 - 242 Possible misunderstanding: Should there be a (skip,movie_name) on the first dmx query insert on page 242 based on movieassociation model on page 241? -- http://zulfiqar.typepad.com BSEE, MCP...more >>

I have this scenario: My case table T1 is like (URLID, URL, Title, ...) Here URLID is Primary key My nested table T2 is like (URLID, KeyworID) Here URLID joins with T1. I have about 500k unique URLID, and have about 180k unique KeywordID (both ID are bigint type) Now I can create a mo...more >>

Hallo, can You tell me, how can I put the costs of false classification in a mining model (Naive Bayes), in order to increase my profit. Thanks. ...more >>

ADO.NET Failed to load msxmlsql.dll How to fix this error? System.Data.SqlClient.SqlException: Failed to load msxmlsql.dll. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlComm...more >>

Hi, I am having a DMX Query as follows. SELECT [Englishproductname],( SELECT $TIME, [Profit], PredictVariance([Profit]) FROM PredictTimeSeries([Profit],5)) FROM [ProductSales_Forecast] It displays as English productname and the Expression as columns. The expression consists of time, ...more >>

Where could I host my sql server 2005 applications such as sql reporting services, SSIS, analysis services data mining stuff ?? TIA......more >>

Where Can I Get a PMML Model Consumer? I need an aplication able to read and apply PMML Models......more >>

I still don't understand why do I get most popular items when I try to use function like predict(sometable,5)??? Either it should return the most relevant results or not return any value at all. Lets take movies case that I have been asking question about. If a movie is chosen for which...more >>

After I installed release version of SQL Server 2005 I encountered a strange behavior of PredictTimeSeries function. It stops to predict values after some prediction steps. For example, the query SELECT FLATTENED PredictTimeSeries([ORDER AMOUNT], 30) FROM [SALES BY DATE] issues only 3 predict...more >>

Hi there I am rying to learn datamining with ss05. And have this problem. I have tried to build a clustering datamodel with a case based on a organisation units and a nested table with activity data: unit activity Measure(Fact) 1 A 5 B ...more >>

The default scoring method used in the Decision tree algorithm is Bayesian Dirichlet Equivalent with Uniform Prior (4). 1. Internally, instead of a decision tree, is it stored as a Bayesian network or decision graphs? 2. Any resources/examples to understand this scoring method? Thanxs....more >>

I am trying to find more about data mining description. Something like definitions of it. I heard about things like predictive models, classifications, regressions, clasters, sumarisation, etc. but still I couldn't find real meaning in data minig of those words. Can you tell me (or give me some link...more >>

Hello,the term of 'Markov's chain' was mentioned in the message of http://www.sqlserverdatamining.com/DMCommunity/Newsgroup/2274.aspx . But after browsing the content of http://msdn2.microsoft.com/en-us/library/ms175462.aspx ,I get the idea that Markov's chain is unnecessary in implementing Microso...more >>

Hi Can any one give me step by step process to do text mining on sql server 2005 I have collection of text files and i want to extract some information from them. Thanks in Advance Satish...more >>

Hello, when I use the mining modle viewer of time series modle in BI Development,the decision tree view appears. I don't understand the relationship between the decision tree and the time series modle.So I am puzzled to it. Whould you please tell me the relationship between them and the use of th...more >>

I'm not a COM wizard so any suggestions on how to debug these? Do you need to somehow attach to the main Analysis Services service? ...more >>

Sorry for the blatant ad, but we're looking for help -- any recommended firms in seattle area up to speed on 2005 reporting services?...more >>

Hi, I'm reposting my question hoping to get some help since it was not answered some time ago. I need to track the orders placed by salesmen by month. SELECT SUM(CASE MONTH(DATE_SELL) WHEN 1 THEN 1 ELSE 0 END) AS January, ... SUM(CASE M...more >>

It is possible to query a relational datatable from DMX using call systemopenquery([Data_Source]'SELECT.....'). Is it possible to make queries of the mining model in the opposite direction from T-SQL on Database engine by any of the functions?...more >>

Has anyone seen this error before? "An unexpected error occurred (file 'dmcorrcountutils.cpp', line 2045, function 'DMCC_WorkerJobCaseProcessor::CacheCase')." ...more >>

In TSQL how to use OPENXML to open an ntext field in a table? I can not read the ntext into a local var as TSQL does not allowe ntext local variables. ...more >>