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 default value when the Source is NULL, othe

Standard vs Native Smart View Ad Hoc Behaviour

In the latest July (21.07) EPM patch, Oracle have provided us with some additional enhanced ad hoc features for Standard mode applications – but if you found yourself wondering what “Standard mode” is and how it is activated, then you've come to the right blog! Firstly, a definition; there are two Smart View Ad Hoc Behaviours available in EPM: Native – this is the default mode and does not have enhanced features available.   Standard – must be switched on and enables enhanced ad hoc features. As Native is the default setting, we need to enable Standard mode in the EPM application by performing the below steps: Login to the EPM system on the web Navigate to Application -> Settings Scroll down to Smart View Ad Hoc Behaviour Use the drop down to select Standard mode Save your changes   This will then enable the “enhanced” ad hoc features in Smart View. Some of the key enhanced behaviours are: In-grid POV – Members in the 'Point Of View’ are placed