.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Extracting Association Rules from Data Mining Model

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
 
Hi I have succesfully created a Data Mining Model using the Association Model. I have deployed and processed it. I need to extract all the rules that is generated by the model. I know that you normally query the model using DMX prediction queries, but in this case I need to extract the rules to a separate table for further processing. I have tried the following approaches unsuccessfully: 1. Linked server in MSSQL Management Studio. DMX query using OpenQuery. The DMX query looks like this: SELECT FLATTENED NODE_CAPTION, NODE_SUPPORT, NODE_PROBABILITY, MSOLAP_NODE_SCORE FROM DataMiningModel.CONTENT WHERE NODE_TYPE = 8   On small models this method works. On larger models with many rules I receive an exception: "XML for Analysis parser: The XML for Analysis request timed out" before it was completed This always happens after 70min. I might have missed a timeout option? 2. Using SSIS to run the same DMX query as above. The method is presented here: http://www.sqlservercentral.com/articles/MDX/64697/ This method works on small models. On larger models that did not work with method 1, it return rules. The number of rules returned is sometimes different for the same package run multiple times. For the largest models it simply returns 0 rules. I suspect that the same XML Parser error happens under the hood of SSIS. I'm currently stuck, and need some inp


View Complete Post


More Related Resource Links

Association rules dimension error caused by setting the model algorithm

  

Hi,

I got this error meassage when I wanted to process a mined cube:

"Error (Data mining): An error occurred while the 'Bon_DMDim' data mining dimension with the 'Bon' source mining model was being processed. The algorithm of the source model returned data mining dimension content information that is not valid."

Before processing I modified only one algorithm parameter in the Association Mining model properties (AlgorithmParameters):

MINIMUM_SUPPORT = 10 (Default 0.0)

I need to have this adjustment for getting rules...

If I set back this field to 0 or empty, then the processing ends up with no error messages (and I would not have mined rules...).

I also get this message, if I use numbers between 0 and 1 (as a percentage).

How can I build a usable (but with adjusted algorithm parameter) mined dimension and apply it in an OLAP cube?

Thank you and BR,

Peter

 


Optimizing Data Mining processing time for a Time Series model in SQL Server 2008 R2

  

Does anyone have any references around optimizing the initial processing time for a data mining model? Books, blogs, etc. I have the Wiley “Data Mining with SQL Server 2008” book, and while I’ve learned a lot from it, it doesn’t seem to cover much around trouble shooting things like processing time. I also have a few other books that have a chapter or two on data mining, but again just basic “here’s what it is and how to set it up”, nothing that quite covers trouble shooting or optimization. I’ve also checked out the various Data Mining blogs/sites.

 

I’ve got a Microsoft Time Series model I’m basing on a Cube. Very simple, trying to forecast sales. I have one dimension which is the list of products (about 1600), a second which is the time dimension, finally the measure is daily sales figures for each, about 3.2 million rows in total. On a brand new server, with two quad core processors and 16 gig of ram it took 40 hours to process. Seems rather high?

Error While Applying a Data on Association Model Built

  

Dear All,

I  have built an association model containing arnd 800 transactions, now i am trying to apply this model on data containing 200 transactions (here each transaction can contain huge products which might have not been present while building the model)   using the query which i get from mining model prediction but i am getting the following error while parsing in sql server management studio as well in  mining model prediction (when i click on the result)

Executing the query ...

Parser: The end of the input was reached.

Execution complete


How to get all the rules of an association model using "CALL System.Microsoft.AnalysisServices.Syste

  

Dear All,

I am using sql server analysis services to build an association model, once the model is built i am using "CALL System.Microsoft.AnalysisServices.System.DataMining.AssociationRules.GetRules"  procedure to get support,importance,probability for a rule  by passing the name of a model (1 st parametre), but this procedure can retreive only max of 2000 rules though there are more than this depending on the sorting condition( 4 th parametre) specified in the above procedure.

Is it possible to get all the rules of a model using the above procedure?

If not pls suggest some alternative to get all rules of a model with support,probability and importance.

Thanks in Advance.


How to get all the rules of an association model using "CALL System.Microsoft.AnalysisServices.Syste

  

Dear All,

I am using sql server analysis services to build an association model, once the model is built i am using "CALL System.Microsoft.AnalysisServices.System.DataMining.AssociationRules.GetRules"  procedure to get support,importance,probability for a rule  by passing the name of a model (1 st parametre), but this procedure can retreive only max of 2000 rules though there are more than this depending on the sorting condition( 4 th parametre) specified in the above procedure.

Is it possible to get all the rules of a model using the above procedure?

If not pls suggest some alternative to get all rules of a model with support,probability and importance.

Thanks in Advance.


Cannot get recommendations after querying an association rules model for multiple customers

  
To carry out this data mining task, I am using the Data Mining(DM) add-in of Excel 2007, 
where one has to make use of SQL Analysis Server in order to utilize the add-in.
Basically, I have a three-column dataset: CustomerID,Product,Transaction. These are the steps I am following:
1. Build an Association Rules(AR) Model.
2. Query the AR Model with new data and obtain a recommended product.
Right now, if I supply an input of Products "A","B","C" for "Customer1" I get the recommendation e.g. product "D".
This is the DMX query I am using:
##############################################################################################################
SELECT
PredictAssociation([Associate ProductNo].[ProductNo_Table],INCLUDE_STATISTICS,5) AS [Output 1]  
FROM
[Associate ItemNo]
NATURAL PREDICTION JOIN SHAPE
{@InputRowset } APPEND ( { @InputRowset1 } RELATE [SessionNo] TO [SessionNo] ) AS [ProductNo_Table] AS
InputRowset = Microsoft.SqlServer.DataMining.Office.Excel.ExcelDataReader
InputRowset1 = Microsoft.SqlServer.Data

Binding WPF Controls to an Entity Data Model

  
In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Binding WPF Controls to an Entity Data Model

  
In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Input Validation: Enforcing Complex Business Data Rules with WPF

  

Windows Presentation Foundation has a rich data binding system that includes flexible support for business data validation. We take a look at implementing some complex data input validation scenarios that include customized data errors for users.

Brian Noyes

MSDN Magazine June 2010


Hierarchy ID: Model Your Data Hierarchies With SQL Server 2008

  

Here we explain how the new hierarchyID data type in SQL Server 2008 helps solve some of the problems in modeling and querying hierarchical information.

Kent Tegels

MSDN Magazine September 2008


Data Points: Designing an Entity Data Model

  

With the Entity Framework, developers are given more flexibility by being able to design around a conceptual model rather than a relational data model. To get started, you need to know how to design an Entity Data Model. John Papa walks you through that process.

John Papa

MSDN Magazine February 2008


C++ Rules: Power Your App with the Programming Model and Compiler Optimizations of Visual C++

  

Many programmers think that C++ gets good performance because it generates native code, but even if your code is completely managed you'll still get superior performance. In Visual Studio 2005, the C++ syntax itself has been greatly improved to make it faster to write. In addition, a flexible language framework is provided for interacting with the common language runtime (CLR) to write high-performance programs. Read about it here.

Kang Su Gatlin

MSDN Magazine January 2005


SQL Server 2005: Unearth the New Data Mining Features of Analysis Services 2005

  

In SQL Server 2005 Analysis Services you'll find new algorithms, enhancements to existing algorithms, and more than a dozen added visualizations to help you get a handle on your data relationships. Plus, enhancements to the Data Mining Extensions to SQL along with OLAP, DTS, and Reporting Services integration make it possible to create a new breed of intelligent apps with embedded data mining technology. Here the author explains it all.

Jamie MacLennan

MSDN Magazine September 2004


Entity Data Model and database view returning the same columns as there are in a table

  

When adding a stored procedure into the Entity Data Model I can select whether the procedure returns a scalar, a (new) complex type or one of the entity types I already defined. 

How do I do something similar for a view?


I mean assuming I have a view like this

CREATE VIEW FilteredFoos as SELECT Foo.* FROM Foo join ... WHERE ...

(that is a view that implements some involved filtering, but returns all columns from one table) how do I add it to the project so that I can use the entity set, but get the Foo objects, not some new FilteredFoo objects.


var foos = myDB.FilteredFoos.Include("Bar").ToList();

foreach (Foo foo in foos) { ...


Thanks, Jenda


The report cannot be opened because the data source associated with it is not a report model.

  
hi,

i tried to open a report i created in sql business intelligence development studio in the report builder in wss3 and it gave me this error:

Microsoft.ReportingServices.ReportBuilder.ReportModel.Report: The report 'http://servername:port#/Reports/report.rdl' cannot be opened because the data source 'http://servername:port#/DataSource Library/datasource.rsds' associated with it is not a report model.

This report was not created in Report Builder. Try opening this report in Report Designer instead.

can i fix this so i can open my reports in report builder?

thnx

How do you create an association between two different data sources in BDC web parts?

  

Hi,

I have a SQL Server database with the customer details and an authenticated web service providing contact details of the selected customer.  How do i connect them using web part connections to retrieve and display the data.

Or is it possible to create a Primary key-Foreign Key relationship between two tables in different databases with a common column?

Thanks

Senthil


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend