Results of DMX query


  • I have this DMX query, which is written for Neural network model:

    select  t.*, predict ([module])
    as [predictedvalue],vba!format
    (predictprobability ([module]),'Percent')
    as [probability] from [Neuronske mreže]
    prediction join openquery ([moodle baza],
    'select distinct Course from [dbo].[log] ')
    as t on [Neuronske mreže].[Course]=t.Course
    order by PredictProbability([Module]) desc 

    And I get results, but just one Module for one Course. Even if I remove "distinct", results show more same results for one course.

    For example:

    Course        Predicted Value       Probability

    32                Forum                        95%

    But, on the course 32 there are more Predicted values, and I want to show them all, with their probability.

    How could I do it?

    Thank you in advance

    • Edited by Mary44 Monday, January 28, 2013 3:40 PM
    Sunday, January 27, 2013 8:23 PM

All replies

  • For this DMX, course 32 will only have one output.  If your original list has more than one course, then each individual course would have its own predicted value and probability.

    Mark Tabladillo PhD (MVP, SAS Expert; MCT, MCITP, MCAD .NET)

    Tuesday, April 22, 2014 11:27 PM