Hi, I am working in Share point service now. I created a website using share point. I am having a forecasting model developed using Time series algorithm in Sqlserver 2005. I need a web control to view the forecasting model, I created. Plz suggest me any viewer like DataAnalyzer, to view ...more >>

I need to find out from a database of more than 100 tables, which fields in each of the tables are most commonly used. Any ideas the best way to get this done??...more >>

Hello all, My Name is Aric Katz and i am working AT Rafael (Israel), that is an aero-space and defense company, as a head developer on project management systems parallel to my job I am working on my PhD and I am trying to implement some mining models to figure out the trends of arrivals to a ho...more >>

Hi all! I am about to create a procedure which will create tables with dynamically specified tablenames. Something like this DECLARE tname CHAR(30); SET tname = "1233321"; #or any string function CREATE TABLE tname ( #columns cpecification ); But it doesn't works.... How...more >>

Can I build and use the last tutorial plugin using Visual C++ 2005 Express, Windows XP SP2, Windows® Server 2003 SP1 Platform SDK and SQL Server 2005 Trial? claudio I'm asking because I received several error messages while compiling the last tutorial. The 9 error and 4 warning messages a...more >>

I have a problem when starting the Service "Sql Server Browser", i don't know why, no message is delivred.. it has the status "starting.." in the MMC (services) Now i'm planing to use Sql Server 2000 if it seems stable for Data Mining.. Can you suggest me something.. Thanks guys!...more >>

Clustered on sales: Key Sales cid Expression 21 1200 Cluster 1 0.91724288800409981 17 1160 Cluster 1 0.9631687827044676 12 1110 Cluster 1 0.95116688556423279 22 1210 Cluster 1 0.88498109470561914 20 1190 Cluster 1 ...more >>

Hi, I am working in Share point service now. I created a website using share point. I worked in mining algorithms in sqlserevr 2005. I am able to view scorecard, BIp in my website. I am having a forecasting model developed using Time series algorithm in Sqlserver 2005. I need a web control...more >>

How is it with plug-in algorithms in sql server 2005 and managed code (C#.NET, VB.NET,...). Will be somewhwere in the future possible to write plug-in algorithms using one of these languages?...more >>

Hello, I´ve got a few questions about the clustering algorithms: 1. How does the clustering algorithms treat textual attributes? I.e. first column name: test and the following 4 values are used in this column: private, public, legal, NULL second column name: example and it contains 10 t...more >>

comment on the use of statistics in Data Mining?...more >>

I can pull the 1st record of someone with 1 or more history records in MS Access2000, but can't figure out the stmt to do it in SQL2000. In Access it's: --------------------------------------------------------------------------- SELECT dbo_vw_dip_history_expiration_DESC.Dip_Key, First(dbo...more >>

Hi everyone... I have to order a list of items in SQL 2000, but want to put the 3 top sold items on top, all all others after them. I'd find out the break number easily (400 in the example). It'd be two groups of description ordered items, as in : 'All about eve' (810 units sold) 'Beginer...more >>

If I have a classification problem where 10 % of my customers churn and 90 do not churn, should I build traing sets for my models that reflect this reality? Or is it best to give my model a training set with 50 % of each cases. Will this give my model enough information so that it becomes as robust ...more >>

Is there a way to change the X- and Y axes in a lift chart? Does the lift chart show a cumulative performance of a model? Some tools like SAS order the data by probability, so that the lift chart starts with a line that goes up quite quickly. Can I order my data in SQL2005 so that the lift chart...more >>

Can I build the last tutorial plugin using Visual C++ 2005 Express, Windows 2000 adv srv SP4 and Windows® Server 2003 SP1 Platform SDK? I'm asking because I received several error messages while compiling the last tutorial. thanks claudio...more >>

I'm a newbie to both data mining generally and Sql Server BI in particular. I've played with the Linear Regression and Decision Tree algorithms a fair amount, but I have a question. I've created a test database with both a discrete and continuous attribute. The continuous attribute runs linea...more >>

I'm a newbie to both data mining generally and Sql Server BI in particular. I've played with the Linear Regression and Decision Tree algorithms a fair amount, but I have a question. I've created a test database with both a discrete and continuous attribute. The continuous attribute runs linea...more >>

I'm a newbie to both data mining generally and Sql Server BI in particular. I've played with the Linear Regression and Decision Tree algorithms a fair amount, but I have a question. I've created a test database with both a discrete and continuous attribute. The continuous attribute runs li...more >>

Hello there I've build program that needs to update data, in very complex way, so i had to use cursor for use it. The cursor works fine. But i need also to update the current record of the cursor Is there a way to do that? -- øåòé âåìãäîø òúéã äðãñú úåëðä èì' 03-5611606 ôìà' 050-7...more >>

Hi Everybody, I have a problem with convincing my coworker on using foreign keys in database. He doesn't want to use foreign keys. His arguments are: They're not nesessary as long as you add correct data in the tables. And the other is it gives problem when he delete data. He have to delete ...more >>

I would like to run descriptive statistics including frequencies, mean/median, outliers etc as a part of Data quality. I am not sure how to do that in Business Intelligence Development studio. Any help is highly appreciated...more >>

Hello there I have documentation Program as part of client data. In the program each user can store files for each client. The files are mostly TIFF, and in some times PDF, or XLS, DOC. Today i store the files in the server. However, in some cases there are problems with that. I've hea...more >>

Hi! I am trying to create more named calculations in a single data source view using AMO. In Visual Studio Analysis services data source view can contain tables and views and it is also possible to manually create named calculations. I tried to do the same using AMO (C#). I need this for my appl...more >>

Hi, I'm running the time series algorithm on the "Adventure-Works" Cube (specifically on dimension "Product" key "Subcategory", time dimension "Date" key "Time Key", measure "Internet Sales Amount"). I'm getting in many cases standard deviation "1". This is a suspicious value. Does any one know ...more >>

Hi, Is there any way to have multiple dimensions as cases for the time series algorithm? For example, you can have both "Customer" and "Product" dimensions as cases for the time series algorithm, so you'd get, for example, the time series results of the customers in "Washington" buying product cat...more >>

Errors in the back-end database access module. OLE DB was unable to convert a value to the data type requested for column 9. Errors in the OLAP storage engine: An error occurred while processing the 'Suppliers Fact' partition of the 'Suppliers Fact' measure group for the 'Suppliers Zara Cube' cube f...more >>

> > I am new to time series, > I trying to build a time series model on real estate search data. > I have basically built a mining structure with a datetime keyTime and StateCode which a text as Key > > rest of the fields are input/Predict > > Below are part of the errors given below. Kin...more >>

Hi , I am just starting to use the SQL Server 2000 Analysis Services. I have created a data source but i did not save the password as i was "told" by the system that "it's unsafe as the password stored will be unencrypted" However, when i tried to create a cube , it says login failed but th...more >>

Hi, Is it only possible to execute SELECT DMX statements from SQL via 'OPENQUERY'? I would like to do things like this; SELECT * FROM OPENQUERY(ASLOCAL, 'DROP Mining Structure sGLDetCostDebet') But I get this error message; "The OLE DB provider "MSOLAP.3" for linked server "ASLOCAL" in...more >>

Hi, Is it possible in someway to execute some DMX statement against a trained model and recive a "score" or a measure, or anything, that describes how well the model will perform predicting? I would like to be able to compare many models using code and DMX, /Erik...more >>

Are there any examples, information to build a SSIS package to process the cubes/mining models ?...more >>

Hi! I am creating mining structures and mining models using DMX language. First I create Mining model, for example: CREATE MINING MODEL [myModel] ( list of attributes, content types, data types...) USING SomeAlgorithm (AlgParameters) It also creates a MINING STRUCTURE called MyModel_Structu...more >>

Hi, Are there any provisions/methods for performing Leave-One-Out N-Fold cross validation of mining models? Say I do not have enough observations to create separate Training & Test sets. Therefore, to get a good idea of the error rate of my classifier, I may want/wish to hold out 10 observations,...more >>

I've built a cube with a numerical dimension in SQL 2000 analysis services. When I add that dimension as a column, it sorts as follows 1 10 100 2 20 instead of 1 2 10 20 100 I've tried doing a sort in Excel 2003 and 2000, even setting the type as Number. In Analysis servi...more >>

Platform: SQL Server 2005 Analysis Services on W2K3 While creating regular databases, I know how to change the storage location of database files. By default SSAS2005 points "C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data" I can see this when I right-click SSAS Database and view ...more >>

Got the following error while creating Time Dimension. Using W2K3, SQL Server 2005, Visual Studio 2005. Source database and target SSAS Database are all on my local workstation. Unlike treditional Visual Studio projects, I do not see add references option for Analysis Services Projects. Wi...more >>

Hi, What is the easiest way of getting the result of a prediction query saved into a table using only SQL? I want to build a normal database stored procedure, that executes a DMX statement, and saves the result into a table. /Erik...more >>

In practice is there any guidelines about using data normalization. Non of the MS documentation mentions anything about this topic, but in some literature, it says it is commonly effective in helping the model. Is normallization commonly used in industry?...more >>

Hi there, I'm still new to this DM thing (I'm running on SQL2000). I've tried to follow the tutorial, but odd things happen. E.g. when I try to save the cube after some changes, it comes up with an error stating that the object / database is read-only. Also, after exiting AS and then opening it up ...more >>

Every time I try to do anything even to the tutorial db's, I get an error saying that I cannot save because the database or object is read-only. Also, I've added my own db and a datasource, but it does not save my dimensions or anything, and I cannot connect via the datasource because of the s...more >>

Hi! Where can I find more details about Microsoft Data mining Algorithms? For example I would like to know how the Time series algorithm works... Thank you...more >>

Dear all, I would like to have some feedback on a few questions regarding finding anomalities and strange transactions in a dataset. I have a very simple dataset consisting of three discrete attributes and one continuous value, and the transaction date like this: TransID Date Attribute1 Att...more >>

Hi, I've implemented a time series algorithm over an OLAP cube using the "SQL Server BI Dev Studio". Using the "Data Mining Wizard" I've managed only to make a mining structure WITH nested-tables, although I've seen DMX examples of creating a mining-structure for time-series WITHOUT nested-table...more >>

I have been requested to represent the results of a Neural Nets and Naive Bayes models in the R2, ROC format. Is there any way to derive a number that would closely represent a R2 regression coeficient? Thanks, Peter...more >>

Hello! I installed OLE DB for DM and Data Mining Viewer Controls and add the reference to Microsoft.AnalysisService.Viewers.dll files, also in toolbox so i can drag Data Mining Viewer Controls on my Windows form. I have a problem how to load data into Viewers (for example TreeViewer Control)in C...more >>

> > Hi, > > I'm creating the forecasting model in the Data Mining > Tutorial (page 46). I have processed the model and > the "Decision Tree" view works fine. > > When I click the "Charts"-tab (page 53) I get a blank > chart even though several time series are selected in the > drop-...more >>

Hello, I would like to know what is the meaning (and how is computing) the field "Favors" into the Clustering Viewer (last panel). I don't understand the meaning of these values. Thank you in advance Victor ...more >>

Hi, Is it possible to do Data Mining in SQL Server 2000, I have seen demos for SQL Server 2005. If it is possible in SQL Server 2000, can anyone post resource links for the same. thanks Kiran...more >>

I am trying to use run the statement below and Am getting the error: ## Parser: The statement dialect could not be resolved due to ambiguity. ## Error seems to be on the Case when End statement. Any ideas why? Thanks, Andrew #### SELECT t.[HIC], [Admits_NB].[B Mths6], t...more >>