5 Replies Latest reply: Feb 20, 2013 11:41 PM by User320556 RSS

    Question: filter on OBIEE measure column doesn't get included in SQL

      Hello guys

      I have a report that has a few filters on a couple of columns there. One filter is on the measure "Account open Amount" as not equal to 0. When I run the report and check the SQL generated, I don't see "Account open Amount" <> 0 in the where clause of that SQL. I do see all the other filter conditions appear in that where clause. The measure has a Sum aggregate rule applied to it from the BMM layer

      Is it an expected behavior of OBIEE?

      Your thoughts?