I have a problem and i would like to know how recommend you to solve this :
I have a fact table(sales table) that have all the facturation, this fact tables have some key , like Canal, zone and others , now i have a new requirement and i have to add Objective to this Canal and zone.
I do it, but my problem is that i can see the future objetive, if i have no facturation ... for example , i cant see the objective of march or april 2014 because in my fact table there is no facturation about these months.
i create a table that have a relation with the fact table with a composed key.
what change in my model do you recommend and if you have an example would be better!