Trust that you are keeping well!
As per my under standing, source system had incorrect invoice amounts, so in the generated QVD and in the dashboard. Now, user has corrected the source data and you want to corrected values on Dashboard. If dashboard is referring data from QVDs then you must have to correct the QVD data by performing Incremental Load (Insert + Update Only). If your dashboard is referring data from Source application directly then just reload the application and you are ready to go.
Hope this will be helpful.
Rahul Pawar, First, thanks for the quick response.
But the user does not modify the data in the database, therefore, in the database the data is incorrect and it will keep like tha(wrong). For this reason, I would like for example through an Excel, change or make an update of the AMOUNT data, keeping all the previous data from the others fields. Therefore and in summary, i should only be able to load in an excel the correct value of amount and that this applies in the qvd.
I hope i have been clear.
You can change the amounts using a mapping file. I strongly suggest you keep the original amounts in the data so you can clearly demonstrate and summarize what has been changed. Something like:
LOAD PROTOCOL, AdjustedAmout
FROM your adjustment.execl.xls;
AMOUNT as OriginalAmount,
ApplyMap('AmountMap', PROTOCOL, AMOUNT) as AMOUNT
The idea is not to modify the data from the database, only modify the data displayed on the board.
In other words hide the error and let everyone believe nothing is wrong so no action is ever taken to correct the error. You'll end up with a system no one will believe anymore because it shows fairy tale data and you spend more and more time hiding more and more errors.
If you really want to change the data in the qvd then load the data, change the values you want to change in the script and finally store the resulting table with doctored data again in a qvd file.