Thanks for the quick reply. Basically, I have a Date Dimension for the next 2 years, i want to load each date for the next 5 years. I need to generate the rows for the next 5 years.

Here is what I want to see, but with different years.

Date

1997-01-01

1997-01-02

1997-01-03

1997-01-04

1997-01-05

1997-01-06

1997-01-07

1997-01-08