Why don't you create a VIEW of JOINS outside of TABLEAU and connect to that ?
That will help you to connect to the relevant data only.
. Take advantage of Tableau’s query optimization
- Blend on low-granularity dimensions. The more members in a blend, the longer it takes. Blending aggregates the data to the level of the relationship. Blends are not meant to replace row-level joins.
- Minimize joined tables. Lots of joins take lots of time. If you find yourself creating a data connection with many joined tables, it may be faster to materialize the view in the database.
- Assume referential integrity if your database is configured with this option.
CREATE VIEW V_REGION_SALES
AS SELECT A1.Region_Name REGION, SUM(A2.Sales) SALES
FROM Geography A1, Store_Information A2
WHERE A1.Store_Name = A2.Store_Name and Date A1.BETWEEN 05/31/2011 AND 04/29/2012
GROUP BY A1.Region_Name;
Views are a good solution (completely outside Tableau).
You could create extracts with a filter on the date, or you could create a live connection with a data source filter.
These 3 options will give you the result you're after, obviously just choose the one that works best for you
Thanks Chris and Ritish . Definitely customized view is my first option . However we have a DB policy of not creating views . So that's why I am looking for this option .
Also , I want to see the sql query fired to the DB server when using tableau data source . From the tableau log file i can the sql query . however it will have some characters where i cant just and copy and paste it on my data base . Is there any other place other than log file I can get the sql query . thanks guys