1 Reply Latest reply: Apr 16, 2015 8:58 AM by Serhan Celebi RSS

    Please help on Qliksense scheduling

      Hello Everyone,

       

      Please help me into below issue at Qliksense

       

      I have apps created at hub, In apps i am loading Facts and Dimensions.

       

      Dimension Load will happen once in day

      Facts load happen once in hour

       

      i need to run facts and dimension apps automatically once the ETL load is happened.

       

      Can any body tell me how to do this

       

      Thanks in advance

       

      Regards,

      Sreeharsha V

        • Re: Please help on Qliksense scheduling
          Serhan Celebi

          Hello,

           

          I checked any additional features on Qlik Sense Help but could not find any.

           

          So I will try to explain what we do in QlikView so it should apply on Sense as well.

           

          - After ETL finishes, insert a record on a table on ETL-side indicating completion of ETL times.

          - Create a Sense app and read that table. Check if ETL finished on time today (regarding on your condition such as Today()) etc.

          - Make the app fail if timestamp of ETL completion is old and make it success if it is right or vice versa. This app just checks the ETL time(ETL_check.qvf). Define a task to it.

          - Define a task to your main app (main_app.qvf) such a trigger on completion of ETL_check.qvf.

           

          Hope it's clear.

           

          BR

           

          Serhan