Post reply

Date and Time Dimension

  • April 17, 2012 at 4:56 am

    #259332

    Hi,

    I'm working on two reporting projects. One of them is for a call center. For this project I need not only dates, I also need time. So what ist best practice, to build two dimensions, one for time, another for date or is it better to implemnt a single date/time dimension ?

    Thanks

    Hawkeye

  • April 17, 2012 at 5:54 am

    #1474651

    Hi

    I would certainly split them into 2 separate Dim's.

    It used to also be agreed that all date and times should be converted to join onto the relevant Dim's however if you look at the new MS Adventureworks DW they have also included the datetime as well as the key - this is something that I am now incorporating (for certain frequently used columns) into a new DW that I am designing, saves on a join

    Andy

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

  • April 17, 2012 at 8:37 am

    #1474765

    Hi,

    Thanks that confirms my guess.

    Hawkeye

  • April 19, 2012 at 4:36 am

    #1475928

    Download the SQL scripts included in the MSFT article to create dimension date:

    http://support.microsoft.com/kb/2293691/pt

    Regards,

    pedro

  • April 19, 2012 at 5:03 am

    #1475935

    Hi,

    ist there also an english version of the article ?

    Hawkeye

  • April 19, 2012 at 5:08 am

    #1475938

    Not yet...:-(

    Try to use google translator... but at least get the SQL Scripts

    Regards,

    Pedro

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply