02-06-2024 11:33 PM - last edited on 02-07-2024 05:20 AM by JackLacava
Hello,
We've a requirement where based on certain condition, data source record needs to go to two or more targets. For example, we've expense amount in source data that needs to be go to different SG&A Category (like R&D, Marketing, etc) based on percentages. and these %s are different for different account.
we've not used derivative or lookup transformation yet but it seems it can be achieved. i was going through the documentation but it is not very clear. Pls let me know if we're thinking in right direction or if you can help with some sample, would be really helpful
Solved! Go to Solution.
02-07-2024 04:30 AM
You are correct - Derivative rules are what you need. In your case you need Final not Interim rules as the data will be loaded into the Cube. If you search OneCommunity for Derivative you will get more guidance. Once you understand the principles the Design and Reference guide has some good examples.
If you are still stuck, post an example of the source data and what you want to load into the Cube.
02-07-2024 04:30 AM
You are correct - Derivative rules are what you need. In your case you need Final not Interim rules as the data will be loaded into the Cube. If you search OneCommunity for Derivative you will get more guidance. Once you understand the principles the Design and Reference guide has some good examples.
If you are still stuck, post an example of the source data and what you want to load into the Cube.
02-09-2024 06:02 AM
yes, i was able to understand this concept. thanks a lot!