5 Replies Latest reply on Feb 21, 2013 5:41 AM by User320556

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

    Yala
      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?

      Thanks