Forum Discussion

DCarrillo's avatar
DCarrillo
New Contributor III
12 months ago

Intercompany Mapping using Derivative Rules

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.

Data Integration
Transformation
  • MikeG's avatar
    MikeG
    12 months ago

    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,

  • MikeG's avatar
    MikeG
    Contributor III
    12 months ago

     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's avatar
      DCarrillo
      New Contributor III
      12 months ago

      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's avatar
        MikeG
        Contributor III
        12 months ago

        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,