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