"Filtering in related table could not be applied" error

"Filtering in related table could not be applied" error

In a situation where you have large/complex data tables which are related (Edit > Data Table Properties > Relations), when filtering in one table you may see the error message "Filtering in related table could not be applied" and the related data table will not be filtered.

TIBCO Spotfire has a configurable limit to the maximum number of relations which can be encountered in situations with large and/or complex data tables which are related.

To resolve: 

1. Open Tools > Administration Manager > Preferences > DataOptimization > DataOptimizationPreferences
2. Increase the values from their default limits.
   • MarkingInQueryLimit (Default is 15000)
   • MarkingWhereClauseLimit (Default is 1000)
3. Save the changes to the preferences.
4. Close and reopen the client.

Description of preferences:

• MarkingInQueryLimit - Limit applicable for queries within a single column. Specifies the limit for how large queries should be allowed when marking or transferring markings or filterings between related tables. The default is 15000.
• MarkingWhereClauseLimit - Limit applicable for queries involving multiple columns. Specifies the limit for how large queries should be allowed when marking or transferring markings or filterings between related tables. Default is 1000.

NOTE: Changing these preferences may have a negative impact on performance. Increase the values with caution. 
  Doc: Working with Large Data Volumes

• https://docs.tibco.com/pub/sfire-analyst/7.11.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/data/data_working_with_large_data_volumes.htm