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


Post New Web Links

How Does the Association Model Predict the Products for Individual Customers?

Posted By:      Posted Date: October 13, 2010    Points: 0   Category :Sql Server
 

Dear All,

I have built an Association Model , now i am applying this model to the same data on which the model is built.

For many of the customers there is no products getting suggested , for few customers products are getting suggested, Please let me know how the model is suggesting products for few and nothing for most of the customers.

 

Thanks in Advance




View Complete Post


More Related Resource Links

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

Find individual customers how have not ordered a product

  
I need to find any and all customers who have not ordered a product or products. For example, If I have 5 products, I need to know who did not order which products? I have 2 tables: OG table with fields: Line #, Prod Nbr, Desc and Price and Orders table with fields CustName, Cust#, Prod Nbr QtyShipped I am not an SQL expert. Thank you very much for any help you can provide.

Extracting Association Rules from Data Mining Model

  
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

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

 


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.


Model(s) do not predict at all

  

Hello,

 

I'm going through the sample excel provided with Data Mining addin for Excel.

 

I created a new data structure from "Source Data". I added new data model, Decision trees (does not really matter which, neither works) to predict BikeBuyer. I click Classification Matrix against the internal test data, and the results show that it does not predict "Yes" for *ANY* row.

 

What am I doing wrong?


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.

Edit GridView Individual Cells in ASP.NET

  
The ASP.NET GridView allows for a row of data to be edited by setting the EditIndex property of the GridView, placing the entire row in edit mode.

You may not want the entire row in edit mode if you are using DropDownList controls for several columns in the EditItemTemplate. If each DropDownList has many options then loading them all at once may result in a sluggish page. Also, if your data structure is more like a 2 dimensional array rather than a set of rows, you may want to edit each cell individually.

Here I will demonstrate how to achieve this and also how to deal with event validation without disabling it.

Model View Controller (MVC) for ASP.NET

  
Model View Controller (MVC) architectures, immediately wonder how the MVC pattern can be applied in an ASP.NET world. This article will demonstrate how the MVC pattern can be applied to an ASP.NET web application and still maintain the basic Microsoft supplied architecture.

Edit Individual GridView Cells in ASP.NET

  
The ASP.NET GridView allows for a row of data to be edited by setting the EditIndex property of the GridView, placing the entire row in edit mode.

You may not want the entire row in edit mode if you are using DropDownList controls for several columns in the EditItemTemplate. If each DropDownList has many options, then loading them all at once may result in a sluggish page. Also, if your data structure is more like a 2 dimensional array rather than a set of rows, you may want to edit each cell individually.

Dynamic Systems Development Model (DSDM) Methodology

  
The Dynamic Systems Development Model was developed in the U.K. in the mid-1990s. It is the evolution of rapid application development (RAD) practices. DSDM boasts the best-supported training and documentation of any of the agile software development techniques, at least in Europe. DSDM favors the philosophy that nothing is built perfectly the first time and looks to software development as an exploratory endeavor.

Overview of SharePoint Object Model

  
SharePoint offers a set of structured server-side objects those are widely used to program SharePoint Applications. These objects are hierarchically arranged and you can drill down through the object hierarchy to obtain the object that contains the components of SharePoint Application you need to use in your code.

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.

'Model' cannot be declared in this scope

  

I have a complex partial view (ugly stuff), the view page has this line:- 

<% Html.RenderPartial("PartialIndicatorWeighting", indicator);%>
and inside the ugly partial view I have this,
<td><%: Model.Active %><%: Html.CheckBoxFor(Model => Model.Active)%></td>
I'm trying to display a list of checboxes to show if the item is active or not, I get the following error:-
 
A local variable named 'Model' cannot be 

lossing focus from model pop up window controls

  

hi i using a model pop up window with some textbox but when i click on textbox of model pop up focus move to back to page textbox control plz help me 


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