0 Replies Latest reply: Dec 13, 2011 5:48 PM by tfriesen RSS

    Hierarchy for Data Point Comparison between Items separated by 0+ Ancestors

      Scenario: Very large data set of student marks in numerous courses, many of which have prerequisites also in the dataset.

       

      I would like to produce an application in which the user can click on a course, discover and select it's immediate or distant prerequisites, and show marks of students having taken both courses for both courses for a comparative analysis. (eg, scatter graph of student marks in A on one axis against student marks in B on the other.)

       

      Simplified data tables look like

       

      CourseMarks

           CourseID

           StudentID

           Mark

      ...

       

      Prerequisites

           CourseID

           PrerequisiteCourseID

       

      Do I use a load resident on the fact table? How can I link this to the dynamically selected prerequisite? Or is there a better way?

       

      I'm fairly new to QV, so I'd appreciate any thoughts on the load (especially!) and/or sheet object implementation.

       

      Thanks,

      Tom