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

We will drag the City dimension object twice, once from each query, and the results will be the following:

We can see there are two missing aspects:

• The measure values are not aggregated at the row level but are displaying the total result...