Hyperion HFM upgrade to 11.1.2.4 and changes in Log File and Processes

Going thru an upgrade from 11.1.2.2 to 11.1.2.4 HFM and we noticed certain log files location have changed and the HFM services/processes also look different now.

See below of what we discovered:

• Financial Management - Located in: EPM_ORACLE_INSTANCE/diagnostics/logs/hfm
  • xfm.odl.<APPLICATION_NAME>.log — Financial Management Application Server core activity (per application)
  • oracle-epm-fm-hsx-server.log — Financial Management Java Serverlog
  • oracle-epm-fm-bi-publisher.log — Logs for Financial Management to BI Publisher interaction
  • oracle-epm-fm-hsx-registry.log — Logs for Financial Management to Shared Services Registry interaction
  • oracle-epm-fm-lcm-client.log — Logs for Financial Management to Lifecycle Management interaction
  • SharedServices_Security.log — Logs for Financial Management to Shared Services Security API interaction
• FinancialManagement Web Application - Located in: MIDDLEWARE_HOME/user_projects/domains/EPMSystem/servers/HFMWeb0/logs/hfm  AND MIDDLEWARE_HOME/user_projects/domains/EPMSystem/servers/HFMWeb0/logs/
• oracle-epm-fm.log — Financial Management Java web application activity
• oracle-adf.log — Financial Management ADF logs
• HFMWeb0.log — Financial Management domain logs
• HFMWeb0diagnostic.log — Financial Management domain diagnostic logs
• oracle-jrf.log — Financial Management JRF logs

The Windows processes of HFM application server for 11.1.1.3.x to 11.1.2.3.x used to be:

• HsxService.exe
• HsxServer.exe
• CASSecurity.exe 
• HsvDatasource.exe

Now with HFM 11.1.2.4.x we noticed this:

• HyS9FinancialManagementJavaServer_instanceName 
  
• HyS9FinancialManagementWeb_instanceName
• XFMDatasource.exe

You will notice this in your Windows Task Manager, when you start the services.

Installing Hyperion Planning Admin extension for Smartview

This blog will show you how to install the Hyperion Planning Admin extension for use with Smartview.

1 - Login into Workspace, then click on Tools, then Install and then click on Planning Admin Extension.  Save the file on your local C: folder or a software folder where you wish this file to be available to other users.

The file saved will be called PlanningSVExtension.msi

2 - Before you run the MSI file, login into your Smartview to ensure that you don't have the Extension installed already.

3 - Now lets run the MSI installer

4 - Now lets login into Smartview and goto Options and view Extensions.  You will notice that now i have the new Hyperion Planning extension installed.

5 - If you navigate now in Smartview to your Planning app (In my case I will login into my sample Vision application), you will notice at the bottom I can perform Create and Refresh Database like how I used to do in Workspace.

Your Planning system admins who like to stay within Excel and Smartview can now benefit from this great feature.

DRM Migration Utility

DRM comes with a nice Migration utility to migration DRM objects from one environment to the other.

Below are some screen shots:

1 - Login into your DRM URL http://servername/drm-migration-client/

Login with your Admin or MSAD id.  Then click on Extract option

You will come across the following screen.  Select which object you like to migrate or select All.  In the example below my extract is called QADRM

Once you select All and clicked on Extract, you will see a screen like the one below.  Click on Next.

Provide Title and other information for your Extract

File is extracted in XML format.  Save it on your desktop and then load the xml file into your Target environment using the same URL.

Hyperion Planning 11.1.2.4 and Data Form Diagnostics utility

Good day,

Recently we upgraded from 11.1.2.2. to 11.1.2.4 and some of our Webforms in 11.1.2.2 were taking a long time to run.  We came across a nice utility that comes out of the box with 11.1.2.4 that will tell you how much time each Webform is taking.

Below is the sample Vision app and how to use the utility:

1 - Login in Vision Planning application and navigate to Tools, Diagnostics, Grids

2 - Select all the forms and then click on Run Diagnostics on the bottom right side

3 - Click on the Green area, and you will notice all the Webforms taking less than 1 second

4 - Click on the Yellow area and you will see that I have 1 form taking more than 1 second to run.  Between 1 and 5s

This is a great utility which can help your Planning admins monitor new Webforms and modify/update existing Webforms for optimal performance tuning.

Thanks,

Azmat Bhatti