• Very Good point - what are the top questions.

    Starting at question 1:

    1. What training has each staff member done or need to do

    This implies the following objects:

    Some kind of Staff Member dimension

    Some kind of Certification dimension

    As usual, there is a Time dimension involved here

    Some kind of fact to describe the historical and possibly planned events and metrics around Staff and Certification

    What training do they need to do? This would appear to boil down to an actual vs target situation. If they are at the same granularity then it might make sense to put the 'actual' and 'target' (and many other targets otherwise) into the same fact.

    But it appears you are already some way down the design path. and your current issue is loading the fact.

    Do you want to explain your issue in more detail and we can help.