"Filtering in related table could not be applied" error

"Filtering in related table could not be applied" error

book

Article ID: KB0079274

calendar_today

Updated On:

Products Versions
Spotfire Analyst 7.5 and higher

Description

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.

Issue/Introduction

This article describes a reason and possible resolution for the "Filtering in related table could not be applied" error

Resolution

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. 
 

Additional Information

Doc: Working with Large Data Volumes
Powered by Wolken Software