Filter values are not limited based on the selections in other filters when using in-database table

Filter values are not limited based on the selections in other filters when using in-database table

For In-memory (imported) data tables, the values available in a filter are limited based on selections in the other filters, but when using In-database (external) data tables, the values are not limited i.e., when you choose some values in a filter then the values available for selection in other filters are not automatically limited.
  In order for the filters to be limited based on other filter selections when using in-database, external data tables, enable Cascading Filters for external (in-database) data tables as below:

1. On the menu bar, select Data > Data Connection Properties.
2. In the Data Connection Properties dialog, select the data connection of interest and click Settings....
3. In the Data Connection Settings dialog, click the Performance Settings tab, and then select Enable cascading filters for in-database data tables from this connection.
4. To save your changes and close the dialog, click OK.

Note: Enabling the cascading behavior for filters for in-database data tables results in an additional query load on the external data source. It is the user's responsibility to ensure that the external data source can handle the extra query load. Doc: Working with In-Database data

• https://docs.tibco.com/pub/sfire-analyst/10.3.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/index.htm#t=data%2Fdata_working_with_in-database_data.htm

Doc: Details on Data Connection - Performance Settings

• https://docs.tibco.com/pub/sfire-analyst/10.3.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/lib/lib_details_on_data_connection_settings_cache_settings.htm