.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

Association rules dimension error caused by setting the model algorithm

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server
 

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

 




View Complete Post


More Related Resource Links

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

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

Error while setting up application on Win7 using Visual Studio.NET 2003

  

Hi All,

Getting the below error while setting up application on Win 7 using visual studio.NET 2003.

Error:

cannot find the components for communiacting with the front page server extensions...

 

I understand by the error, i need to install Front page server extension, but not able to figure how to install using IIS 7.5.

I had XP machine with IIS 5.1, able to find the option.

 

Need your help in resolving this.

 

Thanks

Abdul 


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


Association creation error

  

In the dbml Designer surface in VS2010, I am associating two views from a database which I am only granted for View access. 

The View1 has 
  Site (smallint, not null)
  LocationID (int, not null)

The View2 has
  Site (int, not null)
  LocationID (int, not null)

Due to the incompatible types between this two, the association can not be created.  Is there other way to create the association, such as cast(View1.Site as int) in the assocation?


Error from entity Connection setting in webconfig

  
hi every one , while building my Asp.net Mvc solution i am getting following error: "The type or namespace name 'HostelerDBEntities' could not be found (are you missing a using directive or an assembly reference?) " Here  "HostelerDBEntities" is entity Connection setting in webconfig i am not sure why it is coming  can any one help thanks

XML Signature xsd and Validation Error: Wildcard '##any' allows element causes the content model t

  
Hello,I'm trying to generate WCF client from Customer's WCF Service which has XML Signature options enabled.When trying to generate client proxy using svcutil I get following errors: Microsoft (R) Service Model Metadata Tool [Microsoft (R) Windows (R) Communication Foundation, Version 3.0.4506.2152] Copyright (c) Microsoft Corporation. All rights reserved. Attempting to download metadata from 'http://donex:51343/WebServices /Service.svc' using WS-Metadata Exchange or DISCO. Error: There was a validation error on a schema generated during export: Source: Line: 1 Column: 13464 Validation Error: Wildcard '##any' allows element 'http://www.w3.org/2000/09/ xmldsig#:HMACOutputLength', and causes the content model to become ambiguous. A content model must be formed such that during validation of an element informati on item sequence, the particle contained directly, indirectly or implicitly ther ein with which to attempt to validate each item in the sequence in turn can be u niquely determined without examining the content or attributes of that item, and without any information about the items in the remainder of the sequence. Error: There was a validation error on a schema generated during export: Source: Line: 1 Column: 14410 Validation Error: Wildcard '##any' allows element 'http://www.w3.org/2000/09/ xmldsig#:XPath', and cau

Expression evaluation caused an overflow error when calling ExecuteResultSet(SqlServerCe.ResultSetOp

  
HelloWhen I call ExecuteResultSet(SqlServerCe.ResultSetOptions.Scrollable) I am getting the following error when the data type is Numeric(18, 4):Expression evaluation caused an overflow. [ Name of function (if known) =  ]The numbers involved are not that big and work fine when ExecuteReader() or ExecuteResultSet(SqlServerCe.ResultSetOptions.None) are called on the same SQL.Any ideas? Thanks in advance!Cheers,DaveCode:Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click        Dim errorDescription As String = String.Empty        Dim numericNumber As String = String.Empty        Try            Using sqlCE As New System.Data.SqlServerCe.SqlCeConnection("Data Source = '" & My.Application.Info.DirectoryPath & "\MyDatabase.sdf';")                sqlCE.Open()                Dim sqlCECommand As SqlServerCe.SqlCeCommand = sqlCE.CreateCommand()                sqlCECommand.CommandText = "SELECT SUM(MT.TPM_Measure1) AS CurrentAmount FROM BUS_Table MT"                System.Diagnostics.Debug.WriteLine(sqlCECommand.CommandText)                Dim reader As System.Data.IDataReader = Nothing                If RadioButton1.Checked Then                    reader = sqlCECommand.ExecuteReader() 'Works fine                ElseIf RadioButton2.Checked Then                    reader = sqlCECommand.ExecuteRe

What is the correct error handling in custom model binding?

  
Hello,I am working on a Custom Model Binder where a certain error can occur.When this happens it returns null and a error is added to the ModelState.The problem is that in some projects I am using Fluent Validation and the errors messages I am adding through FV are not taking effect.The message added by the Model Binder always prevails.Should the Model Binder add error messages or just bind the field and return null if some problem happened?What would be the correct implementation for this?Thanks,Miguel

Analysis Service Process Dimension Cause : OLE DB error: OLE DB or ODBC error: ORA-00942: table or v

  
Dear Gurus, I'd face a "STRANGE" problem. I'm using SQL2008 connect to Oracle Data Source (OracleOldDB.1) When I process a snow-flake dimension . There is a ORA-00942 problem. But if I past the SQL Statement to a Oracle Tool . It worked without any problem. Does any body ever face this "STRANGE" problem ? And I'd try to remove this table from data-source-view and re-join it . Still same problem !!  Wilson

SQLVDI error in eventlogs, caused by ntbackup

  
I wanted to prevent ntbackup from locking my databases during the nightly backup,  so I excluded the ...\Data folder from the backup set.  However, I think that ntbackup is backing up the databases during the volume shadow copy phase of the backup, even though their folder was excluded from the backup set (I verified this setting in the .bks file).  Although the lock only lasts a few seconds, the error message is worrisome and I would prefer to skip the databases completely.  How can I stop the volume shadow copy from doing this? Below is the the sequence of events leading up to the error, most recent first: Event Type: ErrorEvent Source: SQLVDIEvent Category: NoneEvent ID: 1Date:  3/23/2007Time:  3:01:49 AMDescription:SQLVDI: Loc=CVDS::Cleanup. Desc=Release(ClientAliveMutex). ErrorCode=(288)Attempt to release mutex not owned by caller.. Process=8684. Thread=7556. Client. Instance=. VD=. Event Type: InformationEvent Source: MSSQLSERVEREvent Category: (6)Event ID: 18264Date:  3/23/2007Time:  3:01:48 AMDescription:Database backed up. Database: master, creation date(time): 2007/03/12(15:08:23), pages dumped: 1, first LSN: 268:352:37, last LSN: 269:24:1, number of dump devices: 1, device information: (FILE=1, TYPE=VIRTUAL_DEVICE: {'{66DC3082-FB76-4312-AD74-4BDAD9FC7209}1'}). This is an informational message only. No user action is required. Event Type: InformationEvent Source: 

Exception caused by DataPager.SetPageProperties() on ListView (postback error)

  
 Hi, I have a issue with drives me crazy! I'm using the DataPager method SetPageProperties() to restore the current page in my listview after I navigated into a page related to a listview item. (I persist the current page in the session state) I display 10 items at a time, and there are 10 pages. Everything works perfectly for the first 100 items, .... but after I go beyond (to display pages 11 to 20), if I call SetPageProperties() to restore the proper "current" page, I cannot submit anymore anything without getting the following exception: An error has occurred because a control with id 'ctl00$ctl00$ContentPlaceHolder$ContentPlaceHolder1$m_ListViewSearchItems$lvProductsPager$ctl00$ctl10' could not be located or a different control is assigned to the same ID after postback. If the ID is not assigned, explicitly set the ID property of controls that raise postback events to avoid this error. The exception refers to the DataPager sub-controls which are not rendered the same way for first pages (1 - 10) than (11 - 21); Is that because it expect then a "previous page" button? I don't quite know what to think about it. Does anyone have a clue?

BDC model in Search Server 2010 indexing error - Error while crawling LOB contents. ( Not a valid Wi

  
I have created a .NET connector assembly that pulls data from an in-house .asmx web service.  I have successfully created an external list in a search center site that displays this data without problem.   However, I've run into an error and a warning when indexing this list in search server 2010 for which I cannot find much information.  I've configure a content source with LOB data as the content source type and select my external data source from the list. After running a full crawl, I receive this error: Error while crawling LOB contents. ( Not a valid Win32 FileTime. ) And this warning: The content for this address was excluded by the crawler because this item was marked with a no-index meta-tag. To index this item, remove the meta-tag and recrawl. My .NET connector assembly looks like this:   public static WeatherEntity ReadItem(string id) { foreach (WeatherEntity entity in GetAllEntities()) { if (entity.LocationAbbreviation == id) { return entity; } } return null; } public static IEnumerable<WeatherEntity> ReadList() { return GetAllEntities().ToArray(); } public static List<WeatherEntity> GetAllEntities() { List<WeatherEntity> weatherEntities = new List<WeatherEntity>(); WeatherService.WeatherWS service = new WeatherService.WeatherWS(); WeatherService.DsWeatherDa

Error while creating Termstore using Object Model

  
Hi, I'm creating term store Group using object model using the below mentioned code:- string TermStore = drManagedMetadataGroups["Term Store"].ToString(); string GroupName = drManagedMetadataGroups["Group Name"].ToString(); string Description = drManagedMetadataGroups["Description"].ToString(); string GroupManagers = drManagedMetadataGroups["Group Managers"].ToString(); string Contributors = drManagedMetadataGroups["Contributors"].ToString(); try { //Type importManagerType = typeof(ImportManager); //Type[] parameterTypes = new Type[1] { typeof(TermStore) }; //ConstructorInfo constInfo = importManagerType.GetConstructor(BindingFlags.NonPublic | BindingFlags.Instance, null, CallingConventions.ExplicitThis, parameterTypes, null); //if (constInfo != null) //{ TaxonomySession session = new TaxonomySession(web.Site); TermStore ts = session.TermStores[TermStore]; //ts.AddTermStoreAdministrator(@"test-account-01\d39373g"); //logger.LogToOperations(string.Format("Added managed metadata group administrator '{0}' to '{1}'", GroupName, TermStore), EventLogEntryType.Information); if (!M
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