Product: TIBCO Spotfire®
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:
- On the menu bar, select Data > Data Connection Properties.
- In the Data Connection Properties dialog, select the data connection of interest and click Settings....
- 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.
- To save your changes and close the dialog, click OK.