Thursday, April 28, 2022

Hyperion 11.2.9 Maintenance Release update Apr 28, 2022

 https://www.iarchsolutions.com/news/applying-the-1129-maintenance-release

A good blog to check out by iArch

Hyperion 11.2.9 - Things to know !!

Released April 28, 2022 

EPM 11.2.9.0 New features:

****EPM System Release 11.2.9 can only be applied to Release 11.2.8.***
- You must update to 11.2.8.0 first before applying 11.2.9.0.
- Application of 11.2.9 is slightly different
- Release 11.2.9 applies a set of OPatches for all EPM system components on your environment. Oracle recommends that you apply the entire set using the ApplyUpdate utility.
- Oracle recommends that you apply the set of Oracle Enterprise Performance Management System Release 11.2.9 product Opatches together, using the ApplyUpdate script. However, you can also apply selected OPatches based on your operating system
environment:

• EPM System Release now installs:
– Essbase Release 11.1.2.4.047
– Java 8 Update 321
– WebLogic Patch Set Update 12.2.1.4.220105
– ADF Bundle Patch 12.2.1.4.211221
• Added support for enabling HFM Server Connection with an SSL-Enabled Oracle
Database. See Enabling HFM Server Connection with an SSL-Enabled Oracle
Database for more details.

Tuesday, April 19, 2022

Oracle EPM Automate - System Status Website

As companies implement Oracle EPM Cloud components (FCC, Planning, ARC, etc.), EPM Automate is almost always a part of the process. 

Typically with data loads and backups, which all of the components need, but also restructures, database refreshes, and more. Along with the growth in these scripts is the need to communicate to users and admins the status of everything. 

Each script can send an email or a text with the status of each run. But with hourly data loads, backups, restructures, regression tests, etc. the number of emails can easily become overwhelming. 

An email or text should be sent if there are problems, but if things are going well, is a deluge of emails really the right solution?

As an alternative, a simple webpage can do the trick. Since EPM Automate typically runs on a server, the server can also serve up a webpage with the status of each job. 



The basic steps are to have each script write the status to a web page. 

Then use an overall web page that incorporates all of the individual status pages. 

Users can access the one overall page to see where everything is in real time.

Monday, April 4, 2022

Hyperion how to generate a deployment report after 11.2 install

 To generate a deployment report:

  1. Open a command line window and navigate to EPM_ORACLE_INSTANCE/bin.
  2. Run the command epmsys_registry.bat|.sh report deployment.

    By default, the report is saved as EPM_ORACLE_INSTANCE /diagnostics/reports/deployment_report_YYYYMMDD_HHMMSS.html.

    You can add an optional file name argument to the command to save the HTML report with a different file name or location. For example, this command saves the report as c:/epm_setup/epm_deployment.html:

    epmsys_registry.bat|.sh report deployment c:/epm_setup/epm_deployment

Hyperion 11.2 Start and Stop script using a single script

 

Starting and Stopping EPM System Using a Single Script

Use a single script to start or stop all Oracle Enterprise Performance Management System services. EPM System Installer installs a single start script in EPM_ORACLE_INSTANCE /bin, called start.bat | start.sh .

Running the single start script on a machine in your EPM System deployment starts all EPM System services installed on that machine. The single start script works by calling the individual start scripts for every product.

The user running the start script should be a member of the Administrators group.

To start EPM System services:

  1. From the Start menu, select Oracle EPM System, and then Start EPM System.
  2. Run this start script on each machine in your environment.

After the single start script completes, you can run Oracle Hyperion Enterprise Performance Management System Diagnostics to determine which services on a machine are running. See Validating the Installation and Verifying Deployment.

Note:

To stop EPM System services: A single stop script is also installed in EPM_ORACLE_INSTANCE /bin, called stop.bat | stop.sh . Running the stop script on a machine in your EPM System deployment stops all EPM System products on that machine. To stop services, from the Start menu, select Oracle EPM System, and then Stop EPM System.