it is called incremental load. You save now in a qvd and only load dec based on some unique key or last_updated date usually using the exists function. Lots of posts in the forum. Try searching for incremental load.
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
For extracting data from Database/ Source we can use Incremental load but incase of Dashboard we have to load full data. but my case there are 2 months and only one month will be update always in that case load one month(for ex: dec only not for nov), but dashboard should show nov also.
If the extract is well structured for your requirements, then you can load millions of rows in only a few seconds using optimised loads from qvd files. The immutable history for November should be in stored in a different QVD to December, and as November should require no calculations, you can load November very quickly - why is that a problem?
You can use partial loads, but IMHO that is a poor solution for your problem.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
