Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dlorenc
Posting Yak Master
172 Posts |
 Posted - 2009-05-28 : 12:05:25
|
| what is the best practice for representing periods in a fact table?eg. I see the dimtime table contains dates stamped with 12:00am (00:00)...In a fact table are record that represent aggregations over a period, say monthly; so what 'date' should that record carry, the beginning date and 00:00..or the ending date of the period and 23:59...??? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-28 : 13:25:02
|
| if you're storing monthly analysis, what is significance of date there? isnt it better to store month(period) info as measures are those over the particular period. |
 |
|
|
dlorenc
Posting Yak Master
172 Posts |
Posted - 2009-06-01 : 09:54:02
|
| the measure could be weekly..monthly..or quarterly...as the scorecard will do an average..it really does not matter what the period is...unless someone wants to dig into the detail...so I want to store a date..representing the period..so that the values, over whatever the time dimenstion chosen, can be correctly attributed to that time period...so, I initially thought end ending date...for the period (EOM, or EOW, EOQ..)..but that is now getting in the way of the way the timdim table is stamped (with 12:00am)...as the ending dates were carrying 23:59....this is leading me to stamp any date with the beginning date of the period with a time of 12:00am....does that make any sense?... |
|
|
|
|
|
|
dimtime and fact table timestamps