Re: Reporting/Displaying Movements on Weekly Reloaded Data
When you do a reload of the new week's QVDs, perform a STORE command on them and save them, into a different directory or using a different name. Then you should be able to reload in not only this week's data but also last weeks.
You can probably then store both sets of data in the same tables and either:
- use a flag to show whether it is this week or last week
- save the measures as different field names (means less likely to have double counting on the front end expresisons)