Anmelden
 
HomeLibraryDownloadsSupportWebcasts & EventsCommunityForenBlogs
Ressourcen für IT-Professionals >
> 
> 
Results of DMX query

Unanswered Results of DMX query

  • Sonntag, 27. Januar 2013 20:23
     
      Enthält Code
    Anmelden
    0

    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
    •