Understanding the merge logic
As we have seen, the Merge option enables us to connect between several datasets, but what are the rules applied to the merge behavior?
The Merge option basically creates a union between the data providers. As we have seen, the effect is a full union that shows the common values in a single row.
Let's reverse the procedure and examine what the effect is without a merge and what other type of merge operators we can apply.
Getting ready
We have two tables that we require to merge in the report.
How to do it...
Let's have a look first at both of the tables' data.
We have a table with unique and common values, and both already have a global sum in each tables' footer.
Let's drag an unmerged dimension this time and see what the ...
Get SAP BusinessObjects Reporting Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.