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 Sale Date, as shown in the following screenshot:
How to do it...
Perform the following steps:
We will merge the Client Name dimension object and drag it along with the client country name.
When we try to add the Sale Date as well, we will get the notification...
