Answers

Question and Answer:

  Home  Business Objects

⟩ What is the difference between condition & filter?

Conditions: these retrievals the data based on the condition (universe level)Filter: it brings the data and filter; performance will be slow (report level)

Filters - are used to restrict the number of rows in the output.

Conditions - It wont reduce the Number of Rows, but you can show up data based on some validations.

For Eg: select cust_id from customer where cust_name like 'A%'

Filter is Cust_name like 'A%'.

Condition is also applied at report level.

If (cnt(cust_id) > 1 ;"Valid";"NotValid")

 156 views

More Questions for you: