Hi Everyone,
I am using Tableau 2020.2.1
Datasource : Custom sql with live connection, since i am sending parameter to my Hana db.
Currently my report hammers my DB with multiple queries, I am trying to optimize the performance.
I noticed that for each filter one wrapped sql is running in the DB along with the source custom sql query.
If 5 filters, queries in DB = 6 queries * (number of users)
I created a context filter believing that the rest of my filters will be calculated on top of it and it will not send the query to DB. But it didnt work that way, still Tableau sends filter queries to DB.
I need the filters as a dropdown, Is there any other possible ways please?
Thanks
As far as I know, each quick filter will result in a separate query to the database to determine the list of values for that filter. These shouldn't be large queries (unless you have highly granular dimensions in your quick filters), but if they are running sequentially for whatever reason it could take up quite some of the loading time for your viz.
Unfortunately the only real solution is to use less quick filters, avoid quick filters with many values and try to apply more dashboard actions as filters instead.
