How to Migrate Essbase Substitution Variables managed by Calculation Manager (Doc ID 1471488.1)

Last updated on SEPTEMBER 22, 2022

Applies to:

Goal

How to Migrating Essbase Substitution Variables, which are managed in Calculation Manager, to another environment.

As of Oracle EPM 11.1.2.1, it's not possible to migrate Essbase Substitution Variables from/ to Calculation Manager via LCM separately.

However, it's possible to migrate rules from/ to Calculation Manager via LCM. During this process all corresponding variables (of any type) are migrated alongside the rule. This makes sense since variables are eventually used by a rule.

However the situation is different for Essbase Substitution Variables since they are not necessarily part of any rule but are still required for Planning and Essbase to function.

As of Oracle EPM 11.1.2.1, Essbase Substitution Variables can be migrated as part of the Planning LCM, BUT this means that those Essbase Substitution Variables will only be exported/ imported directly to/ from Essbase during such Planning LCM. It will not create the Essbase Substitution Variable records within Calculation Manager. To clarify, Planning, Essbase and HFM (Oracle EPM product) are naturally not aware of the Calculation Manager (CM). CM is a separate Oracle EPM system component which allows to centrally manage rules and its variables. Only after deploying a rule or variable, they become known to the corresponding Oracle EPM product. It's a one way communication and thus it's not possible to "upgrade" an Essbase Substitution Variable from Essbase to Calculation Manager by using EAS etc.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.