Can I get only new data in every schedule of a report

scheduling XI Scheduler
1

Can I get only new data in every schedule of a report. I mean whatever was in the report on last Friday, I don’t want that on Monday’s run, I just want to see only new data that was loaded after last Friday. It’s kind of Delta loading I think.

If it is possible, please guide me how to achieve this. Thanks

Binary :australia: (BOB member since 2006-09-27)

2

Sure. Your queries just need some kind of pre-defined date condition e.g. ‘Yesterday’s Data’ could be something like

table.date_column=trunk(sysdate)-1

Nick Daniels :uk: (BOB member since 2002-08-15)

3

Thanks for your reply. This is my actual requirement. Hope you can help me to sort these out:

First run will include everything (All Data). .
After first run all subsequent runs will be on daily basis (ONLY weekdays, there will be no run on weekends).
Monday’s run will include all changes since last Friday’s run.

Binary :australia: (BOB member since 2006-09-27)