Web Intelligence: Significance of ForceMerge() Function
Let me explain the use of ForceMerge with an example.
Suppose say you have two data providers
And business would like to see [Query1.Country], [Query1.No of Clients] and [Query2.Revenue] in a table.
Merge [State] object as it is common dimension in both the Queries.
We will not be able to add the Country object to the above table. It will not allow and shows “Cannot drop here – the object is incompatible”. Because Country object is a dimension and it is not synchronized with Query2.
If we bring [Country], [No of Clients] and [Revenue] in a table
[Revenue] data is not accurate. It is summing of all values in [Revenue] and showing the same values against each [Country]
This is where ForceMerge function helps. Instead of just using [Revenue] use =ForceMerge([Revenue])
You will get the desired result. ForceMerge considers the Merged dimension [State] which is not present in the same table as [Revenue] object.
Hope it helps!