What is the difference between condition & filter?
Submitted by: AdministratorConditions: 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")
Submitted by: Administrator
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")
Submitted by: Administrator
Read Online Business Objects Job Interview Questions And Answers
Top Business Objects Questions
| ☺ | What is difference between Webi and Infoview? |
| ☺ | What is the difference between BoXIR2 and BOXIR3? |
| ☺ | Explain What is the difference between slice and dice and cross tab report? |
| ☺ | Explain Are Data mart and DWH normalized or denormalized? Do both of them exist in |
| ☺ | Explain How can we do load testing for Webi Reports? (Example if I have have to test one webi report for Concurrent users refreshing report at one time)? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
