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.

image

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 ...

Get SAP BusinessObjects BI 4.0 The Complete Reference 3/E now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.