XQE-PLN-0355 filter join optimization error

The XQE-PLN-0355 filter join optimization error might occur in IBM® Cognos® Analytics with Watson versions 11.1.6 and 11.1.7.

In Cognos Analytics 11.1.6, the error message reads:

XQE-PLN-0355 Filter join optimization between 'Query1' and 'Query2' is not applied 
because more than 10,000 values are needed.

In Cognos Analytics 11.1.7, the message is slightly different:

XQE-PLN-0514 Filter join optimization between 'Query1' and 'Query2' is not applied 
because more than 10,000 values are needed. Either disable the optimization by modifying 
the 'Filter type' attribute of the join to 'Default' or 'None', or filter values from 'Query1'.

Both errors are associated with the Filter Type property of a join between query subjects (or between two queries). The property is defined to optimize join processing. However, in some cases, the optimization can cause out-of-memory issues or even lead to slower join processing. The error indicates that the number of joined values of the join would exceed the limit of 10000. To avoid this error, either disable the optimization or define a filter for the "one-side" entity of the join so that the number of joined values does not exceed 10000.

You can specify the Filter Type property in data modules, the Framework Manager user interface, Framework Manager Software Development Kit, and Cognos Analytics - Reporting.