A filter object is a predefined Where clause that can be inserted into the
Select statement inferred by objects in the query pane. Filter objects are stored in the business layer. Each folder defined in the business layer can contain a filter object.
Using filter objects has the following advantages:
Useful for complex or frequently used conditions.
Gives users the choice of applying the condition.
No need for multiple objects.
Using filter objects does not inherently solve the problem of conflicting WHERE clauses returning an empty data set. If a user runs a query that includes two filter objects that access the same data, the two conditions are still combined with the AND operator. The two conditions are not met, and no data is returned. However, you can solve this problem easily by changing the word AND to OR in the reporting tools .