Do you have (or know of) an example of a time dimension (as in the
hour/minute/second of the day) dimension that you could post or point to? I'm
looking for advice on...

(1) wording the dimension members...
What do you think about the wording of this hierarchy? AM/PM... 4PM Hour...
4:32 PM... 4:32:59 PM

(2) deciding whether to use AM/PM or military time

(3) deciding on a key structure... should the key be a string "4:32:59 PM"
or should it be keyed off 3 columns (military hour/min/second) or off 4
columns (AM-PM/hour/min/second)?

I think the general advice is to build the time dimension separately from
the date dimension so you don't end up with billions of members in a combined
date and time dimension. Let me know if anybody disagrees with this advice.

Thanks!

the key of the table could be:
a datetime (not recommanded)
a integer (recommanded) like: HHMMSS (205312 = 20h53min12sec)

after, create other columns to store the texts to display:

TimeID Hour Minute Second
205312 20h 20h53 20h53m12s
....

so you can use any text you want.

the best practices depend on what your users want to see.

AS2005 can generate a date/time dimension, so you can use it to create the
table you want.

"FurmanGG" <FurmanGG (AT) discussions (DOT) microsoft.com> wrote