Mapping Applications and Substitution Variables

When mapping an application that contains substitution variables, note:

Substitution variables are checked when you click Push Data, not while application mappings are defined.
For dimension-to-dimension mappings on the Map Dimensions tab:
- The member selector displays Oracle Essbase substitution variables defined only for the Oracle Hyperion Planning application and for all Essbase applications.
- For the Planning application, the variable name that is selected or typed is passed and evaluated when you click Push Data.
- For the reporting application, the variable name is evaluated against the Planning application, and then the value is used in the Clear Data operation.
For Point of View fields on the Point of View tab:
- For the Planning application, the member selector displays the Essbase substitution variables defined only for the Planning application and for all Essbase applications. The variable names that are selected or typed are passed and evaluated by Essbase when you click Push Data.
- For the reporting application, the member selector displays the substitution variables defined only for the reporting application and for all Essbase applications. It is evaluated against the reporting application, and the evaluated value is validated against the respective reporting dimension for the single member and no member function.
If metadata in a reporting application has been modified, click Refresh before editing or pushing data to synchronize reporting dimensions and members with Planning. For example, if a dimension or member was added to a reporting application, clicking Refresh makes the member visible in Planning. Refreshing changes from reporting application metadata may cause mappings to become invalid.