Date Filter Is Not Working Against Teradata Database When ODBC Basic Database Drivers Are Used

(Doc ID 2036775.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.150120 and later
Information in this document applies to any platform.

Symptoms

Custom OBI EE 11g Report does not use the Date Filter as expected.

Logical:

SET VARIABLE QUERY_SRC_CD='Report';SELECT
  0 s_0,
  "Sales_dx"."Organisation"."CD01001" s_1,
  "Sales_dx"."Time"."Date" s_2,
  "Sales_dx"."Time"."Day_Id" s_3,
  "Sales_dx"."Fact"."EUR_per" s_4
FROM "Sales_dx"
WHERE
(("Time"."Date" = date '2015-07-01') AND ("Organisation"."CD01001" = '6002720'))
ORDER BY 1, 3 ASC NULLS LAST, 4 ASC NULLS LAST, 2 ASC NULLS LAST
FETCH FIRST 65001 ROWS ONLY

Physical :

select T106126."CD01001" as c2,
  T103878."Day_Date" as c3,
  T103878."Day_Id" as c4,
  T102320."CD14102" as c6,
  T102320."Day_Dt" as c7
from
  "FDWQ_INT_SL_DX_VIEWS"."ORGANIZATION_DIM" T106126,
  "FDWQ_INT_SL_DX_VIEWS"."CALENDAR_DAY_DIM" T103878,
  "FDWQ_INT_SL_DX_VIEWS"."FINANCIAL_FACTS_DAILY" T102320
where ( T102320."Day_Dt" = T103878."Day_Date" and T102320."Organization_Id" = T106126."Organization_Id" and T106126."CD01001" = '6002720' )

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms