Thanks Martin,

The style of the proposed fact table is being driven partly via the reporting requirements that we have been given. There is a need to sum these votes in a hierarchical fashion - from College to School - to Subject - and then Course. Things start to get tricky when the sum of subjects don't equal the sum at school level because a vote for one course can span over 2 subjects etc.

This is why I thought about splitting a single vote fractionally as well as having a few columns in the fact table for the vote at different points in the hierarchy.

I haven't heard of a helper table being used so i'll look into that. We're slightly limited on experience here and have been repeating what our previous colleagues put in place, whilst this has worked for the most part we are encountering difficulties when coming across new scenarios. This is why input from people like yourself on here is proving very useful.

Thanks again,

Paul