Question: Does OneStream have the equivalent of FDM logic accounts? The client wants to load the same source file data row to two different accounts in the cube.
Answer
- Yes, this can be achieved using derivative rules.
- Derivative rules apply logic to the stage data. There are two types of derivative rules, Source and Target.
- Source Derivative rules are created to apply logic defined by the inbound source data in the Stage environment.
- Target Derivative rules are created to apply logic defined by the post-transformed Stage environment data
- The design and reference guide has a lot more information on derivative rules.