What is the difference between condition & filter.

Showing Answers 1 - 7 of 7 Answers

reddeppa

  • Mar 2nd, 2006
 

filter reusable..condition not reusable

  Was this answer useful?  Yes

sithu

  • Mar 25th, 2006
 

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

  Was this answer useful?  Yes

Vineela

  • Apr 25th, 2007
 

Condition Allows the data to be filtered at the database level , and if created at a Universe level can be used across many reports.
Filter will have visibility of data in the report. The over head of the data fetching form the Database cannot be avoided and this is not a reusable component.

  Was this answer useful?  Yes

subramanyam

  • May 28th, 2007
 

condition-> it can retrieve the data which meets the condition. it can restricted the at the database level.it will help to increase the query performance.

filter->it can hide the data at report level. in use of filter query performance is slow.

kiran.c

  • Oct 16th, 2007
 

Condition is reusable, but not the filter
We can create conditions at designer level. where as filters are at report level.

  Was this answer useful?  Yes

Condition and filters:


1.we can put conditions designer levels as well as report level also.
2. We can restrict some data in Universe level so that you want data we can
restrict Universe level.
3. We can put some conditions on report level also like we want particular data
on your report so we can put condition on query level.
4. we create Condition designer level also like (e.g Fn year 2005, Some area
data..... like we can create designer level also and use this filter in Query
level also.)


e.g Fashion Universe.


If you select Time period class we can found condition also like last year
sales=’2002’


5. Filters apply report level like…


e.g we have created one report which has based on BCA schedulers. In this we
have Successful jobs, failed jobs, running jobs and waiting jobs like that ……


actual we create BCA report in this BCA report we have JOB status objects
have data like Successful jobs, failed jobs, running jobs and waiting jobs so we
can create different report tabs apply the each report tab particular filters
(Successful jobs filters tab, failed jobs filter tab..) so that we can change
report temporally our requirements.


But conditions we put permanently if you change this we can go again and
change query panel and run again…


Regards.
Sreenivas.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions