joinFilterType

Improves the performance of a join by filtering one side of the join with the values that are retrieved by the other side.

In IBM® Cognos® Analytics versions 11.1.6 and 11.1.7 a filter optimization error might occur. For more information, see XQE-PLN-0355 filter join optimization error.

Content model

Content type is NMTOKEN.

The possible values of this element are restricted to the following.

none: No optimization is carried out.
in: The generated filter is an IN predicate that is composed of constant values of the join keys from the "one-side" join operand.
between: The generated filter is a BETWEEN predicate that is composed of the minimum and maximum of the join key values from the "one-side" operand.
table: The generated filter is a table value constructor form of the IN predicate.