Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have created a master calendar and a fiscal calendar, but for some reason neither will appear in the data manager. I see them in the data load viewer, and by looking in the previews I know that my data is correct. Is there a way to associate my calendars within the load script, or to make the tables appear in the data manager? I would really appreciate any advice!
I copied in my script below:
MASTER CALENDAR
Maintable:
Load
Date(ACC_DATE,'M/D/YYYY') as Date
Resident MSCAN_ACCIDENT;
Min_Max:
Load
Min(Date(Date#(ACC_DATE,'M/D/YYYY'))) as MinDate,
Max(Date(Date#(ACC_DATE,'M/D/YYYY'))) as MaxDate
Resident MSCAN_ACCIDENT ;
Let VMinDate = Num(peek('MinDate', 0, Min_Max));
Let VMaxDate = Num(peek('MaxDate', 0, Min_Max));
TemCal:
Load
Date($(VMinDate) + RowNo()-1) as x
AutoGenerate $(VMaxDate)-($(VMinDate)) +1;
Master_Calendar:
Load
x as Master.calendar.Date,
Year(x) as master.calendar.Year,
Month(x) as master.calendar.Month
Resident TemCal;
FISCAL CALENDAR
set vFM = 10;
Calendar:
Load Dual(fyear-1 &' /' & fyear,fyear) as FYear,
Dual(Fiscal.Month, fMonth) as FMonth,
*;
Load Fiscal.Year + if(Fiscal.Month>=$(vFM), 1, 0) as fyear,
Mod(Fiscal.Month-$(vFM), 12)+1 as fMonth,
*;
Load Year(Master.calendar.Date) as Fiscal.Year,
Month(Master.calendar.Date) as Fiscal.Month
Resident Master_Calendar;
Thank you!
Hi, In data manager you have tables loaded and tranformed with data manager that shows on the autogenerated script, tables created on script outside the autogenerated section doesn't shows on data manager.
If you do the load and transform of this calendar in script you don't need to have it on data manager, data manager only helps user without coding knowledge to do data transformations.