O'Reilly logo

SAP BusinessObjects Reporting Cookbook by Yoav Yahav

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required