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 the substitution variables that were defined for the Planning application.

    • 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 substitution variables that were defined for the Planning application. The variable names that are selected or typed are passed and evaluated when you click Push Data.

    • For the reporting application, the member selector displays the substitution variables defined only for the reporting application. 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.