Kbase P11825: How to create an incremental dynamart.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/18/2003 |
|
Status: Unverified
GOAL:
How to create an incremental dynamart.
FACT(s) (Environment):
Windows
FACT(s) (Environment):
CorVu 4.1.05
FIX:
Suppose you are running a monthly report, but it covers 1 year. For example, the report would be run for data covering August 2002 back to September 2001. Next month the same report would cover from September 2002 to October 2001.
Because this report is just summing, the report from September 2002 to October 2001 is just the same as the old report, minus the sum of September 2001 alone, plus the sum of October 2002 alone.
Assuming the number of columns remains the same, and it is just adding rows for each new month, then all you need do is create a query to extract 1 month's data and schedule it to save to a SQY e.g. currentmonth.sqy. Then edit the old historical dynamart e.g. 12month.SQY which contains the rolling year, filter it to remove all rows which are more than 1 year old, e.g. date must be greater than today() - 365. This will get rid of the old data, now APPEND this filtered dynamart to the currentmonth.sqy, and schedule it to make the new 12month.sqy.