Migrating Data to Environments

How do I perform a Production-to-Test Data Migration?

You migrate data from production to test using the Clone feature. See:

• Cloning EPM Cloud Environments in Administering Migration for Oracle Enterprise Performance Management Cloud.
• Alternatively, you can use the cloneEnvironment command in EPM Automate.
• You can also use the Clone an Environment REST API.

If you want to migrate only selected artifacts from production to test: you can go to Migration UI, select the individual artifacts, and export them from the production environment, then, you can copy that snapshot using copysnapshotfrominstance EPM Automate command. Once the snapshot is on the test environment, you can import it using Migration UI or importsnapshot EPM Automate command.

How to resolve a cloning error?

If you encounter an error while using the Clone Environment screen, the cloneEnvironment command in EPM Automate, or the Clone an Environment REST API, refer to the troubleshooting steps in Resolving Clone Environment Issues section of the Oracle Enterprise Performance Management Cloud Operations Guide.

How are data values stored in Essbase, and what causes it to load a value like ‘10’ as ’10.00000000001’?

Oracle Essbase represents cell values as IEEE double values. Doubles have a maximum of 15 significant digits of precision. Anything beyond the 15th digit is imprecise. For more information, see "Data Values in EPM Cloud" in About Essbase in Cloud EPM.