Extending the data synchronization

As we saw in the previous recipe, queries can be unequal in terms of numbers of common dimensions.

As an axiom, we can claim that the more uncommon dimension objects we have, the more complex it is to display the common data.

In such cases, we will require additional functionality in order to display the common data.

In general, when we have more than one uncommon dimension object, we get a notification while trying to drag it into the table that is incompatible.

Let's have a look at such a case and learn how to resolve it.

Getting ready

We will create two queries based on the Data Warehouse universe: a Sales Revenue per Client Name and Client Country query, and another query that will fetch the Client Name and 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.