My Oracle Support Banner

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

Last updated on SEPTEMBER 22, 2022

Applies to:

Hyperion Planning - Version and later
Hyperion Essbase - Version and later
Hyperion Financial Management - Version and later
Information in this document applies to any platform.


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

As of Oracle EPM, 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, 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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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