An Overview of Hyperion and EPM Cloud Technical Architecture

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:

Open a command line window and navigate to EPM_ORACLE_INSTANCE/bin.
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:

From the Start menu, select Oracle EPM System, and then Start EPM System.
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.

Wednesday, March 2, 2022

Using Essbase 21c with EPM System

Beginning with Release 11.2.8, you can use Oracle Hyperion Planning and Oracle Hyperion Profitability and Cost Management applications from an Oracle Enterprise Performance Management System deployment to report on Oracle Essbase cubes in a Oracle Essbase 21c deployment integrated with EPM Shared Services.

Installation considerations in a Linux distributed environment:

Machine 1 - Install and configure all the EPM system products such as Hyperion Shared Servics, Financial Reporting, PLanning and Calculation Manager.
Machine 2 - Install and configure HPCM and Essbase 21c. Set up Essbase 21c and register it to Hyperion Shared services running on Machine 1.
Note:
- Hyperion Profitability and Cost Management must be Installed and Configured on Machine 2 along with Essbase 21.2.2 where APS is up and running.
- If you choose to use Essbase 21c instead of Essbase 11.1.2.x, ensure that you perform an upgrade only via LCM to import your Planning applications.
- Essbase 21c is only supported in NON_HYBRID mode.

Tuesday, January 4, 2022

Hyperion Essbase Patch Set Update 11.1.2.4.047

The Hyperion Product Management recently advised the release of Patch Set Updates (PSU) for Oracle Hyperion Essbase 11.1.2.4.x.

These PSU downloads are available from the My Oracle Support > Patches & Updates section.

Hyperion Essbase Server 11.1.2.4.047

33485383 - Hyperion Essbase Server

Hyperion Essbase Client 11.1.2.4.047

33485386 - Hyperion Essbase RTC
33485381 - Hyperion Essbase Client MSI
33485376 - Hyperion Essbase Client

Hyperion Essbase Administration Services 11.1.2.4.047

33485370 - Hyperion Essbase Administration Services Server
33485372 - Hyperion Essbase Administration Services Client MSI

Hyperion Analytic Provider Services 11.1.2.4.047

33485394 - Hyperion Analytic Provider Services

README FILE:

Refer to the Readme files prior to proceeding with these PSU implementations for important information that includes the supported paths per component, along with a full list of the defects fixed, additional support information, prerequisites, details for applying patch and troubleshooting FAQ's. It is important to ensure that the requirements and support paths to this patch are met as outlined within the Readme file.

The Readme file is available from the Patches & Updates download screen for each of the Hyperion Essbase components.

Recommendations:

Caution: Oracle recommends using the same version of all Essbase portfolio products (Essbase, Essbase Administration Services, Hyperion Provider Services, and Essbase Studio) and components (server, client, runtime client, API, and JAPI). When only some Essbase portfolio products are included in a patch release, the last released versions of the products that are not included in the patch are supported.

Essbase Administration Services 11.1.2.4.047, Provider Services 11.1.2.4.047, and Essbase Studio 11.1.2.4.045 are supported for use with Essbase 11.1.2.4.047. Furthermore, Essbase Runtime Client needs to be updated on systems that Essbase Administration Services is installed starting with this patch.

Recommendation: After you apply a patch within the same release codeline, Oracle recommends as a best practice that you export the data from your databases, clear the data from the databases, and then reload the data.

Unsupported Features:

MaxL Perl Module Will No Longer Be Supported in 12.2.1.3.0
Essbase Native Security Mode Is No Longer Supported

Defects Fixed in this Patch:

33606460 - ANY RETRIEVE ON TBLAST MEMBER IS HAVING PERFORMANCE ISSUES
30043421 - DATA EXPORT IS NOT EXPORTING DATA AT BASE MEMBER INSTEAD AT IMPLIED SHARING MEMBER
33060864 - PORT TO 11.1.2.4.046: 32901984 - REQUEST FIX PLANNING BUG 32674898
33434920 - PORT TO 11.1.2.4.047: 31645024 - ESSBASE ASO ALLOCATION RUNNING SLOW IN 11.1.2.4 COMPARED TO 11.1.2.1
31804508 - SIGNIFICANT PERFORMANCE LOSS IN RUNNING CERTAIN MAXL SCRIPTS AFTER APPLYING ESSBASE .039 PATCH

======================================================================================

For your references:

Available Patch Sets and Patch Set Updates for Oracle Hyperion Essbase Doc ID 1396084.1
Oracle EPM System Documentation