How to reduce time taken to compute filters in Tableau

Question

I have a dashboard where I have kept all the filters used in the dashboard as global filters and most used filters I have put as context filters, The problem is the time taken to compute filters is about 2-3 minutes. How can I reduce this time taken in computing these filters I have about 2 Million of extracted data, on Oracle with Tableau 9.3.

Answer 1

You can apply the context filtering before the actual worksheet pulls down the records -- if your filtering is done correctly, the filters get passed directly into the SQL query predicate (an actual WHERE CLAUSE and not really a 'filter') -- Try this -- Open Tableau, go to HELP > Settings and Performance > Start Performance Recording, then open your workbook and apply the filters. Once it is done loading, go to HELP > Settings and performance > Stop Performance Recording. This will give you a worksheet with the queries used on it.

You can also use a custom SQL to select only the dimensions and measures which you are going to use for the dashboard.

Finally, you can even use custom SQL to remove unnecessary filters and parameters.

An extremely good place to start is the following white paper by Alan Eldridge:
http://www.tableau.com/learn/whitepapers/designing-efficient-workbooks