I'm using below script for generating QVD over the weekends for the full week , in case I have missed the data for any weekday!
Let vLoadFrom = timestamp(If(Weekday($(vLAST_LOAD_TIME)) >= 5, WeekStart($(vLAST_LOAD_TIME)), $(vLAST_LOAD_TIME)), 'DD.MM.YYYY HH24:MIS');
'$(vPlant)' as Plant,
WHERE DTTSERF > to_timestamp('$(vLoadFrom)', 'DD.MM.YYYY HH24:MIS');
store STICHPROBE into $(vQVDCurrentYear)\$(vPlant)_STICHPROBE.qvd;
Now what I'm looking for is :
Suppose when I have triggered QVD Generator @ 6:00 AM , this might have missed some data which was made available later this day@9:00 PM inside database. So to support these cases of database update issue , is there any solution with the above script where I can write :
"Each day @ 11:00 PM , I want a full load for fetching data from database for the full day and store as QVD"
Please suggest if this approach is possible or not???