Oracle Hyperion FDM to FDMEE Migration Utility

Oracle that explains step by step process involved in migrating Oracle Hyperion FDM to Oracle FDMEE. It also discusses the challenges faced during the migration. It is intended to have a ‘look and feel’ of using the FDM Migration utility.

In EPM Release 11.1.2.4, FDM is no longer available. All customers who wish to continue using the key FDM functionality can migrate to FDMEE.

It captures key functionality from FDM, and preserves the ERP Integrator framework that enables users to load metadata and data, and to drill-through and write-back.

Pre requisites
 Download Patch 21379349: FDM CLASSIC TO FDMEE MIGRATION UTILITY V 1.0
 Working 11.1.2.x FDM Application Database
 Database details of the FDM application Schema
 Working FDMEE 11.1.2.4 Environment
 Downloaded FDM-FDMEE Migration Utility
 Database details of FDMEE Schema
 ODI studio Installed & Configured

Steps Involved in Migration
 Run the Prerequisite SQL Scripts in FDMEE & FDM Database
 Configure FDM Data source on ODI
 Import the Scenarios to ODI Designer
 Execute the Scenario from ODI
 Challenges in Migration

For complete migration steps, check Oracle FDMtoFDMEE_Migration_Whitepaper:
Oracle Hyperion Financial Data Quality Management (FDM) to Oracle Hyperion Financial Data Quality Management, Enterprise Edition (FDMEE) - White Paper on FDM to FDMEE Migration Utility (Doc ID 2077244.1)
http://docs.oracle.com/cd/E57185_01/epm.1112/fdm_migration.pdf

Thanks,
Mady

Hyperion 11.2 version release details and support details

Oracle is today announcing a “Continuous Innovation” release model for Oracle Hyperion
Enterprise Performance Management System 11.2, delivering ongoing applications and
underlying technology stack updates without a major upgrade. At the same time, we are
announcing Oracle Premier Support for Oracle Hyperion EPM System 11.2 through at least
2030.

This means that after upgrading to release 11.2 when it becomes available, Oracle Hyperion
EPM System customers running on release 11.2 will be able to continue to access new
applications functionality and separately uptake later versions of underlying technology for
years to come, without the time and expense of a major release upgrade.

Reference:

https://www.oracle.com/a/ocom/docs/support/hyperion-epm-announcement.pdf

Thanks,

Mady

How to change Hyperion Workspace Logo on Login Screen

To change Hyperion Workspace LOGO in Login page, we need to follow the steps:

We need to change login_panel.gif image with your desired image in bpmui.ear and Workspace.ear files.

To change ear file, follow below steps:

Go to Oracle/Middleware/EPMsystem11R1/common/bpmui-common/11.1.2.0

Here you can find bpmui.ear file.

Open the same with 7zip, then go to below location change login_panel.gif to your file.
Note: Move to Login_Panel.gif file to Login_Panel.gif_ORIG then copy your file to WAR file.
/bpmstatic/themes/theme_tadpole/images_global
/bpmstatic/themes/theme_skyros/images_global
/bpmstatic/themes/theme_fusionfx/images_global
/bpmstatic/themes/theme_tadpole_hc/images_global

Now go to below Path for Workspace.ear file.

<EPM_ORACLE_HOME>products/Foundation/workspace/InstallableApps

Workspace.ear file and open with 7zip go to below path and change you login_panel.gif file with Original file.

workspace.war/bpmstatic/themes/theme_skyros/images_global
workspace.war/bpmstatic/themes/theme_tadpole/images_global
workspace.war/bpmstatic/themes/theme_tadpole_hc/images_global
workspace.war/bpmstatic/themes/theme_fusionfx/images_global

clear tmp and cache from Foundation0 and clear browser cache.






Thanks,
Mady

How to change Hyperion Workspace Name in Title bar

We got a reruirement today from client is it possible to change or update Oracle Hyperion Workspace or Title bar or both with client name or by environment. Yes it is possible. As we have many blogs on the same and also articles in Oracle MySupport.

So, here are the steps to update the same.

First of all, Thanks to Kamalanathan Prabhakaran for giving this idea to post and for helping in this activity.

Steps for change Title in Title Bar.

1.Navigate to below folder
D:/oracle/Middleware/EPMSystem11R1/products/Foundation/workspace/InstallableApps/

2.Take backup of workspace.ear as workspace.ear_ORIG

3.Copy the workspace.ear to local machine

4.Open workspace.earand then workspace.war using 7zip

5.Edit index.jsp and change the below entries

from
// Get the config options
IConfig      rConfig = ConfigFactory.getConfig(application);
String     rstTitle = ConfigHelper.getApplicationName(application);

to
 // Get the config options
IConfig rConfig = ConfigFactory.getConfig(application);
String     rstTitle1 = ConfigHelper.getApplicationName(application);
String rstTitle2 = "   PROD  "; String rstTitle = rstTitle1 + rstTitle2;

6.save it and upload and replace the existing workspace.ear

7.Move or delete tmp and cache of foundation Managed server

8.Restart the Hyperion services

Thanks,
Mady

Hyperion configuration question: Same weblogic doamin server for Windows and Linux??

One of my friend asked me, question about why we can't use same weblogic domain between Windows and Linux servers in case setting up Hyperion in distribution environment.

Well, i will ask the same question in this way, If we have Hyperion distribution environment setup with set of servers Windows and Linux. Installed Hyperion components in Windows and Linux server, while try ing to configure Did you face any issues while deploying web applications to weblogic? Did you deployed to same domain all web applications from windows and Linux?

Or Simply If you have Hyperion distribution environment setup with Windows and Linux servers, how many Admin servers will you have??

Generally, Whenever we install and configure Foundation components along with foundation, Weblogic will also get deployed. So, generally we will say weblogic will installed along with Foundation. So Admin server will be in Foundation server. But in case of distribution environment, you foundation in windows and Planning, Essbase in Linux, you same weblogic won't work for windows and Linux. Because Weblogic won't accept accessing between 2 different platforms.
It will error out, while doing configuration with Foundation windows server weblogic domain details.
So, either we need create new domain or use existing domain of same platform.

Thanks to Naresh Addala, Lova Ramisetti for helping in this post.

Thanks,
Mady

Oracle PBCS Topics - Questions

Importing and Exporting Data and Metadata in Oracle Planning and Budgeting Cloud

Extracting Data from Oracle Planning and Budgeting Cloud using Data Management

Adding Excel Formulas in Oracle Planning and Budgeting Cloud

Creating Smart forms using Excel.

Integrated EPM Business Process Flows

Designing Custom Navigation Flows

Oracle Hyperion Patching - lsinventory command

If you want to check whatever patches are there in you hyperion server, you can search with lsinventory command.

Go to cmd and route below the path. Then run lsinventory command with optach.bat as mentioned below, you can list of patches applied on that patch.

 "D:\oracle\Middleware\EPMSystem11R1\OPatch" or wherever you have opatch folder.

Run the following script:
opatch.bat lsinventory -oh D:\Oracle\Middleware\EPMSystem11R1 -jre D:\Oracle\Middleware\jdk160_21

 -oh = Oracle home location = Oracle_Home
-jre = Jre location

Thanks,
Mady