Master Calendar

[lionking15]

HI

In my data model i am having 4 table with date as field and all are different dates and if i want to link all those 4 table(2 dimension and 2 fact) with master calendar how to do??

Thanks!!

[swuehl]

Have a look at

Tutorial - Using Common Date Dimensions and Shared Calendars

[Anil_Babu_Samineni]

See If this helps

Calendar: 

LOAD *, 

     Day(Date) as Day, 

     WeekDay(Date) as WeekDay, 

     Week(Date) as Week, 

     WeekName(Date) as WeekName,

     Month(Date) as Month,

     MonthName(Date) as MonthName, 

     Dual('Q'&Ceil(Month(Date)/3),Ceil(Month(Date)/3)) as Quarter, 

     'Q'&Ceil(Month(Date)/3) & '-' & Year(Date) as QuarterYear,

     QuarterName(Date) as QuarterName, 

     Year(Date) as Year, 

     Day(Date) & '-' & Month(Date) as DayMonth,

     'Week'&Ceil(Day(Date)/7) as WeekNum,

     WeekYear(Date) as WeekYear;   

LOAD Date(MinDate+IterNo()-1) as Date 

While MinDate+IterNo()-1 <= MaxDate; 

LOAD MakeDate(2014) as MinDate, 

     Today() as MaxDate

AutoGenerate 1;