Oracle Business Intelligence Infrastructure Installation and Configuration Guide > NQSConfig.INI File Reference >
Optimization Flags Section Parameters in the Configuration File
There is one parameter in the Optimization Flags section. It is a special parameter to override the behavior of the Oracle Business Intelligence Server in certain situations.
Use this parameter to relax strong type checking to prevent some date/time data type incompatibilities in queries from being rejected. For example, a query of the form "date/time op string-literal" technically contains a date/time data type incompatibility and would normally be rejected by the Oracle Business Intelligence Server.
Valid values are ON and OFF. The default value is ON, which means that strong type checking is enabled and queries containing date/time data type incompatibilities are rejected. This is the recommended setting.
To relax the strong type checking, set the value to NO. Note that invalid queries or queries with severe date/time incompatibilities are still rejected. Note also that the query could still fail, for example, if the relational database implements a similar strong type checking.
Example: STRONG_DATETIME_TYPE_CHECKING = ON ;