I used the wizard to create a time table but was wondering if there is a way
to get it the hour instead of just the date level?
--
Marty

Not sure, however I use a separate Hour dimension which has values from
0-23.

I prefer this approach since I can compare the curves day over day.


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

That is what I am trying to get to. I need to be able to compare what happen
between 10:00 a.m. and 11:00a.m. and compare it to 11:00 a.m. and 12:00p.m.
--
Marty


"Jesse O." wrote:

You can create a named query to simply build an hour dimension using
something similar to this:

--------------- start ----------------
select 1 as sort_order_key, '1 am' as hour
union
select 2, '2 am'
union
.......
select 23, '12 pm'
------------- end -----------------

Create an Hour_Dim from this.

Then, in your fact table convert your datetime field to hour only as
another column (named query makes this easy). Now you can join the hour
dimension to this field.







On Nov 15, 2:07 pm, Marty <M... (AT) discussions (DOT) microsoft.com> wrote: