I have a requirement to report on student GPA's. In my star schema I have term, course, student and student term (attributes of student per term e.g. college, level etc) as dimensions. I have one fact table which records student course registration. The GPA is generally calculated AT THE END OF EACH TERM. my question is where does GPA related information go. Is it a separate fact table by itself or I could include GPA information as attributes of the student term dimension table.
- Posts : 25
Join date : 2015-01-18
Permissions in this forum:You cannot reply to topics in this forum