ForceMerge function might be very helpful in some merged dimensions scenarios. Here is a short description how it works.
We have 2 data providers with few objects based of eFashion universe where Category dimensions are merged.
When we include Extended price measure into a first block everything looks ok. However when we remove the merged dimensions from it this is where the problem start showing. An Extended price is aggregated at all Categories level and BO is unable to split it by Lines dimension because it’s from a different data provider.
Here comes the ForceMerge() function to fix the issue. It works perfect in our scenario because we have exactly 1 Line assigned to each Category. It is 1-n cardinality between Lines and Category. 1—1 would also work fine however for n-l or n-n cardinality our function is useless.