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

    • Bearbeitet Mary44 Montag, 28. Januar 2013 15:40
    Sonntag, 27. Januar 2013 20:23

Alle Antworten

  • 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)

    Dienstag, 22. April 2014 23:27