This discussion is archived
6 Replies Latest reply: May 8, 2013 8:51 AM by NehaSSharma RSS

OBIEE: Criterias not appearing in Answers query

NehaSSharma Newbie
Currently Being Moderated
Hi All,

I am trying to include two criterias based on date conditions in Oracle Answers but when I look at the query generated by BI server, I can't see the criterias included in where caluse.Please can u help!

Criterias are something like this:

CAST("Workorder Production Dimension".Required AS DATE) <= CAST("Partner Dimension".START_DATE AS DATE)
and CAST("Workorder Production Dimension".Required AS DATE) >=timestampadd(sql_tsi_day,-1,CAST(CURRENT_DATE AS DATE)) AND CAST("Workorder Production Dimension".Required AS DATE) <=timestampadd(sql_tsi_day,4,CAST(CURRENT_DATE AS DATE))

There are two more criterias I have put in answers and these are appearing in the backend query:

Extid contains any Catchup
and Name is not equal to / is not in BT Cardinal

Regards,
Neha

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points