A very simple example would be that i want to analyze how much a specific customer has donated per agreement. That could mean 1 row in the customer table (ONE customer), 2 rows in the agreement table (ONE customer has TWO agreements) and 20 rows in the gift table (10 donations per agreement). This is not possible with the current model as there is no relationship between Agreement and Gift (there could be an inactive relationship based on agreementid, but not an active). As I find this (simple) analysis to be quite complex, does that indicate that my model is poorly designed and if so, do you have any idea how to improve it? As far as I can tell my dimensions are good, that is what I want to slice and dice. I cannot see an obvious way to change my fact tables either. Any ideas?