QIQ Filter Properties enables you to specify whether filters set in the dashboard are cascading, which is the default. For example, if locality and city filters exist, setting the locality filter refreshes the list of city values, so only cities within the selected locality are available.
However, setting the filters to be non-cascading makes the dashboard more efficient. If filters are non-cascading, lists do not need to be refreshed so frames may activate more quickly.
It is recommended that the cascading filters property is enabled during the dashboard building process because some properties on the frame are not refreshed when the cascade property is turned off. Turn the cascade property off after the dashboard is created.
To use cascading filters:
In Interactive Reporting Studio, navigate to QIQ Filter Properties.
To access the configuration frame, use Sections or the Configuration drop-down list found in Dashboard Studio.
From Cascading Filters, select On.
Click Set to apply the selection.
The Set process may be time-consuming if the results contain many rows. If performance issues are a concern, select On without clicking Set. The selection is applied the next time the dashboard is opened.
Each time a query is processed, performance is slow initially, as the filters are applied or removed. If the cascading filters feature is turned off, the dashboard applies filters and activates frames more efficiently.
It is not recommended that the cascading feature is turned off if a date filter whose HH:MM:SS AM timestamp is not 12:00:00 AM.