Hour Attribute for Date dimension

• denizv

  SSC Rookie

  Points: 34

  More actions

  July 23, 2009 at 9:38 am

  #156010

  Hi,

  I am new to BI/DW and AS. Currently I am using AS05 to build a BI system that needs to

  show aggregates per hour as well as per day/week/etc.

  Q)I have used the date dimension template to have a date table generated and later, added an hour_of_day column to this table and used a cross join to put values from 0 to 23 for each hour.

  Now the date table has 24 times more rows. Is this the correct way to use hour by hour analysis?

  Or is the correct way to create an hour dimension (as per the example script on sqlservercentral) and relate it to the fact tables.

  I would be glad if someone could help me with this.

  Thanks,

  Deniz E V

• denizv

  SSC Rookie

  Points: 34

  More actions

  August 13, 2009 at 7:55 am

  #1038699

  if anyone has the same question, seperate time dimension(hour,minute) is the answer.

  datawarehouse toolkit - kimball