none
Prediction subquery in DMX

    Question

  • Hi!

    I have two Association Rules mining models. One of them has 'Product Sub Category' as input and predictable column and other has 'Product Sub Category' as input column and 'Product' as predictable column

    I'm trying to use results of one prediction query in another one, but it doesn’t work

    My SELECT is below:

    select  PredictAssociation(
                [Product], 10,
                inclusive,
                INCLUDE_STATISTICS,
                INCLUDE_NODE_ID)
    FROM [tst] natural PREDICTION JOIN
    (SELECT (select [Product Sub Category] from PredictAssociation(
                [Subcategory], 3,
                inclusive,
                INCLUDE_STATISTICS,
                INCLUDE_NODE_ID) where $nodeid<>'')
    FROM [tst2] NATURAL PREDICTION JOIN
    (SELECT (select 'RUM' as [Product Sub Category]) AS [Subcategory] ) AS T) as [SubCategory]

    Could someone help me to get it works?

    Thanks!

    Monday, March 24, 2014 2:36 PM

All replies