Forum Discussion
Solved
Role Playing Date Dimensions?
I'm using the following approach to create roleplaying date tables and wanted to run it by you all for feedback. Here's the scenario: - I have a source data table that has OrderDate and ShipDat...
- No [email protected] recommended solution is to use 2 calendar tables...but I find myself using one calendar table with USERELANTIONSHIP for the other dates most of the times...It depends mostly on how you will report them & the distribution of dates.Either way 2 calendar tables is easier to maintain in complex data models and many date columns.
But I prefer creating a second inactive relationship with ship dates using USERELANTIONSHIP so I can have both of them in the same graph using column from one calendar table
Is a matter of preferences..and habits
No [email protected] recommended solution is to use 2 calendar tables...but I find myself using one calendar table with USERELANTIONSHIP for the other dates most of the times...It depends mostly on how you will report them & the distribution of dates.Either way 2 calendar tables is easier to maintain in complex data models and many date columns.
But I prefer creating a second inactive relationship with ship dates using USERELANTIONSHIP so I can have both of them in the same graph using column from one calendar table
Is a matter of preferences..and habits
But I prefer creating a second inactive relationship with ship dates using USERELANTIONSHIP so I can have both of them in the same graph using column from one calendar table
Is a matter of preferences..and habits