we have a requirement where we need to reload the QVW documents only once the DB load is completed successfully.
I have gone through few posts on using EDX to achieve this. But, I'm unable to put them all together and use it according to my situation.
Let's say, I'm having totally 95 QVWs to be reloaded in QMC.
My DB load usually starts at 5AM and ends by 7AM and Qlikview load starts at 8AM.
However, sometimes DB load might get delayed and our reports are publishing 0's in the reports. we need to avoid this.
we'll have a table with all the tables information and their load status as shown below. so QMS needs to check this table continuously using API. If the table status is success, then the respective QVW needs to be reloaded in QMC.
Table_Information:
Table Name
Start Time
End Time
Status
Last Updated
Table 1
7:00 AM
7:20 AM
SUCCESS
10/30/2018
Table 2
7:10 AM
7:40 AM
SUCCESS
10/30/2018
Table 3
6:00 AM
-
-
10/29/2018
Table 4
6:00 AM
-
FAILED
10/29/2018
Has someone gone through the same approach earlier. If yes, could you please help me with the step-by-step procedure to achieve the same.
