Hi,

I'm about to design a Time/Date Dimension (Day level) for a customer and I'm convinced of doing it the Kimball way is as close as perfect you could get. Roughly....