Intercompany Mapping using Derivative Rules

[DCarrillo]

Hi, 

I am using Derivative Rules in order to generate additional records in Stage. In this example, I have two derivative rules per I/C transaction. The account mappings will bypass the original source value and one condition will be met and therefore loaded to the cube.

• If the value is greater than 0, then the value will go to 40L1CA.001A_DER.
• If the value is less than 0, then it will go to 40L1CA.001L_DER.

Derivative Rules:

Account Mappings:

IC Mapping:

The value shown below is $224,469.18 therefore the rule is correct. However, the IC is this case is mapping to None. I was expecting IC to map to IC partner 170 based on the IC mapping shown above.

How can I ensure that the IC partner is mapped correctly to the cube? I want to ultimately tie out IC matching report.

[MikeG]

 Hi @DCarrillo , on your IC mapping rule add 40L1CA.001A_DER to map to 170.  Your Derivative rule is changing the Account member and adding the *_DER, so I believe that now explicitly needs to be added to your One-to-One mapping in the IC Rule.

Hope this helps,

[DCarrillo]

Hi Mike,

I updated the IC mapping rule by adding 40L1CA.001A_DER to map to 170.

I revalidated to process the new IC mapping rule but it's still being mapped to None.

[MikeG · Accepted solution]

Hi @DCarrillo , How about checking the Transformation dimension processing order on the Cube Properties - Integration tab.  Make sure the Account dimension maps are processing prior to the IC dimension.  It may be an order of operations thing.

Hope this helps,