Limitations of context filter:
Generally, Tableau takes a little time for placing a filter in context. In case the filter is set as a context one then the software develops a temporary table for that specific context filter.
Whenever we set a context filter, Tableau generates a temp table that needs to refresh each and every time, whenever the view is triggered. So, if the context filter is changed in the database, it needs to recompute the temp table, so the performance will be decreased.
Context filter:
Tableau helps in making the filtering process straightforward and easy.
It does so by creating a hierarchy of filtering, where all the other remaining filters that are present refer to the context filter for all their subsequent operations.
Thus, the remaining filters will now process the data, that is already passed through the context filter.
Development of one or more context filters helps in improving the performance, as the users do not have to create extra filters on the large data source, which actually reduces the query-execution time.
Limitations of context filter:
Generally, Tableau takes a little time for placing a filter in context.
In case the filter is set as a context one then the software develops a temporary table for that specific context filter.
This table reloads each time and consists of all the variables and values that are not filtered by context or custom SQL filter.
DISADVANTAGES OF CONTEXT FILTER IN TABLEAU
- Context filter is not convenient for regular change:
If you plan on finding multiple sets of data by applying different filters under one umbrella filter that constantly stays, then context filter is the one for you. But in case, you want to change the umbrella filter very frequently, context filter will not be convenient for you.
- Changing context filters requires a reload:
Once a context filter is applied on the data source, it starts checking all the available data and provides the result. This act of checking through the data takes a considerable amount of time. Every time the user changes the context filter, this happens and the reload takes time.
- Changing context filter slows down system:
Once the context filter is changed, the system needs to go through the whole process of checking the database and this slows down the system.
- Hard to work with context filter in a hurry:
If you are in a hurry and change the context filter, it will make the process of getting to the relevant data even slower.
- Needs patience to work with:
If one is applying a new context filter, then he must be patient enough to wait for the results that are supposed to make his work easier.
Context filters are extremely advantageous and speeds up the process only if applied at the right place and time.