Hi Experts,
I have master calendar. Now i want create it as hierarchy calendar with year, Quarter, Month
Can you guys please suggest me the solution.
This is my master calendar script:
Calendar:
Load Dual(fYear-1 &'/'& fYear, fYear) as FYear, // Dual fiscal year
Dual(Month, fMonth) as FMonth, // Dual fiscal month
*;
Load Year + If(Month>=$(vFM), 1, 0) as fYear, // Numeric fiscal year
Mod(Month-$(vFM), 12)+1 as fMonth, // Numeric fiscal month
*;
Load
Date(DateNum, 'MM/DD/YYYY') as LinkDate,
Day(DateNum) as Day,
Month(DateNum) as Month,
Week(DateNum) as Week,
WeekDay(DateNum)as WeekDay,
'Q' & Ceil(Month(DateNum)/3) as Quarter,
Year(DateNum) as Year;
Load
$(vMinDate) + IterNo() - 1 as DateNum
AutoGenerate 1
While $(vMinDate) + IterNo() - 1 <= $(vMaxDate);
Please help me to achieve this
Thank you in advance
