Skip to main content
D
DCarrillo
December 27, 2023
Solved

Intercompany Mapping using Derivative Rules

  • December 27, 2023
  • 1 reply
  • 0 views

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:


DCarrillo_12-1703696006981.png

Account Mappings:


DCarrillo_14-1703696302403.png

IC Mapping:


DCarrillo_13-1703696074549.png

 

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.


DCarrillo_8-1703695547735.png

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


DCarrillo_10-1703695687901.png
    Best answer by MikeG

    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,

    1 reply

    M
    MikeG
    December 27, 2023

     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,

     

    D
    DCarrilloAuthor
    December 27, 2023

    Hi Mike,

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


    DCarrillo_1-1703714345957.png

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


    DCarrillo_2-1703717438730.png

     

    M
    MikeGAnswer
    December 28, 2023

    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,

    Terms & ConditionsAccessibility statement