Skip to Main Content
Forums

Analytics Software

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.
Post Details
Locked 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
148 views