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



      Sreeharsha V

        • Re: Please help on Qliksense scheduling
          serhan celebi



          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.