Preference setting for Spotfire Desktop to MarkingWhereClauseLimit and MarkingInQueryLimit.

Preference setting for Spotfire Desktop to MarkingWhereClauseLimit and MarkingInQueryLimit.

When you have large/complex data tables which are related, then in such a scenario you may face an error "Filtering in related table could not be applied" error and the related table will not be filtered.

For the Spotfire Analyst, we are able to set the preference setting for MarkingInQueryLimit (Default is 15000), MarkingWhereClauseLimit (Default is 1000) from the Administration Manager, however, for the Spotfire Desktop version there is no Administration Manager for making change to this preference setting.

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.
   

Please follow the steps as given below to add the setting in the configuration file:

*Note: Please make sure you have a backup copy of the "Spotfire.Dxp.Main.dll" config file before you make changes to it.

Browse to the below-mentioned directory of the Spotfire Desktop which contains the AppData and configuration files for Spotfire Desktop.

C:\Users\(YOUR_USER_NAME)\AppData\Local\TIBCO\Spotfire Desktop\7.11.0\Modules\Spotfire DXP Forms_32.0.11802.4673

In the above directory, you can find the "Spotfire.Dxp.Main.dll.config" file, please have the backup copy of this file before you make changes in the setting for this file.

Open the "Spotfire.Dxp.Main.dll.config" file in a text editor, and add the following XML code in between the <applicationSettings>  </applicationSettings> tag.

<Spotfire.Dxp.Data.Properties.Settings>
    <setting name="Desktop_Preference_MarkingWhereClauseLimit" serializeAs="String">
      <value>1000</value>
    </setting>

    <setting name="Desktop_Preference_MarkingInQueryLimit" serializeAs="String">
      <value>15000</value>
    </setting>
</Spotfire.Dxp.Data.Properties.Settings>

*Note that these are the default values. You need to increase these values in order to resolve the issue that you are facing.

Save the above changes in the "Spotfire.Dxp.Main.dll.config" file and relaunch the Spotfire Desktop instance.

You can check by sufficiently increasing those values for "Desktop_Preference_MarkingWhereClauseLimit" and "Desktop_Preference_MarkingInQueryLimit" resolves your issue.

*NOTE: Changing these preferences may have a negative impact on performance. Increase the values with caution.
 
https://docs.tibco.com/pub/sfire-analyst/7.7.1/doc/html/en-US/TIB_sfire-analyst_UsersGuide/data/data_working_with_large_data_volumes.htm