Time Dimension

// =========== Get First and Last Date in Orders Table ==================
Let vCYear = Year(today());
Let vLYear = Year(today())-1;
Let vFirstDate = MakeDate($(vLYear),1,1) ;
Let vLastDate = MakeDate($(vCYear),12,31);
Let vDateZero = vFirstDate - 1;

// =========== Dates ==================
[Time Dimension]:
Load distinct *,
Dual('Q' & ceil(Month/3), ceil(Month/3)) as OrderQuarter;
Load *,
Date(MonthStart(CREATEDATE),'YYYY-MMM') as YearMonth,
Year(CREATEDATE) as Year,
Month(CREATEDATE) as Month,
Week(CREATEDATE) as Week,
Day(CREATEDATE) as Day,
WeekDay(CREATEDATE) as WeekDay ;
Load
Date($(vDateZero) + recno()) as CREATEDATE
Autogenerate vLastDate - vDateZero;