Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Multiple Date Relationships - between 2 tables

Hi all    My dashboard has a table that contains multiple date fields (between other fields) and im using a date table that contains the full date ( the key) and a bunch of other useful fields (lik...
General Comment
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous The other way is to duplicate your date table and thus have multiple "role-playing" dimensions, one for each date in your fact table. "Start Dates", "End Dates", "Requested Dates", etc.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks Greg_Deckler. Do you think thats the only other way? 

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous Pretty sure. You could also just go with a disconnected table for your Calendar but you're back in the same boat as USERELATIONSHIP.