Skip to Content
Author's profile photo Former Member

Web Intelligence: Significance of ForceMerge() Function

Web Intelligence: Significance of ForceMerge() Function

Let me explain the use of ForceMerge with an example.

Suppose say you have two data providers

Query1 :

/wp-content/uploads/2014/01/clip_image002_359435.jpg

Query2:

/wp-content/uploads/2014/01/clip_image002_359435.jpg

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.

/wp-content/uploads/2014/01/clip_image002_359435.jpg

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

/wp-content/uploads/2014/01/clip_image002_359435.jpg

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

/wp-content/uploads/2014/01/clip_image002_359435.jpg

Hope it helps!

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Excellent explanation! Thanks!

      Author's profile photo Pan kaj
      Pan kaj

      Hi,

       

      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?

       

      Thanks