Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

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*
Comments
Locked Post
New comments cannot be posted to this locked post.