Where Can I Store Datamining Models
Jan 25, 2007I am using the Excel 2007 data mining add-in, and don't have write perms on the Analysis Services server. Can I store datamining models in an alternate location?
View 1 Replies
ADVERTISEMENT
Where Can I Store The Mining Results From Mining Models In SQL Server 2005 Data Mining Engine?
Apr 26, 2006Hi, all here,
I am wondering where can I store my mining results in data mining engine? For example, I got mining results like accuracy chart, decision trees, and other formats of results based on different mining algorithms I used for my data mining, so where can I actually store the results for reporting service use later? Is it possible to do that in SQL Server 2005?
Thanks a lot for any help and guidance in advance.
DataMining
Oct 17, 2006i create a model mining to know percent of product, which is like more by customer is have percent biger than other products that is don't like by customer.
i use DTS to get result to sql server.
select flattened
predict([modelName].[tablePredict],Include_statistic)
from
[modelName]
prediction join
.....
i have result with a table A in sql server:
productid $support ... $adjustedprobability
1 0.0 ...
1 0.0 ...
1 63.3 .....
how can i write in Dts so that table A not have record with value $support=0.0
- second: percent people like that product is knowned by $adjustedprobability or $support and value small or big
Datamining
Oct 16, 2007Can datamining rules are implemented in visual c++ to develop an application?
DataMining Problems
Sep 26, 2007Hello Experts,
I€™ve got a logical problem. I€™m just a newbie in this theme.
I build a cube with Analysis Services. It works and I can brows the cube.
For Example this could be a possible result:
Color
Red Blue Black Yellow
Auto brand
Opel 1 2
VW 2 1 4
Mercedes 1 1 2 2
The count shows us how much cars were stolen.
Now I try to build a Data Mining structure that shows me the behavior between the auto brand and the color. (To build the report I used Excel 2007 and the Data Mining AddIn)
After build the Mining Structure the Colum name are 1, 2 or 4 (just the counts).
To search for a better solution I tried to build the report manual. (Now it looked like that)
Auto Brand Collor stolen
Opel Red no
Opel Blue yes
Opel Black yes
Opel Yellow no
VW Red yes
VW Blue yes
VW Black no
VW Yellow yes
Mercedes Red yes
Mercedes Blue yes
Mercedes Black yes
Mercedes Yellow yes
Now the Column names are correct and the Data Mining structure is more understandable.
But the second report you can€™t build with a cube, because the Measures were just numeric.
My Questions:
- Where is my error?
- How do you build a Data Mining?
- Is there somewhere a tutorial could help me (I just founded tutorials that explains the different works of the different Data Mining Models)
- How would you build this problem in a Mining Structure?
Hope I don€™t forget some information and hear you soon
Yours sincerely,
Alex
DATAMINING Tasks
Feb 8, 2007what are the different data mining tasks...........
View 4 Replies View RelatedDatamining For Ntext
Aug 18, 2006Is there any way to datamine using ntext? I'm trying to run some BI on some email messages -- seeing if it can accurately classify email into the proper folder. Currently, I get complains that ntext isn't comparable.
Is this scenario supported?
Telecomunication Datamining
Apr 19, 2007Hi.
I am trying to predict the churn of a client for a cell phone company.
The thing is that the louse of many clients for the company incurred in hi level o churn and this is a problem; we don€™t want that to happened. So it would be helpful if I could determinate pre behavior of a client that is going to left the service.
So I put under analysis the next€™s values: (month of traffic,Minutes, Discount $us, antiqued of the client , time of payment, Month of Subscribe, flag (leave, stay))
Month that the client used the service.
So Minutes is the time that the client uses the service by mouth.
Discount, is the mouth of money that€™s been discounted to the client for any reason.
Antique, is the time in months that the client has the service.
Time of payment, is the time in months that the client pay ones has the bill.
Month of subscribe, means the date that the client subscribe the service.
Flag. The flag means if the client with this values stay whit the service or leave the service in a specific period of the year lest say June.
So all looks good, but this is the problem, just like I€™m trying to predict if the client stays or leaves, the size of the clients that leave the service is so small compared with the clients that stays (5 - 95) that the decision tree return only one node and says Stay 95% lease 5%, just like none of the values analyzed would make a difference. Thas why, I can€™t predict the louse of clients all do I have the all information about the clients that left the service.
Any idea, what I€™m doing wrong, or may be I need other information o less information.
Or maybe I should make my analysis in a different way.
What Are The DATAMINING Tools ?
Feb 8, 2007i coudnt find relevant topics related to the dataminig tools...........someone pls help
View 1 Replies View RelatedQuestion Regarding Scenario On DataMining
Jan 22, 2007Hi to all
I want to know how achieve the following scenario, I will highly encourage if anyone knows the solution please mention it through steps. The scenario is I have a table named €śCreditCardTable €? with following schema , the table is pretty much what one expect from a simple credit card application that will present form to user who fills the application of credit card and data going to be filled into the table. Later an analyst will review the data and will be accepting or rejecting the Credit Card along with some other fields as seen in the schema.
-----Schema --------
CustomerName Bigint
Age int
DOB DateTime
LimitAssigned Bigint
Analystname varchar
Salary varchar
Gender bit
Qualification varchar
Country varchar
JobTitle varchar
MartialStatus varchar
IsApproved bit
IsDeclined bit
Now what I want is that by using Microsoft Detaining Features after giving it the data t should purpose analyst the solution i-e (reject / approve ) the credit card application . Now I gather than there are many algorithms in SQL Server 2005 Analysis Services that can be used (Decision Trees , Association Rules ) , I research on the two I just mentioned and want to use Decision Tree for this purpose , but there is a bottleneck that is mentioned in a book named €śDetaining with SQL Server 2005 by Wiely€?. It says that the rules that the Decision Tree will build and use are not available to end user in contrast to Association Rule algorithm which provide the rules. I essentially need the rules by which the decision has been made. Please I really need help on these issue to summarize I need the following
1) With the table €śCreditCardTable€? I need to perform Decision Trees and Association Rules Algorithm on it , please provide me steps to do so , moreover please also mention how to specify Query (DMX I think) to get the final result i-e approve or reject based on the data .
2) The rules on basis of which the Algorithm makes it decision, please provide insights on how to achieve this by both Decision Trees and Association Rules Algorithm.
I really need an urgent reply on this , you can also email me at razi_rais@yahoo.com , thanks for your feedback.
Do We Have DataMining Viewer As Web Control??
Feb 1, 2008
The mining model viewer which comes with DM-Add in's works fine with Excel and also in Windows applications with the following code.
MIningModelViewerControl viewer = null;
MiningModel model=null;
MiningService service=null;
conn.ConnectionString = ConnectionString;
conn.Open();
model = conn.MiningModels[modelName];
service=conn.MiningServices[model.Algorithm];
if (services.ViewerType == "Microsoft_Cluster_Viewer")
viewer = new ClusterViewer();
else if (services.ViewerType =="Microsoft_Tree_Viewer")
viewer = new TreeViewer();
else if (services.ViewerType == "Microsoft_TimeSeries_Viewer")
viewer = new TimeSeriesViewer();
viewer.connectionString=ConnectionString;
viewer.miningmodelname=modename;
viewer.Dock = DockStyle.Fill;
panel.controls.add(viewer);
viewer.LoadViewerData(null);
But i need that as a web contorl to integrate with our existing web application but the viewer control is not working.
So is there another web control for viewing data mining models.
Regards,
Swarna
Datamining A Olap Cube
Aug 24, 2007I'm new to datamining and have gather some knowledge by following the tutorial that comes with sql server 2005.
I have following created a association mining model and tested it by using various DMX queries. I works quite satisfactory.
But I would like to use this mining model on a cube. Ie a calculated measure that would show top 1 recommendation for my customer portfolio.
My knowlede reaches to the extent that you need to feed data by using the OpenQuery or OpenRowset queries.
I would like to "stick" my model to the cube on some way and the extract values in the same manner as filtering criterias in stead of manually generating DMX queries.
I have googled a bit and searched MSDN without luck. Maybe I'm looking at this all wrong.
Is this possible?
Regards Bergur
Datamining Viewer Client Problem
Nov 13, 2006Hello!
I am running a SQL Server 2005. I created the mining models from the tutorials. I can connect with the DataminingViewerClient directly on the SQL Server(i.e. to localhost), but when i try to connect to the Server from my other computer it is not working i always get connection faild and i should check that the server is running. I can connect to the Server with other programms but the viewer is not working. Any ideas what that could be?
A Problem With Processing A Datamining Structure
Jul 20, 2006Hello :
I have tried to process a datamining structure in SQL Server 2005 (Developer
Edition) but I receive these messages from Sql Server :
"Errors in the high-level relational engine. A connection could not be
made to the data source with the DataSourceID of 'Dbjao', Name of
'Dbjao'."
"Errors in the OLAP storage engine: An error occurred while the
dimension, with the ID of 'MCredito ~MC-Id', Name of 'MCredito ~MC-Id'
was being processed."
"Errors in the OLAP storage engine: An error occurred while the 'Class'
attribute of the 'MCredito ~MC-Id'
dimension from the 'CreditoAleman' database was being processed."
I generate this model from a relational table and can explore this
table
and build and deploy the project
But I receive these error message when I try to process the mining
structure
Do you have any idea which is the problem ?
Best Whish
Juan Alvarado
Datamining Advice On Choosing Mining Model
Nov 30, 2007
Hi--
I am a newbie to datamining, but have nearly a decade of solid database experience with the last 6 years in SQL Server 2000. We are moving our accounting system to SQL Server 2005 and I have been asked to explore the possibilities of mining an inventory table. I'd like to get some opinions prior to spending too much time potentially barking up the wrong tree!
We have an inventory table with approximately 10 million serialized records. Each row contains the serial number of the individual unit and its manufacturer/model designation. We have no control over the assigning of the serial numbers as they come from multiple manufacturers and some of the manufacturers correlate serial numbers to model and some don't.
My thought was to use a cluster model to try to predict the model of a new serial number as it is entered into the database. Is this thought feasibile? Is the mining model choice appropriate? If pointed in the right direction, I'm sure that I can run with this.
Thanks in advance-- Jim
Regarding DataMining In SQL Server 2005 Analysis Services
Jan 17, 2007Hi to all
I have a complex scenario , so first I want to ask out the feasibility of it . I think its better if I state the scenario and some one on this forum reply to it , I need to build an application (e.g credit card application , Loan Application etc ) that requires some approval from expert , what I firstly want is that I apply datamining on this data so that next time when I enter the data the result (approval or reject ) should be given by datamining tool , this I gather is poosible by using Analysis Services in SQL 2005 , but I also want the bases of that decision ( I mean the rules/some thing else that the Datamining created agaisnt the data entered ) , So can any one do any help on this , you can also reach me at razi_rais@yahoo.com . its preety much urgent so your prompt response is higly appreciated.
Thanks and Regards
Razi Bin Rais
How Can I Browse The Tree Graph In DataMining DecisionTrees By C# Coding ?
May 19, 2006I build my DataMining DecisionTrees in SQL Server 2005.
How can I get the tree graph in DataMining DecisionTrees by C# coding ?
Cannot Run Datamining Query Task In Standard Edition Of Integration Services
Nov 13, 2006Hi
We are using SQL Server 2005 Standard Edition. I have SSIS package which uses 'Data Mining Query Task'. I am using this task to run the predictions using the mining model I have deployed. When I run this SSIS package from IDE , everything is fine. But I deployed this SSIS to msdb, and when I right click on the package and run it from MSDB I get error message saying ,
'Cannot run this task in this edition of Integration Services. It requires higher level edition'.
Altimately we want to execute this SSIS from an API which is written in C#. Can you please suggest any workaround for doing so?
Thanks,
Vikas
Errors In Table Analysis Tools For Excel DataMining AddIn
Mar 2, 2007It's an error "The 'MINIMUM_DEPENDENCY_PROBABILITY' data mining parameter is not valid..." always I try to run Analyze Key Influencers Tool. How it's possible to fix it?
View 5 Replies View RelatedMicrosoft SQL Server 2005 Datamining Viewer Controls Feature Pack
Oct 24, 2006Hi,
I downloaeded "Microsoft SQL Server 2005 Datamining Viewer Controls" feature pack, and tried to run the dataminingviewerclient.exe.
When i view my local time series data mining model, It works well for single series model, but when i load a Microsoft time series model containing multiple data series, an unhandled exception occurs.
I post the error message below:
See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.AnalysisServices.Viewers.TimeSeriesViewer.PreprocessChartArrays(ArrayList rgPredicted, ArrayList rgActual, ArrayList rgDeviations)
at Microsoft.AnalysisServices.Viewers.TimeSeriesViewer.LoadChartSpace(MiningModel model)
at Microsoft.AnalysisServices.Viewers.TSCheckedListViewCombo.HandleChangesCommitted(Object sender, EventArgs ea)
at Microsoft.DataWarehouse.Controls.BaseControlComboBox.OnCommittedChanges(EventArgs e)
at Microsoft.DataWarehouse.Controls.BaseControlComboBox.SetSelection(String str, Object obj)
at Microsoft.AnalysisServices.Viewers.TimeSeriesViewer.InitializeCurrentlySelectedPage(Object context)
at Microsoft.AnalysisServices.Viewers.TreeViewer.viewerTabControl_SelectedIndexChanged(Object sender, EventArgs e)
at System.Windows.Forms.TabControl.OnSelectedIndexChanged(EventArgs e)
at System.Windows.Forms.TabControl.WmSelChange()
at System.Windows.Forms.TabControl.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///E:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
DataMiningViewerClient
Assembly Version: 1.0.2023.16746
Win32 Version: 1.0.2023.16746
CodeBase: file:///E:/Documents%20and%20Settings/admin/Desktop/Microsoft%20Download/DataMiningViewerClient/DataMiningViewerClient.exe
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
Microsoft.AnalysisServices.AdomdClient
Assembly Version: 9.0.242.0
Win32 Version: 9.00.2047.00
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/Microsoft.AnalysisServices.AdomdClient/9.0.242.0__89845dcd8080cc91/Microsoft.AnalysisServices.AdomdClient.dll
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///E:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
Microsoft.AnalysisServices.Viewers
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1186.00
CodeBase: file:///E:/Documents%20and%20Settings/admin/Desktop/Microsoft%20Download/DataMiningViewerClient/Microsoft.AnalysisServices.Viewers.DLL
----------------------------------------
Microsoft.DataWarehouse
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1186.00
CodeBase: file:///E:/Documents%20and%20Settings/admin/Desktop/Microsoft%20Download/DataMiningViewerClient/Microsoft.DataWarehouse.DLL
----------------------------------------
Microsoft.DataWarehouse.Interfaces
Assembly Version: 9.0.242.0
Win32 Version: 9.00.2047.00
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/Microsoft.DataWarehouse.Interfaces/9.0.242.0__89845dcd8080cc91/Microsoft.DataWarehouse.Interfaces.dll
----------------------------------------
Microsoft.AnalysisServices.Controls
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1186.00
CodeBase: file:///E:/Documents%20and%20Settings/admin/Desktop/Microsoft%20Download/DataMiningViewerClient/Microsoft.AnalysisServices.Controls.DLL
----------------------------------------
Microsoft.Office.Interop.Owc11
Assembly Version: 11.0.0.0
Win32 Version: 11.0.5530
CodeBase: file:///E:/WINDOWS/assembly/GAC/Microsoft.Office.Interop.Owc11/11.0.0.0__71e9bce111e9429c/Microsoft.Office.Interop.Owc11.dll
----------------------------------------
Microsoft.AnalysisServices.Graphing
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1186.00
CodeBase: file:///E:/Documents%20and%20Settings/admin/Desktop/Microsoft%20Download/DataMiningViewerClient/Microsoft.AnalysisServices.Graphing.DLL
----------------------------------------
MSDATASRC
Assembly Version: 7.0.3300.0
Win32 Version: 7.00.9466
CodeBase: file:///E:/WINDOWS/assembly/GAC/MSDATASRC/7.0.3300.0__b03f5f7f11d50a3a/MSDATASRC.dll
----------------------------------------
mscomctl
Assembly Version: 10.0.4504.0
Win32 Version: 10.0.4504
CodeBase: file:///E:/WINDOWS/assembly/GAC/mscomctl/10.0.4504.0__31bf3856ad364e35/mscomctl.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
Microsoft.AnalysisServices.OleDbDM
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1186.00
CodeBase: file:///E:/Documents%20and%20Settings/admin/Desktop/Microsoft%20Download/DataMiningViewerClient/Microsoft.AnalysisServices.OleDbDM.DLL
----------------------------------------
Microsoft.SqlServer.CustomControls
Assembly Version: 9.0.242.0
Win32 Version: 9.00.2047.00
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll
----------------------------------------
Microsoft.NetEnterpriseServers.ExceptionMessageBox
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///E:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///E:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.
For example:
<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>
When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.
***** end of error message***
Can someone help to figure out what went wrong? thx.
Implementaion Of Datamining And Design Aform For Showing The Result Of Prediction With Time Series
Nov 26, 2007 hi
i have aques tion about mining model and time series after predicting
how can i show the result of the prediction in the c# form
and why i cant use the all of the prediction function in the mining
model prediction for time series and how i can see the script of the
building mining model in the model because i can see just the wizard
of the model and how can i undrestand othe about time series formula
in the chart
thanks alot if answer me
Datamining Model Automatically Add Space To Field Name. Can't Use Prediction Join With Original Table
Aug 30, 2007Dear All,
I have a database table which has all the inputs, key and the result. In visual studio, I created a decision tree model which has exactly the same fields as in the table. However the visual studio automatically add space preceding the capital letters. As the field name in the Datamining model and those in the database table are slightly different. I cannot use NATURAL prediction join. Is there anyway to told the visual studio not to add the spaces in the variable names?
Thanks and regards,
Tony Chun Tung Siu
Need Help About Recovery Models
Jan 10, 2007Hi all ,
this is my first post here hope i will find help.
I'm facing problems in understanding some topics .. and i searched on the net but every time i read an article i find new things and topics.
i think i need just a good way to start from the following topics.
-recovery models (full,simple,..).
-fullback and differntial back up.
waiting for your help or even links to external articles may also help.
thanks in adavance
Recovery Models In SQL7.0
Jul 6, 2001Any one knows if the recovery models in SQL7.0 same as in SQL2000, if not the same do you know them and which one is the default.
Saad
Replication And Recovery Models
Apr 12, 2006Hi,
If I'm using a transactional replication and the publisher's recovery model is se to FULL, can the subscribers use simple recovery model?
Thanks.
Questions About Recovery Models
Dec 5, 2007Hello Everybody , I have Some questions and I am sure that this is the best place for them to not be questions any more.
Here are My Questions:
What is the difference between full recovery model and simple recovery model?
My database has an mdf file about 400mb and a log file about 5GB.
Is this caused because of full recovery model?
What can I do in order to make my log file smaller?
Which recovery Model Do you Suggest for Use and Why?
Thank you So Very Much
I sell my mother in law.Is anybody interested?
Web Site With Database Models
Jul 20, 2005Hi.Does anyone know any web site with common database models presented andexplained.Database models like calendar, adressbook, storehouse...Thnx in advance
View 1 Replies View RelatedRsItemNotFound For Report Models
Jun 6, 2007I have a Sharepoint integrated Reporting Services server. I have created Report models based on Data Sources. I then created Report Builder Reports to make some BI Charts and Graphs. They look great and work fine for a few days then all of a sudden I get a rsItemNotFound error saying it cannot find the Report Model which is clearly there.
An error has occurred during report processing. (rsProcessingAborted)
The item 'IT Reports/PWPDB_Prod_Model.smdl' cannot be found. (rsItemNotFound)
If I open the Report Model from Report Builder it loads the data fields, but also fails to run reports with the same error
If I try to regenerate the model from the library I get an error stating that the model needs to be a generated model.
The model specified must be a generated model.
(rsModelNotGenerated)
Even after rebooting all of the servers in the farm I get the same messages. I can regenerate a model from the data source and it doesn't work. I am seeing no errors in the logs of my app server at all regarding reporting services.
It looks as though I will have to de-integrate Reporting Services as it is not viable for a business critical application.
Views And Report Models
Apr 16, 2007Need a little help here. I would like to utilize the ad-hoc capabilities of Reporting Services to grant the users of one of my web apps the ability to create all sorts of crazy reports that I don't have to develop.
Basically, this web app is a flexible survey engine. My vision is to have the users select questions from a survey that they wish to generate statistics on. My application would create a view in the database that transposes the data into a tabular format. They would then get kicked over to the reporting services web client, where they can regenerate a report model, and then fire up report builder to create their crazy statiscal abomination. (Aren't users grand!)
This process sounds wonderful, but I'm not aware of any way to get the report model to regenerate and pickup any views. I can get it to pick up any new tables that are added as long as a primary key is created for them, but I want the automated dynamic data rendering that comes with a view. Hopefully, some of you out there have tried to do this already and have some ideas that may help me. Thanks!
Mining Models Accuracy
May 10, 2007Hello
I've created models with Decision Tree and Neural Network algorithms that predict continous target. But I don't know how to interpret scores that occure under scatter accuracy plot. How should I interpret scores under scatter accuracy plot?
How can I estimate occuracy of model created with Time Series? How can I compare accuracy of model created with Time Series with models created with Decision Trees and Neural Network algorithms?
Thanks in advance.
Create Database Models From XML Schema (.xsd)
Dec 19, 2006Hi .Net Guru’s,I have an urgent requirement for my project; the issue is mentioned below;Using .Net(C#/VB.Net) I need to generate/created Database objects from XML schemas.I don't have any sample xml schema file to give you. You just imagine you have a sample .xsd file and this .xsd file will be used to create database tables.Please let me know if you have any queries. Thanks,nick
View 1 Replies View RelatedKind Transaction Models In Sql Server
May 16, 2008hi help me as soon , i need know ,i get for my teacher
View 1 Replies View RelatedQuestion On Validation Of Mining Models
Jul 16, 2007Hi, guys,
Thanks for your kind attention.
Just want to make things perfectly work and make the most of our fantastic SQL Server 2005 Data Mining Engine. Can any of you here give me some super advices on the validation of the mining models. As we always see, the 3 aspects of a mining model are: Score, Population correct, and Predict Probability. So the question is: How can we combine these three aspects to best judge the mining models by being able to tell which model is the best one? And to what extent can we really trust these mining models?
These are very important before we can actually bring the models into work to convince other people who have no ideas what are going on with these models. Yes, we just want to convince them with the results of these models and make the most of them and best help them getting the most from their business operations etc.
By the way please can you explain a bit details on each of these aspects? Thanks again.
I am looking forward to hearing from you shortly and thanks bunch for your help.
With best regards,
Yours sincerely,