Hi to all;

We have a fact that join with various dimensions, one is the date dimension.

We configure the cache in obi server in the correct way.

But we have the following scenario:

1. if the date physical column type is DATE the cache is seeded but then does not hit.

2. if we change the date physical column type to DATETIME (in the RPD physical layer) the cache is seeded and hits.

the problem is that with the DATETIME format over the date column i have a lot of issues with the presentations formats etc.

anyone have some tips or any workaround on this subject ?

the query logs for the differents scenarios are attached.

the obiee version is 11.1.1.7

thanks in advance

Nicolás

note:

being more specific when de logic query resolves to a date cast then does not hit cache, when it resolves a timpestamp cast then hits:

the following query would NOT hit cache over the next execution

SET VARIABLE QUERY_SRC_CD='Report',SAW_DASHBOARD='/users/e5644153/_portal',SAW_DASHBOARD_PG='3',SAW_SRC_PATH='/users/e5644153/test fecha cache';SELECT

  0 s_0,

  "Rentabilidad"."Bancas"."Banca" s_1,

  "Rentabilidad"."Fechas"."Fecha" s_2,

  "Rentabilidad"."Ft Captación"."Saldo Moneda Orig" s_3

FROM "Rentabilidad"

WHERE

(("Fechas"."Fecha" = date '2014-09-30'))

ORDER BY 1, 3 ASC NULLS LAST, 2 ASC NULLS LAST

FETCH FIRST 65001 ROWS ONLY

the following query would hit cache over the next executio

SET VARIABLE QUERY_SRC_CD='Report',SAW_DASHBOARD='/users/e5644153/_portal',SAW_DASHBOARD_PG='3',SAW_SRC_PATH='/users/e5644153/test fecha cache';SELECT

   0 s_0,

   "Rentabilidad"."Bancas"."Banca" s_1,

   "Rentabilidad"."Fechas"."Fecha" s_2,

   "Rentabilidad"."Ft Captación"."Saldo Moneda Orig" s_3

FROM "Rentabilidad"

WHERE

(("Fechas"."Fecha" = timestamp '2014-09-30 00:00:00'))

ORDER BY 1, 3 ASC NULLS LAST, 2 ASC NULLS LAST

FETCH FIRST 65001 ROWS ONLY