It sounds like you need to crerate dates for travel that don't exist in your fact table. You might want to do this for booking dates too if you need them. The script below will create them and then you need to concatenate them to your fact table either in the data creation script or in your apps. This will give you a full set of dates in the fact table, that should fix your problem. You won't have any data against these dates but they will now be available in your charts and tables.
Let vStartYear = Year(Today()) ; //Set start year to current year
Let vStart = Num(Today()) ; //Set Today as integer
Let vEnd = Today()+730 ; //Set end date to today + 2 years, (+730)days)
Concatenate (***Fact table name here***)
MakeDate($(vStartYear))+RecNo() as [Booking Date],//Take the start year and create 730 dates
MakeDate($(vStartYear))+RecNo() as [Travel Date]//Take the start year and create 730 dates
Autogenerate $(vEnd) - $(vStart); // Autogenerate 730 lines
Let me know how you get on.
THanks for that, it works fine, but,Im trying to create a full list of travel dates for every individual booking date.
So for example:-
Booking Date 1 Jan 2010 would have Travel Dates 01 Jan 2010 to 31 Dec 2010
Booking Date 2 Jan 2010 would have Travel Dates 02 Jan 2010 to 01 Jan 2011
and so on. . . . . . . . .