Recent update: 2008-3-21
102 byte By
guest at 2008-3-8
I have Text file that I want to import to my database How can i do it ? Thanks a lot (abs_absh)
Hi Guys, I kindly ask for your help with regards to my DM project. I am working on a project that is related to the field of agriculture and that has as an objective to find the "optimal values" of the operating conditions that affect the outcome (the amount of meat produced i.e. the ...
I am doing a data mining project using the census bureau data set. The data set is a pdf, so I saved it as a text file, I imported as a flat source file and am trying to create my data source? But am having trouble with this? Please help?
612 byte By
desny at 2008-3-5
I have some questions please help me: 1. Well,i have tried to download sql server 2000 and analysis manager service pack 4.But i didn't success yet.I don't know the reason why.When i download,there's a mesage that the download's success but when i tried to install or update using the ...
I have a large dataset of around 3 million records with accounting data for 2 years. Attributes are transaction amount (cont. / predict), account, cost centre, project, month and a few others. I want to predict any future transaction amount for a certain combination. For example; what will the ...
SQL Server Usability Enrollment Your opinions count. The SQL Server Design and Usability team invites you to spend a few hours with us and our products (SSMS, SSIS, SSAS, SSRS, BIDS and etc) and tell us what you think. We are interested in how you interact with the products. The ...
Hi, I'm new to SQL Server and data mining, so please forgive my ignorance... I'm working on a project which requires me to use the datamining provided by SQL Server 2005. I've a table for which i want to predict the values in a table (Encyclopedia) The table contains the following fields: ...
825 byte By
desny at 2008-2-27
I have read some sources about microsoft decision tree algorithm like in claude seidman book, paper about scalable classification over sql databases and paper about learning bayesian network. But i still don't understand and i still didn't get the point on how microsoft decision tree ...
428 byte By
-pk at 2008-2-26
Hi group,While playing around with the MSAS tool, i have tried creating the sequence cluster sample in 'Adventure Works DW' as suggested in the tutorial. Though i followed the steps given in the tutorial, I could not create the model. Deploying the model fails with an error saying "key ...
359 byte By
-pk at 2008-2-25
Hi group, I was trying to build a sequence clustering model in MSAS.I could deploy the model. Then while building the model, I end up getting an error with message "Key Sequence columns are not supported at the case level". Can some one tell me what it means and how i can avoid ...
hi, all When I want to add Microsoft.AnalysisServices.Viewers.MiningModelViewerControl to my web application, the following error appears: cannot convert from 'Microsoft.AnalysisServices.Viewers.MiningModelViewerControl' to 'System.Web.UI.Control' I want to use the MiningModelViewer in my ...
I have been dealing with this error in BI Studio under different circumstances. One way to create it, also the way that frustrates me most, is copying and pasting. I can copy and paste data sources, data source views from one project to another without any problem; but when it comes to cubes ...
I created a Neural Network model with AMO in C#. It seems that everything (including pre-processing) goes well until the final stage of processing (i.e. model training after retrieving all the data), then I consistently get the following error: Internal error: An unexpected error occurred (file ...
1170 byte By
desny at 2008-2-22
well, i;m doing a thesis about data mining right now.And i found some difficulties. In my thesis i use visual basic 6.0 and sql server 2000 database and sql server 2000 analysis service. For information i use DSO (Decision Support Objects in programming). I've read claude seidmann book about ...
We are be hosting a public web chat discussion on March 22nd 9:00 – 10:00 am PST about the March CTP of SP1. It is the customers’ opportunity to engage with the dev team and provide feedback and ask questions. Strong participation from customers will act as a motivator for stronger ...
are there good free data mining video tutorials for Sql server 2005 data mining. please if u know any such links please post it.
This is the error when i execute the code for the association algorithem. "Errors in the high-level relational engine. The data source view does not contain a definition for the 'receiptid' column in the 'receiptdesc' table or view.". Dim ds As New RelationalDataSource("miningas", ...
I am new to Data Mining I downloaded the SQL SERVER 2005 Evaluation Edition. <strong><u>Question: </u></strong> For Data Mining which Product Edition of VISUAL STUDIO 2005 i have to download ? ,
I've read in at least one book (and heard firsthand at the SQL Server launch event) that there's a plug-in framework for adding new algorithms to Data Mining. However, the book was apparently written against a Beta version, and the location it suggests for the plug-in sample code doesn't ...
This is the error when i execute the code for the association algorithem. "Errors in the high-level relational engine. The data source view does not contain a definition for the 'receiptid' column in the 'receiptdesc' table or view.". Dim ds As New RelationalDataSource("miningas", ...
If I create a view and then a mining structure run it everything works fine BUT if I then alter the view (e.g change a filter setting in a named query) or the actual contents of the database, the OLD contents persist. Using the view refresh says there are no changes (which is correct as I ...
Hi Guys, I kindly ask for your help with regards to my DM project. I am working on a project that is related to the field of agriculture and that has as an objective to find the "optimal values" of the operating conditions that affect the outcome (the amount of meat produced i.e. the ...
I am using using Decision Trees, Naive Bayes, and Neural Net to predict customer profitability. Unfortunately, none of these are able to make good predictions based on our data. How much improvement is to be gained by specifying in the mining model the distribution of the input variables ? ...
219 byte By
UllaH at 2008-2-15
Can anyone tell me, how the Business Ãntelligence Studio calculates the importance of a rule. I can't find the formula. I know some formulas, but the result in SQL Server is completly different. Thanks!
how can i filter rules in a dmx query ? NODE_CAPTION LIKE '%something%' doesn't seem to be recogenized by ssas.. help plzz
Hi, could anyone kindly let me know how to prevent the Decision Trees model from using value missing as a criterion to split trees? Thanks, hz
Can anyone update me on the status of the managed-code framework for plug-in algorithms? I've heard reports that it's "in the works" and "almost ready to release", and now I'm really anxious to get my hands on it!
59 byte By
Bogey1 at 2008-2-14
Are there any premade Databases out there for data mining?
303 byte By
fozia at 2008-2-14
hi my final project is on datamining for bank data but i need the help how to start it and develop a successful software . i also need help about how to devlop and implement the data warehousing and use the olap technology on it. please answer in detail ...
I am just starting into using the SQL 2005 tools and was trying to run my first model. I set up the Data sources and Data Source Views and Created a decision tree mining structure. The properties for the deployment have the server as (local) and the database name that is valid. I am running ...
I created a Neural Network model with AMO in C#. It seems that everything (including pre-processing) goes well until the final stage of processing (i.e. model training after retrieving all the data), then I consistently get the following error: Internal error: An unexpected error occurred (file ...
Is upgrading from CTP15 to Yukon RTM supported? Specifically, we have a large number of data mining models which take a long time to build, and don't want to have to rebuild them all. thanks, Jesse
Hello, There is a download in the Feature Pack For Microsoft SQL Server 2005 - November 2005 for the Microsoft SQL Server 2005 Datamining Viewer Controls. Unfortunately I cannot find a shred of documentation for said controls. It would be nice to know what their names are, where they are ...
if anyone knows the cost of SQL Server 2005 Standard Edition Licence then please reply
sql server 2000 support only 2 types of algorithm decision tree algorithm and cluster , if we have to add our own algorithm is that possible in sql server 2000?
I have noticed that for the prediction of MS Time Series, the number is usually absurdly large when the standard deviation is 1. I always get a bunch of them. Does anyone have any clue about what this means? ...
613 byte By
Nicol at 2008-2-8
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, profit as ...
1. I am using datetime as the Key Time column and if I leave the parameter Missing_Value_Substitution (MVS) blank, it complains there are missing values. I have stripped the data down to a single sample series which *definitely* has exactly 1 row with each month (e.g. from 2003-01-01, ...
923 byte By
Doriak at 2008-2-7
Hi, I am working with the 'Using SQL Server Data Mining" book, and am trying to deploy and process the 'MovieClick' example in chapter 3. Here is my problem: I am able to create the Data source, the source view, the data mining structure and data mining models (Decision trees and ...
Hello, I am using SQL Server 2005, and trying to load a mining model : microsoft association rules through a VB.net. When it is loading, this error msg displayed :"An error was encountered in the transport layer. The peer prematurely closed the connection."Any help is really ...
<span id="_ctl0_MainContent_PostFlatView"><span>Hi All Can anyone tell me how to do text mining using Analysis Servvices in sql server 2005 I have a some financial document in text format and i want to mine those Thnaks in advance Satish </span></span>
293 byte By
PaTaKi at 2008-2-6
Can't Run any DM Until Delete Lost Cube? Even if I start a new Project from scratch I get the <strong>same error</strong>, Even if in the new Project I press "start debug" before I create anything. There is no connection, no data source view, no ...
I (unsuccessfully) made a cube named, MSR TRANCHES. I can't find any trace of it anymore. However, I can't make a new Mining Structure because VS complains of: Error 1 File system error: Error opening file; \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services ...
after creating Analysis service projects using SQL server Business Intelligence Development Studio when the project is deployed it gives following error......... Error 1 The project could not be deployed to the 'Solversa-201\SQL2005' server because of the following connectivity problems : A ...
482 byte By
Nicol at 2008-2-5
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. My Question is:I am having a forecasting model developed using Time series algorithm in Sqlserver 2005.I need ...
Hi all, I'm trying to find an example on BI using SQL Server 2005. Ideally something that would allow me to analyze Customer and Product information like Sales per period, per product line, etc. Something really really standard that the user could query directly from Excel 2003. I'm sure such ...
Hello I'm searching for good ideas how to generate testdata from existing data. e.g. i've a table "tabPerson" with PersonId, LastName, FirstName. Know i want to produce testdata using the existing data, but i must not be able to reproduce the original ones. Are there some good ideas ...
Hello, I am new to SQL Server and I am trying to use BI Dev Studsio for a data mining project.The first problem I get is that I cannot see the SQL Server in the BI. I am trying to create a data source and I cannot connect to the server at all. Does anybody have an idea what could be going ...
Is there any way to use SQL Server 2005 Reporting services to get a report of a mining model schema? I can't even figure out how to connect to an analysis services server using reporting services.
I would like to use SQL Server 2005 data mining to look at some engineering problems. In order to really do that, I would like to see some reference material on how the different algorithms work. Does anyone know where I could find some? I have looked hard thru BOL and cant find any there. ...