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

book

Article ID: KB0077133

calendar_today

Updated On:

Products Versions
Spotfire Analyst 7.14 and higher

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.
 

Issue/Introduction

This article explains why and when the filter values will not be limited based on the other filter selections

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:
  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.

Additional Information

Doc: Working with In-Database data Doc: Details on Data Connection - Performance Settings
Powered by Wolken Software