Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2009

    Unanswered: DMX insert into data mining structure problem


    I have problem with inserting data to data mining structure - SQL Server 2005 SP3.
    I have Mining structure with nested table and I have Association Rules Mining Model. I try to load data to my structure by dmx query.
    I'm using sample query from the official MS page: INSERT INTO (DMX).

    DELETE FROM MINING STRUCTURE [Association Structure];

    INSERT INTO Association
    ([Order Number],[v Assoc Seq Line Items] (SKIP, [Model])
    SHAPE {
    OPENQUERY([Adventure Works DW],'SELECT OrderNumber
    FROM vAssocSeqOrders ORDER BY OrderNumber')
    } APPEND (
    {OPENQUERY([Adventure Works DW],'SELECT OrderNumber, model FROM
    dbo.vAssocSeqLineItems ORDER BY OrderNumber, Model')}
    RELATE OrderNumber to OrderNumber)
    AS [Models];

    The query pass but when I try:
    select * from Association.cases

    I get following result: Click image for larger version. 

Name:	screen.JPG 
Views:	110 
Size:	47.6 KB 
ID:	10165

    As you can see, for every order I can full list of products - every position is combined with every product - it's the cross join of lines and orders tables.


    When I'm processing my mining structure from Analysis Studio (Visual Studio - see the picture below) - everything seems ok - there isn't cross join in the select * from Association.cases query.
    Click image for larger version. 

Name:	analysis.JPG 
Views:	119 
Size:	43.8 KB 
ID:	10166

    What is wrong with my DMX feeding query? Why I get cross join from Management Studio (DMX) and correct result from Visual Studio?
    Last edited by sdera; 11-03-09 at 03:59.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts