Date Filter Issue

990088Mar 23 2013 — edited Mar 24 2013

I am facing issue with date filter when i am trying to apply date filter it been not carrying forward to the physical query. So its trying to pull all the records for Date from Database. Remaining all filters in calendar table and Organization table is working correctly. Guys, could you please provide me some suggestions on it?

Thanks

Presentation Query

SELECT
0 s_0,
"BCSS Biller"."Dim Calendar"."Fiscal Date" s_1
FROM "BCSS Biller"
WHERE
("Dim Calendar"."Fiscal Date" = date '2012-11-05')
ORDER BY 1, 2 ASC NULLS LAST
FETCH FIRST 65001 ROWS ONLY

Physical Query

select distinct T152."FISCAL_DATE" as c1
from
*"NDW_REPORT_VIEWS"."DAY_DIM" T152*

Locked Post

New comments cannot be posted to this locked post.

Locked due to inactivity on Apr 21 2013

Added on Mar 23 2013

#11g, #answers, #bi, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #data, #error, #obiee, #oracle, #prompt, #report, #reporting

12 comments

137 views