Hyperion 11.2 and converting EPMA applications to Classic Mode or DRM Lite !

EPMA is deprecated from EPM 11.2.x version.  So if you are running the EPMA app, you now have two options:  

• Convert EPMA applications to Classic application OR
• Use DRM to manage the metadata

To convert EPMA to DRM, the first step is to re-format the ADS file, which you can export from the EPMA into a DRM readable format.

Pre-requisites: 

• ADS file exported from the application using EPM File Generator  (Guide to extract metadata into ADS file)
• Java 8 or above
• Patch downloaded from OTN Patch 30695700

Formatting steps:

• The Dimension section is converted to 'hierarchy' in the DRM
• !Section=Dimensions to [hier]
• The Hierarchies section is converted to 'relations' in the DRM
• !Hierarchies=Scenario to [relation]
• Delimiter supported is | and ;
• There is no header line in the exported DRM format file as it does not support header description
• The field names should not have a comma 

Steps:

     

• Set Java in the environment variables
• Command: java DRM_ADS ads_orig.txt ads_drmformat.txt

Supported Migration Paths to Oracle EPM System Release 11.2.5 Hyperion on-premise release

 You can move to Oracle Enterprise Performance Management System Release 11.2.5 from the following releases:

• Release 11.2.4. To move from EPM System Release 11.2.4 to Release 11.2.5, use the Apply Update option in EPM System Installer. See Applying an Update to EPM System Products in the Oracle® Enterprise Performance Management System Installation and Configuration Guide.

• Release 11.2.3. To move from EPM System Release 11.2.3 to Release 11.2.5, use the Apply Update option in EPM System Installer. See Applying an Update to EPM System Products in the Oracle® Enterprise Performance Management System Installation and Configuration Guide.

• Release 11.2.2. To move from EPM System Release 11.2.2 to Release 11.2.5, first apply the update to move to Release 11.2.3 or Release 11.2.4, and then apply the update to move to Release 11.2.5. See Applying an Update to EPM System Products in the Oracle® Enterprise Performance Management System Installation and Configuration Guide.

• Release 11.2.1. To move from EPM System Release 11.2.1 to Release 11.2.5, first apply the update to move to Release 11.2.3, and then apply the update to move to Release 11.2.5. See Applying an Update to EPM System Products in the Oracle® Enterprise Performance Management System Installation and Configuration Guide.

• Release 11.2.0. To move from EPM System Release 11.2.0 to Release 11.2.5, first apply the update to move to Release 11.2.2, then apply the update to move from Release 11.2.2 to Release 11.2.4, and then apply the update to move from Release 11.2.4 to Release 11.2.5. See Applying an Update to EPM System Products in the Oracle® Enterprise Performance Management System Installation and Configuration Guide.

• Release 11.1.2.4. You can upgrade EPM System Release 11.1.2.4 products to Release 11.2.x. To update your existing applications, you deploy EPM System Release 11.2.x software on a new machine and then migrate EPM System Release 11.1.2.4.xxx artifacts (such as applications, metadata, and security) and data to the new deployment. See Upgrading EPM System in the Oracle® Enterprise Performance Management System Installation and Configuration Guide.

Oracle Hyperion 11.2.5 features - April 2021

Key Features

• Delivery of Fusion Middleware 12.2.1.4 (certification matrix) and Java version 1.8.0_251.
• Certification of SQL Server 2017.
• Certification of Essbase 21c for Oracle Smart View for Office, Oracle Hyperion Financial Reporting, and Oracle Hyperion Shared Services.
• Certification of upgrade and migration from Solaris to Linux.
• Certification of upgrade and migration from Solaris to Windows.
• Certification of the ability to upgrade Java to the latest patch level.
• The ability to apply an update directly from Release 11.2.3 and Release 11.2.4.

Financial Close Management New Features

• Beginning with Release 11.2.5, you can configure a content management system for Oracle Hyperion Financial Close Management.

Planning New Features

• Support for Adding Dynamic Members in Smart View