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 :

/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!

To report this post you need to login first.

1 Comment

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

Leave a Reply