book
Article ID: KB0077133
calendar_today
Updated On:
Description
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.
Resolution
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.
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.
Issue/Introduction
This article explains why and when the filter values will not be limited based on the other filter selections