Forum Discussion
Different Dates based upon 2 different columns
Community Championantlufc I'm not quite following this. So you have a Date dimension and that includes what the Stage is for each Key based on which Date? Maybe post a picture of your data model or at least the relevant tables. I'm not understanding how you are arriving at the correct Stage for a specified Key and Date.
Greg_Deckler
date dimension - which provides the date linked to fact events via date key
fact events table - which provides the MQL latest date, key and date key which links to date dimension based on the date an event happened and dim events via the key
dim events - which contains the stage name which is linked to fact events via the key.
- Greg_Deckler
antlufc So the dim events table also has a date so you know what stage a key was in on a specific date?
Greg_Deckler - no dim events only has the stage name.
The date where the specific event has happened is in fact events.