Thursday, January 17, 2013 10:43 PM
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.
Saturday, January 19, 2013 8:07 AM
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
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 //
Monday, January 21, 2013 7:33 PMThank 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.
Monday, January 21, 2013 7:35 PMThanks you Brent for providing the link, I will definitely go through the link.