6 Replies Latest reply: May 8, 2013 10:51 AM by NehaSSharma RSS

    OBIEE: Criterias not appearing in Answers query

    NehaSSharma
      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