From your description it sounds like the weight will be by Business Unit & Date. If that is the case, I'd most likely opt for a reference table with that information, and then using that to populate an attribute in your fact table as that is already at the desired grain.