Track changes from one refresh to the next

[#1]

is it possible to track changes from one refresh to the next?

We are using the web enterprise version and direct connect.

The data base we are connecting to is like a temporary file.  data is added and removed on a daily basis.  But we only want to refresh data weekly. 

[sunny_talwar]

For comparison, you will need to save an archive of your data. This can be done each day while reloading the application, but will make your application really big

[Clever_Anjos]

You want to compare row by row?

You can export some main KPI´s to text files on each reload and load them on next load comparing the results

[#4]

how would I set up an archive data?  Can it be done automatically at each refresh?

[sunny_talwar]

Yes you can. You just need to do a store statement with date in it

LET vArchiveDate = Date(Today(1), 'DD-MMM-YYYY');

LET vToday = Num(Today(1));

ArchiveTable:

LOAD *,

     Date($(vToday)) as ArchiveDate

Resident FactTable;

STORE ArchiveTable into ArchiveTable_$(vArchiveDate).qvd;