The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

DCarrillo's avatar
DCarrillo
New Contributor III
2 years ago
Solved

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
    2 years 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,

3 Replies

  • MikeG's avatar
    MikeG
    Contributor III
    2 years 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
      2 years 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
        2 years 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,