When you get the data from the database, add a field with current date.
Something like this:
//(You need a script to create the StoredDate.qvd file for the first load)
Concatenate(StoredData) Load * from StoredDate.qvd
Load *
DimensionA,
today(0) as LastUpdate;
From Database;
//In case you need only the last update for each records, use this:
Load MaxString(DimensionA), Max(LastUpdate)
RESIDENT StoredData
GROUP BY DimensionA,LastUpdate;
Be careful that your date will only be loaded when you reload the qvw, so if you reload it every two days, you will have the data every two days and not the real change date.
