I have 2 facts tables with dates. In order to get a master calendar I created a link table with the main fields.
The structure looks fine, also when I look a the link table on for example the date 1-1-2014, is see that the keys for the fact tables are generated correctly in the link table.
Now what my problem is, it is not working. If you look for example at the tab "Benefit Management" you see that Q1 has some data, but the rest is not recognized by the date.
Also on the first tab if you look at the table. Almost all budgets are empty but they are all filed.
I am totally lost on how to find a solution so I hope you guys will be able to help.
