Master Calendar Setup

[Anonymous]

I am wanting to get Master Calendar working in a file where I am just pulling through a date from a spreadsheet table.

I am getting the following error message -

Table not found

MasterCalendar:

LOAD

  TempDate as Date,

  Week(TempDate) As Week,

  Year(TempDate) AS Year,

  Month(TempDate) AS Month,

  Day(TempDate) AS Day

RESIDENT TempCal

Can anyone help me to get this setup.

[#2]

Make sure that you have created the original TempCal load as a NoConcatenate LOAD and then do the same for this MasterCalendar load i.e.

MasterCalendar:

NoConcatenate LOAD

  TempDate as Date,

  Week(TempDate) As Week,

  Year(TempDate) AS Year,

  Month(TempDate) AS Month,

  Day(TempDate) AS Day

RESIDENT TempCal

[er_mohit]

Try this

LET vDateMin = Num(MakeDate(2006,1,1));

LET vDateMax = Floor(DayEnd(Today()));

LET vDateToday = Num(Today());

TempCalendar:

  LOAD

  date($(vDateMin) + RowNo() -1) AS DateNumber ,

Date($(vDateMin) + RowNo() -1) AS TempDate ,

Week(Today())+4

AUTOGENERATE 1

WHILE $(vDateMin)+IterNo()<= $(vDateMax);

  LOAD

Day(TempDate) AS CalendarDayOfMonth,

YearName(TempDate,0,2)as FiscalYear,

Year(TempDate) AS YTD,

Month(TempDate) AS CalendarMonthName,

'Q' & Ceil(Month(TempDate)/3) AS CalendarQuarter,

MonthStart(TempDate) as CalendarMonthStart,

QuarterStart(TempDate) as CalendarQuarterStart,

num(month(TempDate))as num_month,

YearStart(TempDate) as CalendarYearStart,

MonthEnd(TempDate) as LMTD,

QuarterEnd(TempDate) as LQTD,

(Date#(TempDate,'DD-MM-YYYY'))as Current_date,

YearEnd(TempDate) as LYTD

RESIDENT TempCalendar ORDER BY TempDate ASC;

[#4]

Hi ,

Please check if name of the previouesly loaded Spreadsheet is "TempCal" and  name of the table are of same case.

If not please  attach work file or paste you complete script