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 so...
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

 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,