Generic Keys with 2 Fact Tables (weekly/daily data)
I have some struggle to create a data model which fits to my needs. Basically I have two fact tables - one at a daily level (tab DailyData) and another one on a weekly level (see the tab PromotionData). In the promotion data the week results from the column promotion: 2000 is week 2, 48000 would be week 48, etc.
In my applications I regulary use a MasterCalender. But in this case, I dont know how to implement it in a good way. I dont want seperate Year, YearWeek or Week fields for every fact table. So I have searched a bit and come across the concept of 'generic keys'. Although I have read the Doc, I'm struggeling with the adaption to my problem/data.
It would be great, if someone can push me in the right direction (or suggest a better idea).
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.