Using Target Expressions in EPM Data Exchange
Target Expressions can be used when importing data, to apply conditions to source values before loading to the target EPM application. Oracle advise that Target Expressions should be used when possible as they are more efficient than data load mappings, especially for loading large data sets. To being, setup your integration as usual with a Location, Import Format and Data Load Rule. Then to apply Target Expressions, go to Data Exchange , open the desired integration, and select Map Dimensions , as below: For each dimension, use the Options cog to select Edit Target Expressions . The available Target Expressions are as follows: Copy Source Value Copies the exact source value to the Target. This can be used instead of a Like * to * mapping. Constant Sets a constant value, regardless of the source value. This can be used instead of a Like * to “Working” mapping, for example. Default Will apply a defa...