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