Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Relate Start Date field to Date Dimension

Answered Relate Start Date field to Date Dimension

  • Thursday, January 17, 2013 10:43 PM
     
     
    Sign In to Vote
    0

    I have a session dimension with start date and end date of a session. This dimension has the following attributes sessionID, session, SessionStDt, SessionEndDt. If the user wants to look at the sessions starting in Q1 - 2012 how can I relate this to date dimension. Can some one pls guide me how to achieve this in cube or direct me to the link if posted somewhere.

    Thanks,

    VSP

     

All Replies

  • Saturday, January 19, 2013 8:07 AM
     
     
    Sign In to Vote
    0

    you may get a better answer if you told us the granularity of your measure group compared to the session dimension.

    But generally speaking, think about reviewing your dimensional model and create another two date dimensions (based on the date table that you already have)  one for the session start date and another for session end date, then include them in your measure group, and of course remove those dates from the session dimension. 

     
  • Sunday, January 20, 2013 7:19 PM
     
     Answered
    Sign In to Vote
    0

    VS_SQL -

    You can accomplish this by relating each measure group that needs to reference your Session dates to your existing Date dimension (additional role plays).  You just have to define the relationship as a reference dimension based on the dates in your Session dimension.

    Here's a diagram from Technet that demonstrates the design (Session would be the regular dimension & Date would be the Reference dimension).  And here's a link to the article.

    Let me know if that helps.

    Brent Greenwood, MS, MCITP, CBIP
    // Please mark correct answers and helpful posts //
    http://brentgreenwood.blogspot.com


     
  • Monday, January 21, 2013 7:33 PM
     
     
    Sign In to Vote
    0
    Thank you Butmah, for the reply. I have gone through the web and found that I need to implement SCD which is similar to what you posted above.

    VSP

     
  • Monday, January 21, 2013 7:35 PM
     
     
    Sign In to Vote
    0
    Thanks you Brent for providing the link, I will definitely go through the link.

    VSP