Changed defaults for the Summary Query Join Operator and Multi Fact Join Operator governors

In new Framework Manager models, the governors (DQM) Summary Query Join Operator and (DQM) Multi fact join operator are by default set to Automatic.

In previous releases of IBM® Cognos® Analytics, the default setting for these governors was Is Not Distinct From.

When the setting is Automatic, the query service can automatically choose the most appropriate SQL predicate when joining summary queries or multi-fact queries. The predicate can be either a simple equality condition or a more complex condition that takes into consideration if the data source columns allow null values. The affected data sources are packages that contain the new models, and data modules that are based on such packages.

For more information, see Dynamic query mode governors.