SAP BusinessObjects Reporting Cookbook

Filtering matched values

Another relation between datasets would be to filter only the matched values.

The main operators available when merging the datasets are:

• Union: This unifies the two datasets whether or not they have common values; this operator is similar to a full outer join.
• Right union: This unifies only the values that exist in dataset A with all the common and uncommon values of dataset B. This operator is similar to a right outer join.
• Left union: This unifies only the values that exists in dataset B with all the common and uncommon values of dataset A. This operator is similar to a left outer join.

These operators are good for these scenarios, but if we need to find only the common values of the datasets, we will need to use some filter ...