Hi! 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? 2. Is that with other tools possible to create ...more >>

Hi Guys, 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 pr...more >>

Hello all, 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). But I dont have this software and I have no idea how could...more >>

Hello everybody, 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? The result should be: e.g 7 Clusters with the foll...more >>

This sounds stupid, but I cannot find a way to just get today's date without the time to pull a date range... I have tried convert (datetime, GetDate(), 112) and some others, all to no avail... isn't there just a date function that doesn't include the time? ...more >>

I have a field in a table that contains date data in the following format: 20040301 what is the best, low impact method for converting this to a useable date field? ...more >>

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 and tb1.data_dt = '20031231 This query for these tables where are large, about 2 million rows a piece, returned the correct result, but...more >>

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 use to do this.....and...more >>

Hi ! 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 cluster 010 created? D...more >>

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 Hoc SQL submitted from the software is simply a SELE...more >>

Hi every one: I am realy stuck! 1. I am always receiving an error while running query using DMsample.exe. I have installed lattest service packs and installed ocx componenet according to SQLSERVER.DATAMINING faq . --> Error message comes: The operation has failed because of an error in the...more >>

Hi ! 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 ...more >>

Hi ! 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: DC.Execute "INSERT INTO " & DMMName & " " & _ "(SKIP, [EMP_CARD_INDEX]...more >>

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

Hi all, 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 the number...more >>

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. --- Posted using Wimdows.n...more >>

Hi all I'm trying to re-process a manually created mining model in the analysis services. I suppose this is possible with DSO 'processfull' command ? but i use C# for development and not sure how to connect to a existing mining model. I have pasted a part of the VB 6.0 sample coding found in SQL se...more >>

Hi, I have VB 6.0 and am running Win2K with SP4. However the readme file recommends SP3. Is this the reason for the crashes?? Sinex Original Message: Hi, I just tooke the DMSample from the files section at MSN groups. The exe works fine. But when i open the vbp project I encounter...more >>

Hi, I am using SQL Server2K with Analysis Services. Does the client version of SQL Server also have an Analysis Manager? Is there some UI in the client which hooks up with the Analysis Server on the server side? Another doubt I had was the following:: Say I write an add-in for Analysis Servi...more >>

I've got a linked server setup to DB2, and some of the date fields in the DB contain 1/1/0001 values. When I attempt to select that field, I get an error Server: Msg 8114, Level 16, State 8, Line 1 Error converting data type DBTYPE_DBTIMESTAMP to datetime. I assume since valid dates ...more >>

Hi, I'm looking for a good tool that end users can use to view data mining models that I have created. Excel can be used to view the pivot tables, but I have yet to find a good viewer for mining models. Regards, Olof...more >>

if i implement ole db for dm provider,and build it as **.dll, how to register them in analysis server?? is it like :regsvr32 **.dll, is it right?...more >>

Hi ! I have a cluster model of my data. I'd like to perform queries against this model now. What sort of queries can I make? How can i make more sense of the clusters? ....Sinex ...more >>

Dear all, I’m a student whose doing extensive research on data warehousing and data mining. With me, is a full dataset of students’ record from a local university. Information’s which is in the dataset consists of students subjects, grades, personal information, library information, to hostel...more >>

Hi ! I have an employee database. I applied the culstering model to thid db. Now I want to write a query such that given an employee index, i need to retrieve which cluster he belongs to ( and also retrieve info abt the rest in the same cluster)! ....Sinex ...more >>

Hi ! I just ran the clustering algorithm (from analysis manager) on my data and got a nice output in the mining model browser! But how did the algo segment the data into 10 clusters? Whats the meaning of these clusters? How do I interpret these clusters? Is there any material/resource th...more >>

Hi, I have a db on Sqlserver 2000, compatibility level 80 and my collation name is "SQL_Latin1_General_CP1_CI_AS", I have SP3 On the server regional options we have dd/MM/YYYY, and the problem is that after a reboot I have months like 'tammi', 'helmi', 'maails', 'huhti', 'touko', 'ke...more >>

Hi all I have written many times to this forum and have received valuable information. Thanks for all who replied me. But I’m still uncertain, what analysis service is capable of. My scenario is as follows (I’ll try to make is simple as possible). I have a chart and the X axis is the days (e.g...more >>

Hi all , Please I need help , every time I'm trying to make prediction query using Datamining prediction task I get "invalid precision value" error . I'm using decision tree algorithm and my query is : SELECT [Member Card RDBMS].[member card] AS [Member Card], (100 * PREDICTPROB...more >>

Is there an easy way to convert an UPPERCASE string into Mixed Case I'm loading flat files into tables and would like to convert the address field from UPPER to Mixed. I can do this in WORD, but would rather find an SQL solution Thanks!...more >>

This very important online survey will give you the opportunity to provide feedback on the availability of SQL Server information and peer support in the SQL Server communities. This will help Microsoft and its community partners to better understand customer needs and how to improve your experienc...more >>

We are trying to understand how dataminig works in SQL Server, but every time we go into mining models inside Analisys Services we get this error message: "Unable to get list of datamining algorithms. Object or provider is not capable of permormed request operation". Is there anything wrong in ...more >>

I want to do third party provider,at first, I just realize that I should know what is dm algorithm,ole db for datamining,but now I think i will know about how to program with ole db ,what structure of program ole db provider.what else ??? how to be third party quickly,what is prelimiary?? ...more >>

Hi, I just tooke the DMSample from the files section at MSN groups. The exe works fine. But when i open the vbp project I encountered problems: 1. I tried to run the app. It crashed saying Instruction <address> referenced memory at <address>. 2. I tried to open the main frm in design view...more >>

Hi ! I created a cluster mining model using Analysis Manager. Now, I want to query this model from my VB application and display this model using angoss SegView Ctrl. How do i do this? Also is it possible for me to retrieve a subset of this model from code (using Select statements?). Sinex ...more >>

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 database, and I get ...more >>

I have a field in a database that contains dates in the following format: 20040205 It is a text field and I need to convert it to a date so I can compare and control a dataset. Any suggestions would be greatly appreciated... I have tried to use GetDate(20040205), but it just gives me an ...more >>

Hi All When I use CREATE MINING MODEL statement in C# via a Oledb Connection nothing happens. I even dont get error massage. I use Service Pack 3 for analysis services and for SQL server. CREATE MINING MODEL does not specify what data destination to use. it simply say to create a mining model with...more >>

can I do sample provider's parser for ole db for data mining with other free parse tools? and the other question is that i can develope sample provider with vs.net,i use vb.net,is it ok? ...more >>

<shameless plug> In SQL Server Yukon, the PIVOT/PIVOT functions promise to be very helpful for Data Miners. This is my article on Builder.com about it: http://builder.com.com/5171-22-1045432.html </shameless plug> ...more >>

how does the mining model wizard gets the parameter info that should be given with the create mining model query for ex we need to get a min support and min confidence for association rule mining based algoritham .after aggregating the algoritham with analysis server will the mining model...more >>

why is there the sample provider comes without a $500 worth of visual parser++?why cant we use any open source or why not provided by microsoft itself? as we were a student at our final weeks of college project presentation we cant affort it. next can i do anything to implement my associat...more >>

I've written the following SQL script which the Query Analyzer, that came with our SQL Server 2000, has confirmed as OK. However, when I attempt to run the script nothing is returned. I'm very new to SQL, so this may be a simple user error, but I would really appreciate some help, Thanks ...more >>

I am trying to get a date range from the first of whatever month is previous to the current one to exactly one year previous to that date ie 02/01/04 to 02/01/03 to pull the appropriate section of data out... I have tried to use: BETWEEN MONTH(GETDATE()) - 1 + '/' + 01 + '/' + YEAR(GETDATE()...more >>

I have download new sampleprovider,I do evevrything according read me,but I use platform sdk oct 2002 and trial vp.it didnt run. I read FAQ: 39. Can I compile the sample provider with trial version of Visual Parse++? last words tell that: There may be some way to get around this. But, it w...more >>

what is dso's aggregator?what relation between aggregator and the third party provider? where are I can find more materials about aggregator, it seem fail when search it in sql server help. than a lot...more >>

1.if i load the third party provider in analysis server,can i unload it from analysis server again? 2.where do i can download this article"Mosaic Interactive DM article ",An article about Analysis Services Data Mining with source code.the present linking is invalid. 3.sample provider readme ...more >>

como puedo saber que verion de service pack tengo instalado? gracias ...more >>

I knew SQL server data mining from last year,My material about it is old ,I find they are before last two or three years ,after serveral years,how about data mining in microsoft,how to develope it in future? I also have a question about microsoft data mining sample provider,I build it a...more >>

I'm doing my tesis about datamining in particular about clustering. If somebody knows sites, book, suggestions about clustering tell me, please! Thankyou in advance, Mario....more >>