Skip to Content

Web Intelligence: Significance of ForceMerge() Function

Let me explain the use of ForceMerge with an example.

Suppose say you have two data providers

Query1 :




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!

To report this post you need to login first.


You must be Logged on to comment or reply to a post.

  1. Pan kaj



    Thanks for explanation. It is very useful.


    I have one question regarding ForceMerge() function.

    In my case,

    Consider the last Table ( Country | No of Clients | Revenue )


    If we take Total of Revenue Column, its coming wrong.


    How to resolve it?






Leave a Reply