calendar not showing values

[felcar2013]

hi

do you have an idea, why my calendar in the productive enviroment is not loading correctly (it does not load any record) while in the development environment, same record, it works perfectly

There is even no error message, to see what is wrong, the end result is that i have no field values in my calendar

here is the code i use in both documents (development, productive)

LET varMinDate = Num(Peek('%CALENDAR__transactions__DATE',0,'transaction'));

LET varMaxDate = Num(Peek('%CALENDAR__transactions__DATE',-1,'transaction'));

LET varToday = num(Today());

CALENDAR_dummy:

LOAD date($(varMinDate)+IterNo()-1) as Datumsfeld

AUTOGENERATE 1 WHILE $(varMinDate)+IterNo()-1<= $(varMaxDate);

CALENDAR:

LOAD *,

AutoNumber(transaction_date_monthyear, 'PeriodID') as [Period ID];

LOAD Datumsfeld as %CALENDAR__transactions__DATE,

     Datumsfeld as transaction_date,

     week(Datumsfeld) as transaction_date_week,

     year(Datumsfeld) as transaction_date_year,

     month(Datumsfeld) as transaction_date_month,

     weekday(Datumsfeld) as transaction_date_weekday,

     date(monthstart(Datumsfeld), 'MMM-YYYY') as transaction_date_monthyear,

          'Q' & ceil(month(Datumsfeld)/3) as transaction_date_quarter,

     year(Datumsfeld)&'-' & week(Datumsfeld) as transaction_date_yearweek,

     InYearToDate(Datumsfeld, $(varToday),0) * -1 as CurYTDFlag,

     InYearToDate(Datumsfeld, $(varToday),-1) * -1 as LastYTDFlag

RESIDENT CALENDAR_dummy Order by Datumsfeld asc;

DROP TABLE CALENDAR_dummy;

[kaushiknsolanki]

Hi,

     Did u check that? Let me know whether tht was the problem or not.

Regards,

Kaushik Solanki

[felcar2013]

thanks, i reload again my source qvws and it worked. It seems my order by did not work initially, and the variable took just the first date. The issue is solved

thanks

felipe