Query optimization for relative date measures

Queries that are generated for relative date measures, defined in data modules, are optimized.

An optimal set of predicates is automatically injected into the WHERE-clause of the generated SQL. The predicates restrict the number of rows that are scanned when the query runs to only those rows that are required by the relative date measures.

This functionality is enabled by default. It is controlled by a set of governors (not exposed in data modules) and by advanced query hints in the debug mode in Reporting.

For more information, see Query optimization for relative date measures.