Data transform rules in Data Management
For a client we have a requirement where in we are bringing in EPM data into ADW, and, that data needs to be combined with Actuals data brought into ADW through FAW and rendered in reports.
However, the leaf level data for the segments are different in EPM and in ERP. Transformation rules are defined on EPM through Data Management. Those rules are applied while loading the Actuals data before loading data from Fusion to EPM.
We therefore would need to apply the same rules to the data brought in from EPM, in order to combine with Fusion data in ADW, and, reported against the ERP hierarchies.