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