all groups > sql server data mining > february 2006 > threads for february 15 - 21, 2006
Filter by week: 1 2 3 4
Association Rules DMX help
Posted by sdejmal NO[at]SPAM gmail.com at 2/21/2006 1:17:28 PM
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 >>
Plugins
Posted by Paul at 2/21/2006 8:52:35 AM
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 >>
Forecasting Model Viewer
Posted by georgiana at 2/21/2006 2:03:40 AM
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 >>
dmx query: one column coming out empty...
Posted by sqlster at 2/20/2006 10:24:28 PM
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 >>
mining algorithm
Posted by prati at 2/20/2006 9:37:26 PM
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 >>
MDX in pivot table
Posted by Nicol at 2/20/2006 1:57:58 AM
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 >>
How to see sql 2005 dataming models in excel
Posted by thefoolcoder NO[at]SPAM email.it at 2/20/2006 1:31:05 AM
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 >>
web mining
Posted by wessam.maher NO[at]SPAM forislam.com at 2/20/2006 12:00:00 AM
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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
RE: SQL Server 2005 Installation On Windows XP and SQL Server 2000
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 2/19/2006 12:00:00 AM
>
> 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 >>
A connection cannot be made. Ensure that the server is running
Posted by Naveen S at 2/17/2006 4:20:16 PM
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 >>
Regression
Posted by Paul at 2/17/2006 10:31:40 AM
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 >>
possibly "skip" misunderstanding
Posted by ZULFIQAR SYED at 2/17/2006 7:40:30 AM
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 >>
A suggestion to MS Data Mining Clustering Algorithm
Posted by fengjiong NO[at]SPAM hotmail.com at 2/17/2006 12:00:07 AM
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 >>
costs of false classification (Naive Bayes) for max. profit
Posted by holy at 2/16/2006 2:55:01 AM
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
Posted by Daniel at 2/15/2006 6:03:03 PM
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 >>
DMX Query
Posted by anonymous_user NO[at]SPAM sqlserverdatamining.com at 2/15/2006 1:20:12 PM
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 >>
|