1. I create an intranet (IIS) with frontpage 2002 with an office pivot table
with the origin on an sqlserver 2000 cube.
How could my users drillthrough to the rows in the pivot table with the
internet explorer? Is that anywhere possible?

In a Microsoft documentation, about Data Mining using SQL
Server 2000, I found some instructions about the software
Data Mining Tool (good for cleanning data, transform and
split, before building the data mining models).

I have a question regarding trargeted marketing. What is the best mining
algorithm to use for this? Say I have a set of customers who buy from my web
store. Now, whenever I come up with a new product for sale, I would like to
send out broadcasts to "targeted customers."  say my new ...

I have  a relational database containign a table with a lot of facts (e.g.
yearly income).
Now I want to build groups/clusters  for the yearly income.
Is there a way to have the analysis services doing the job automtically?

Hi, I hope this is an appropriate group to ask a question about basic SQL
SELECT performance.
I'm creating a VIEW which draws together two tables; T_ONE and T_MANY.
Basically, the VIEW  creates a LEFT JOIN from T_ONE to T_MANY so that the Ad

I have a query which used 2 tables in the from clause and used the where clause to get the result like so
Select tb1.*, tb2.
from tb1, tb
where tb1.id = tb2.i

i'm writing a program in VB that predicts customer buying patterns using MS AS as the back end....i've create the mining model using VB but i want to show the decision trees and the cluster models to the user through the front end.....are there any 3rd party tools that i could ...

After doing a fresh install of Analysis Services on a Windows 2000 workstation with MDAC 2.7 I am unable to view any cubes.  I cannot view any of the sample cubes.  I created new cubes, I can't view them, and I then created cubes on a SQL database as opposed to the Access sample ...

  I tried the Angoss sample application that comes with the SDK. The
cluster model shows up in the SegView control.
 The first column makes sense - it talks abt the distinct clusters in the
entire population. But wat are the other pie charts? How was cluster 001 to

  I installed the Angoss SDK. Theres a sampe application that comes with
it. It uses an MS Access dbase. Is there a sample that shows how to use it
with the data in SQL server?
...Sinex

  I have SQL Server2K on my machine. I want to create a decision tree model
from my VB application.
I created an ADODB connection first (uses the MSDMine.1 provider). Then I
tried to execute the following statement:

I've created a mining model using MS Decision Tree and
trained it
Now, i need to query it, the only codes i found was using
an openrowset or Model Content, simply i need to check the

this is regard to the massage "SQL server books online mining model sample VB6 to C#" replied by Peter Kim ...I have added the DSO referance already but converting VB6 code Set dsoDB = dsoServer.MDStores("FoodMart 2000") to C# coding is difficult.
and also is it possible to get ...

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 ...

I just started using SQL at work. Iwas wondering how to write a query for a reprt that would allow you to pick the date range that you wanted. Any help someone could give me would be appreciated. I would also be interested in some book titles that would help with this.
---