Latest - April 2018 - Hyperion On-Premise update from Collaborate 2018

On Premises Releases

• 11.1.2.3 – S1 defect fixing only until March 2018

• 11.1.2.4 – Defect Fixing, 3rd party certification updates, enhancements thru Dec 2020

• 11.2 – Scheduled for early 2019 – Uplift to FMW 12g release – Repository Simplification released early 2018

• Remove of Foundation services with a content migration for FR/Workspace to RDBMS repository – Defect Fixing, 3rd party certification updates, enhancements thru Dec 2030

Financial Reporting Studio FR Client and updating the Workspace, Tools, Install folder location

Recently we had to upgrade our FR software.  The patch came with new FR Studio Client.  The file that you need to update, so that users can download from Workspace, Tools, Install folder is this path:

E:\Oracle\Middleware\EPMSystem11R1\products\financialreporting\install\bin
- Rename the old FinancialReportingStudio.exe file
- Copy the new file from the downloaded patch folder

Note: E drive is where i installed my Hyperion software.

Essbase removing Zeros script

SET UpdateCalc Off;

Actual (
   IF (Actual==0)
       #Missing;
   ENDIF)

HFM Task Flow and Schedule task not running on time

We upgraded to 11.1.2.4 from 11.1.2.2 and noticed our Task Flow scheduling jobs would not run on the given date/time.  After opening Oracle SR and going thru a bunch of patches, this was discovered:

You need to patch your Planning to 11.1.2.4.007 (And some pre-requisite patches) since there is a component called the "Quartz Scheduler" used by Planning, HFM and Calc Manager.
Oracle Development has determined the issue is caused how Planning interacts with the scheduler. That is why the Patch is coming from the planning.

Issue now resolved.

Thanks,

Hyperion Patching 11.1.2.4 and Review Patches applied command

Many times we run into situation where we have applied a patch PSE or PSU and we forgot to note it down.   You can run this command on each server and review the patches applied with Patch Details, Date and Time:

Results will be stored in your Hyperion Folder under this path (I have my Oracle software installed under E drive)  E:\Oracle\Middleware\EPMSystem11R1\cfgtoollogs\opatch

Filename will be opatchYYYY-MM-DD_HH-MM-SS(AMorPM)_1.log

Use Notepad++ for the best viewing option

1. From a command line, change the directory to <EPM_ORACLE_HOME>/OPatch (example C:\Oracle\Middleware\EPMSystem11R1\OPatch)
2. For Windows run: (make sure to confirm the proper JDK path - refer to the example below)
   
   opatch.bat lsinventory -oh <EPM_ORACLE_HOME> -jdk <MIDDLEWARE_HOME>/jdk160_29 > patchlist_servername.txt 

Hyperion EPM Automate Utility for Cloud and Commands

Here is a link to explore various commands that you can use with EPM Automate Utility

https://docs.oracle.com/cloud/latest/epm-common/CEPMA/epm_automate_command_ref_general.htm#CEPMA-GUID-5400C490-264F-493A-9EAD-267AB2A320F1

Hyperion EPM Cloud supported Browsers

Link for supported Browsers for EPM Cloud

https://docs.oracle.com/cloud/latest/epm-common/CGSAD/1_epm_cloud_prereq_supported_browsers.htm#CGSAD-GUID-EFA6BF16-F17F-4852-A84B-B16ED6338994