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