need help to read the data Quarter wise from year qvd.
Hi Experts,
I looking for a help on one of the Requirement. As of now I have one year of data in my qvd Jan24 to till date.
due to huge volume of data we are implementing Document chaining where 4 apps having quarter wise data.
extractor will run daily and takes only updated records and getting appended on the history qvd.
i need some assistance how to keep condition in where class in app so that only specific quarter data will be loaded into app dynamically on daily apps refreshed like below
It depends on where your data is coming from. If you have one year of historic data in your QVD, plus new records from some other data source, then I'd say something like the below might be a good approach:
1) load from QVD where date>=jan25 and <=mar25.
2) append 'new' records from your other data source where date>=jan25 and <=mar25 and not exists(date) ... i.e. the data is in the required range but does not already exist in data loaded from the QVD.
3) store the combined table of historic+new data back to QVD.
