Date/Time dimensions for events?

Ask for help related to our 2.x versions.
Post Reply
User avatar
softwarezman
Posts: 82
Joined: Tue Jun 14, 2011 5:40 pm

Date/Time dimensions for events?

Post by softwarezman »

Hello,

I've been working with the code for a while now and have part of my database structure using date/time dimension tables to allow for some interesting custom report generation. I was wondering if anybody has used it for the actual scheduler events so you are using fk's to a date/time dimension table instead of an actual datetime column? Has anybody ran into any serious issues? I know this isn't a specific question to the Scheduler but I've never had to deal with time in such a fashion and was wondering if anybody has already ran through this and had any tips/suggestions/warnings they might want to pass along?

Post Reply