In the classic foodmart 2000 example(a data set i'm taking as input into building an mining application) in an attempt to identify patterns in customers in SQL SERVER 2000: analysis services based on sales data(customer transactions)...what are the patterns i should try to find and what would be the input, target and predictable columns for those patterns....another question is what sort of data mining prediction quiries can i write in order to ge tthe desired output. examples in VB would be very much appriciated. i'm vaguely aware that u can write quries using DTS, but do we use DTS only when a remote db is used(remote as in the the databse is not in SQL server and maybe a access db). what is the easiest way of writing quries.(examples in VB
as futher background to the project i'm doing....i have a sales cube and i'm going to build a mining model both in OLAP and in relational

Foodmart 2000 example data is generated without patterns in-mind. It's very
unlikely you'll find any interesting pattern other than random.

For data mining queries (aka DMX), I suggest you should check out FAQ
(http://groups.msn.com/AnalysisServicesDataMining/faq.msnw), Item 8, where
you'll find a VB app (and its sample queries) with which you can
interactively create DMX queries and run them. Please also check out other
items in the FAQ to get you started better.
--
Peter Kim
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]
building an mining application) in an attempt to identify patterns in
customers in SQL SERVER 2000: analysis services based on sales data(customer
transactions)...what are the patterns i should try to find and what would be
the input, target and predictable columns for those patterns....another
question is what sort of data mining prediction quiries can i write in order
to ge tthe desired output. examples in VB would be very much appriciated.
i'm vaguely aware that u can write quries using DTS, but do we use DTS only
when a remote db is used(remote as in the the databse is not in SQL server
and maybe a access db). what is the easiest way of writing quries.(examples
in VB)
[quoted text, click to view]