Hi All,
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.
Thanking in Advance.
Regards,
Jesh
