App Load Dependent on Data Mart Load Finishing

[#1]

Hi,

We are pulling all of our data for QlikView apps from our data warehouse. The warehouse finishes loading at different times each day and I want the app to wait until the warehouse is done loading to update. Is this possible? How can I do this?

Thanks!

[#2]

You can try with EDX trigger on the Publisher.

Using EDX in QlikView 11

[maxgro]

if you have a table in the data warehouse you can check for the end of dwh elab

you can start a task with a  loop in Qlik and every n minutes check for dwh end

let elab=0;

Do while True()

  TRACE sleep;

  // wait milliseconds

  SLEEP (1000);

  // check the end of data warehouse

  // replace the if with a check in a dwh table

  if 1=1 then

  LET elab=1;

  TRACE exit loop;

  EXIT Do;

  ENDIF;

loop;

if elab then

  TRACE start elab;

endif;