3 Replies Latest reply: Mar 21, 2013 1:11 AM by Veeresh Rayan RSS

    Why Rowwids are getting generated in OBIEE physical generatedquery

    845153
      Hi All,

      Why OBIEE physical generated query ( backend query ) is added his own conditions ( something like below ) other than specified in RPD in where clause while generation backend queries.

      Also, in my case in environment where clause is adding his own conditions like below and in another environment it is not... why???


      and (T123456.ROW_WID in (6.0, 9.0, 11.0, 16.0, 2002.0, 2003.0, 2004.0, 5009.0, 5010.0, 5011.0, 6006.0, 24001.0, 26001.0, 26007.0, 26009.0, 26011.0, 26013.0, 26015.0, 26017.0, 26019.0, 26028.0, 27005.0, 27007.0, 27009.0, 27020.0, 98006.0))
      and (T654321.SOMETHING_WID in (6.0, 9.0, 11.0, 16.0, 2002.0, 2003.0, 2004.0, 5009.0, 5010.0, 5011.0, 6006.0, 24001.0, 26001.0, 26007.0, 26009.0, 26011.0, 26013.0, 26015.0, 26017.0, 26019.0, 26028.0, 27005.0, 27007.0, 27009.0, 27020.0, 98006.0)) )

      Regards,
      Chandra