ForceMerge function

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.

15.1

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.

15.2

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.

15.3

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s