SAP BusinessObjects BI 4.0 The Complete Reference 3/E

Complex Query Filters

To understand how the AND, OR, UNION, INTERSECT, and MINUS operators work, it’s useful to review a bit of set theory. Figure 22-7 shows a Venn diagram with three sets of criteria: Year, State, and Product Lines.

Figure 22-7 Intersection of multiple filter criteria

When you add query filters to your query, the filters are joined by a default operator: AND. All conditions must be met for the query to return results. You can say this is the intersection, or solid triangle, in Figure 22-7, where all three sets of criteria are met. For example, if you set the conditions as shown in the following screen, the query will return information ...