In a dashboard, to update the forecast of particular FY, the user selects the FY and runs the process. But, instead of uploading file of selected FY, he uploaded another FY (say FY21 instead of FY22) file. When he ran the process, selected FY existing data wiped out in the target and no change in data of another FY.
He used a saved view in staging module with filter "user selected year", to update uploaded forecast in the target. The saved view consisted of blank data for selected FY because file uploaded was of another FY.
How to avoid wiping of data in the target, if the user uploads wrong file? Should I make necessary changes for filter in a saved view?.
Thanks in Advance.