Explain the difference between Condition and Filter.

Filter reusable..condition not reusable
Conditions: these retrievals the data based on the condition (universe level)
Filter: it brings the data and filter; performance will be slow (report level)
  • Interview Candidate
  • 6
  • 3355

Showing Answers 1 - 6 of 6 Answers

Goverdhan Reddy

  • Oct 18th, 2006
 

here you go......

A Condition feature that forces a query to retrieve only the data that meets specified criteria.condition is placed on a report query to show the specific data. To define a condition Name,Description and Where clause are required

A Filter enables you to view only necessary data in a report.i.e it allows you to restrict the no.of rows displayed in the report they effect only the data currently displayed in the block but not query results

Ex:select values for a variable in the report to apply a simple filter

  Was this answer useful?  Yes

anil devireddy

  • Oct 25th, 2006
 

Haifilters are reusable ...conditions are not reusableconditions fit the data for that certain conditions only...filters r bring the data then filterd...byeanil kumar.d

  Was this answer useful?  Yes

Bharat Ahuja

  • Jan 9th, 2007
 

An added point here is that a condition is used to fetch selected data from the data source (data base) while the filter is used to fetch selected data from the data cube.

Also, you apply a condition in DeskI using Edit data provider, while filter is applied using Slice and Dice Panel, Filter and by right clicking on the Report pane.

  Was this answer useful?  Yes

lionskashif

  • Feb 17th, 2011
 

also added please, Condition: we put on the object belly where we write the where clause and FILTER is is ristrict the data according to the given/asking prompt. thx

  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