3 Replies Latest reply on Jul 13, 2016 4:46 AM by Swarnalatha Mannar Mannan

    Tableau Report Scheduling

    Alex Lampron

      Good afternoon all,

       

      I have been tasked with creating an interactive dashboard that can provide "real-time" analytics for company performance.  I have currently created a live dashboard via Oracle Database and using SQL to pull in 10 data sources.  I have 2 questions that I am struggling to find answers for on the forums.

       

      1.) Some of the SQL produces huge outputs...Adding dimensions and measures to a worksheet can take updwards to  5 minutes.  Furthermore my filters are basically useless because it takes so long to update...Is my best option here creating extracts?

       

      2.) If I were to work off of data extracts how can I schedule these to occur every hour?

       

      If anyone can provide any insight as to what the best way is to get real time analytics using Oracle please help!  I have a meeting on Friday...

       

      Thanks!