start dates and end dates

ssp · Post by **ssp** » Sun Oct 17, 2010 3:51 pm

I have a rows of data from sql defining the month, quarter, year for any given date RANGE. for example,

YEAR QTR MONTH START DATE END DATE
2000 1 1 1/1/2000 31/1/2000

Now in my time dimension i have all the dates. So what would be the best way to create the rollups given that for each row in SQL I only get the start and end date to define the year, quarter, month for ANY given date in my time dimension.