12-27-2023 12:11 PM - last edited on 12-28-2023 08:28 PM by JackLacava
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.
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.
Solved! Go to Solution.
12-28-2023 09:06 AM
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,
12-27-2023 04:35 PM
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,
12-27-2023 05:51 PM
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.
12-28-2023 09:06 AM
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,