Hyperion 11.2 on-premise release notes

Just released Dec 18, 2019 from Oracle

https://www.oracle.com/middleware/technologies/bi-foundation/hyperion-supported-platforms.html

https://blogs.oracle.com/proactivesupportepm/

Download from edelivery.oracle.com

Hyperion Financial Management
Supported Paths to this Release
This release does not support direct upgrade from previous releases. You must first
upgrade to the 11.1.2.4 release, then do a clean install of 11.2.0, and then migrate
data and applications. For instructions, see the Oracle Enterprise Performance
Management System Installation and Configuration Guide.

Hyperion Planning
Supported Paths to this Release
You can upgrade EPM System products to Release 11.2.0 from Release 11.1.2.4.xxx.
To update your existing applications, you deploy EPM System Release 11.2.0
software in a new location and then migrate EPM System Release 11.1.2.4.xxx
applications, data, and security to the new deployment. See “Upgrading EPM System”
in the Oracle® Enterprise Performance Management System Installation and
Configuration Guide.

Troubleshooting EPM Cloud Issues

Troubleshooting EPM Cloud Issues

https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/cgsad/8_troubleshoot_app-specific_issues_epm_cloud_heading.html

Hyperion Planning java.lang.OutOfMemoryError in Planning log file for services

Maximum permanent generation heap

If you receive java.lang.OutOfMemoryError: PermGen space errors, you may also need to increase the permanent generation space.

Fix:
Goto your Planning server
Open Regedit
Navigate to your Hyperion Solutions and Planning0 registry settings

-XX:PermSize=256m
-XX:MaxPerSize=512m-Xss512k

HFM to EPM Cloud Migration Utility information

Utility 1: The EPM Cloud Migration Accelerator (ECMA) is a utility designed to facilitate the migration of metadata from Hyperion Financial Management (HFM) to Financial Consolidation and Close Cloud Service (FCCS). This utility can be downloaded via My Oracle Support (MOS) as Patch 28352563: EPM CLOUD MIGRATION ACCELERATOR.

Actions:

1. Download Patch 28352563, which contains the EPM Cloud Migration Accelerator (ECMA), ZIP and README files
2. Review the whitepaper on migrating artifacts (included under the "UserDocumentation" folder in the ZIP file)
3. Review the sample applications created using ECMA (included under folders: "HFM_SAMPLE_EXPORTS" "FCCS_Skeleton_Apps" in the ZIP file)
4. Review the FAQ section below

 FAQ:

1. What is the current version of HFM to EPM Cloud Migration Accelerator (ECMA)?
   1. V 1.0
2. Does ECMA support previous versions of HFM ?
   1. Currently we support 11.1.2.3.XXX and 11.1.2.4.XXX ONLY. If you are on prior versions please upgrade HFM to latest versions first.
3. Does ECMA conform to the CLOUD release cycle?
   1. No, ECMA will be released via MOS as changes are needed

Utility 2: The Financial Reporting Migration Tool (FRMT) is a utility designed to facilitate the migration and conversion of Financial Reports from Hyperion Financial Management (HFM) to Financial Consolidation and Close Cloud Service (FCCS) report formats. This utility can be downloaded via My Oracle Support (MOS) as Patch 29228721: FINANCIAL REPORTS MIGRATION

Actions:

1. Download Patch 29228721, which contains the Financial Reporting Migration Tool ZIP and README files
2. Review the User Guide on migrating reports (included under the "01 README" folder in the ZIP file)
3. Review the example reports converted using FRMT (included under the “04 Examples” folder in the ZIP file)
4. Review the FAQ section below

 FAQ:

1. What is the current version of the referenced utilities?
1. V 1.0
2. Do the utilities support previous versions of HFM ?
1. Currently we support 11.1.2.3.XXX and 11.1.2.4.XXX ONLY. If you are on prior versions, please upgrade HFM to latest versions first.
3. Do the utilities conform to the CLOUD release cycle?
   1. No, they will be released via MOS as changes are needed

Hyperion FDMEE not starting - Weblogic issue

Recently we had a scenario where our FDMEE service would start, but the application will not open up in Workspace.
After logging into Weblogic Console http://servername:7001/console we noticed that the ERPIntegrator service said Starting.

We applied the following fix:

1. Stop all FDMEE services

2. Move the WLS_DIAGNOSTICS(number).DAT files from the \Oracle\Middleware\user_projects\domains\EPMSystem\servers\ErpIntegrator0\data\store\diagnostics folder and move to a different folder.

3. The files can be deleted after the managed server has started.

4: Start FDMEE services

Issue was with Weblogic DAT files in the folder being created on each service restart

Hyperion 11.2 and 11.1.2.4 release updates for on-premise

Follow the link below to read more about 11.2 and 11.1.2.4

https://blogs.oracle.com/proactivesupportepm/hyperion-enterprise-performance-management-epm-112-on-premises-release-information

Announcing Continuous Innovation on Oracle Hyperion Enterprise Performance Management System 11.2

https://www.oracle.com/a/ocom/docs/support/hyperion-epm-announcement.pdf

Hyperion DRM 11.2 readme and features

Please check link below for Hyperion 11.2 DRM features

https://blogs.oracle.com/proactivesupportepm/oracle-data-relationship-management-drm-on-premise-product-plans-for-112

Hyperion EPM Product/Features Discontinued in 11.2

Hyperion Financial Management
– Financial Management Analytics
– Essbase Analytics Link for Hyperion Financial Management
– Quantitative Management and Reporting for Solvency

Hyperion BI+
– Interactive Reporting (IR)
– Production Reporting (SQR)
– Web Analysis (WA)

Hyperion Planning
– Hyperion Strategic Finance (HSF)
– Crystal Ball (replaced by Predictive Planning)
– Simplified User Interface (SUI)
– Workforce Planning
– Capital Expense Planning
– Project Financial Planning
– Offline Planning

 Additional
– Disclosure Management
– EPM Mobile

Hyperion 11.2 key announcement

Key Announcement
• EPM Architect (EPMA) will NOT available as a foundation component in EPM 11.2 and beyond
• For existing deployments of EPM Architect: – Oracle Data Relationship Management will be offered under a restricted use license to facilitate Oracle Hyperion EPM (on premise only) dimension maintenance – Alternatively convert to “classic”
• A Migration Kit will be published including a whitepaper and scripts to assist with dimension extraction from EPMA to DRM

Hyperion 11.2 announced at Kscope19

On-Premises Release: 11.2 – The Details
• Scheduled for September, 2019
• Technical upgrade – out of place install
• Uplift to FMW 12g release
• Oracle Essbase 11.1.2.4 will still be used for Hyperion EPM 11.2
• Repository Simplification – Replace Foundation services with a simpler RDBMS repository – Content migration for FR/Workspace to RDBMS repository – Streamlines and simplifies infrastructure for the future
• 3rd party certifications* including: – OS: Windows 2012, 2016 (Linux 7 & AIX 7.2 to follow in subsequent PSU) – RDBMS: Oracle 12.2, SQL Server 2017 – Browser: Edge, Chrome, Firefox – JDK 1.8
• Enhancements delivered thru a series of feature bearing PSUs – Modelled on the 11.1.2.4.20x series

Planning and Smartview connection issue - Invalid User and Password message is misleading

We had a situation where users were unable to use Smartview with Planning and getting error message that Invalid User ID/Password. 

Once we asked the users to use Workspace, they got a message that "Application is in Maintenance Mode and no connections are allowed".  We asked the HP admin to make the application available to users.  This resolved the issue.

The Smartview message was misleading and it caused many users to lockout their AD accounts.

Supported Versions of Oracle RDB for Enterprise Performance Management (EPM) / Hyperion 11.1.2.4.x

https://blogs.oracle.com/proactivesupportepm/supported-versions-of-oracle-rdb-for-enterprise-performance-management-epm-hyperion-11124x

According to the document:

• Oracle DB version 12.2.0.2 was rebranded as Oracle DB version 18 and is certified with 11.1.2.4.x releases of EPM.
• DB version 12.2 was rebranded as Oracle DB version 19 and it, too, is certified with 11.1.2.4.x releases of EPM.

Hyperion DRM Query record limit

Recently we had an issue while running various queries in DRM, we would only get 5000 records.  While looking at System Preferences, this was discovered.
You can go into Administer, System Preferences and then WarnHL.
Default limit is 5000 records.  You can change this limit to a higher number, save the changes and re-run your queries.

Hyperion Calculation Manager Issues With Hyperion Planning

 Tuning considerations

• In the calcMgrConfig.properties file you may want to increase the HBR.timeout to 60000 and remove the comment # from this row
• In addition to traditional java settings of Xms and Xms you may want to consider increasing the default stack size as well –Xss
• Oracle recommends rules that take longer than one hour to be run in batch, not on the web but if you have some that take longer, consider increasing the session timeout on the web application server

11.1.2.x

Most issues with calculation manager will be captured in one of the following logs by default:

\\Oracle\Middleware\user_projects\domains\EPMSystem\servers\CalcMgr0\logs

Hyperion On-Premise 11.2 Features

On-Premises Release: 11.2 

• Scheduled for mid 2019
• Uplift to FMW 12g release
• Repository Simplification
 – Replacing of Foundation services with a simpler RDBMS repository
 – Content migration for FR/Workspace to RDBMS repository
• 3rd party certifications including:
 – OS: Linux 7, AIX 7.2, Windows 2016
 – RDBMS: Oracle 12.2, SQL Server 2016,
 – Browser: Edge, Chrome, Firefox
 – JDK 1.8
• Technical upgrade – out of place install
• Followed by a series of feature bearing PSUs
 – Modelled on the 11.1.2.4.20x series

Hyperion Financial Management 

 – Autonomous Consolidations 

 – Web based Metadata Editor 

 – Archiving\Deleting unwanted data 

 – Performance improvements 

SmartView

 – DB batch processing, etc.

Hyperion Planning 

 – Smart Push 

 – Dimension Editor SV extension 

 – Extended Attribute support 

 – Valid Intersections 

Data Relationship Management 

 – Scheduled Import, Exports & Books 

 – DRG Mass Approvals

Hyperion Financial Management Reports Migration to EPM Cloud

New Tool introduced for HFM Reports migration to EPM Cloud

https://cloudmarketplace.oracle.com/marketplace/en_US/listing/50393071

Hyperion Calculation Manager Performance Issue - Expanding Planning/Essbase node takes 5 Minutes

While attempting to Expand the Planing/Essbase node in Calculation Manager,  the user is observing it takes more than 5 minutes to display the contents.

STEPS
-----------------------
1. Login to calculation manager 
2. Expand the Planning/Essbase Tree (node)
3. Takes close to 5 minutes for the Tree to expand and display the contents

In order to resolve this, try this out on the server where Calc Manager is installed:

• Verify that the Dimension service is started and is up and running
• Start the Dimension server service if it is in the shut-down status
• Wait 2-3 minutes for the service to become stable
• Try to login into Calc Manager and expand the node

Hyperion DRM record count

Hyperion DRM product licensing is record based.  If you are looking to see how many records are in use, run the below statement.  You need to know your Current Working Version.

Select N.i_version_id as "Version ID", V.c_abbrev as "Version Name", V.e_version_status as "Version Status", Count(*) as "Node Count"
From RM_Node N
Join RM_Version V on (N.i_version_id = V.i_version_id)
Where V.e_version_type = 'Normal'
Group by N.i_version_id, V.c_abbrev, V.e_version_status
Order by N.i_version_id Desc