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

Oracle Hyperion 11.1.2.4.900 Updates

"EPM System Release 11.1.2.4.900 is intended for new deployments. If you are an existing customer with a deployed application, there is no need to upgrade to this release"

Note: This release is for installing new deployments only, it does not apply to existing deployments of EPM System. If you have an existing deployment of EPM System, then you should not use this release. You cannot upgrade to release 11.1.2.4.900 from a previous release.”

Only Financial Reporting in this version.

No Home Page in this version

One more update about Chrome Support:

27787630 -- Chrome is not supported in Release 11.1.2.4.900; however, if you do use Chrome as your browser, when you log on to EPM Workspace, you are not warned that Chrome is not supported.

27737106 -- If you log off from EPM Workspace by clicking the Log Off link or by selecting File, then Log Off, and then you log back on to EPM Workspace without closing the logon page, you will not see a Log Off link or a File > Log Off menu item.

As a workaround, exit EPM Workspace by selecting File, and then Exit, or close the browser window. When you do this, the next session will show the Log Off link and the File > Log Off menu item.

https://docs.oracle.com/cd/E57185_01/nav/deployandinstall.htm

https://docs.oracle.com/cd/E57185_01/DMOOO/epm_11124900_readme.html#epm_1112300_readme_template2_2

Thanks,
Mady

HFM Migration 11.1.2.4.200+ from Workspace

HFM migration in latest version we can do using LCM or using Import application also.

For LCM, check out below link from oracle to import artifacts.
https://docs.oracle.com/cd/E57185_01/EPMMG/epm_migrate_hfm_app.html

Utility will be in Workspace itself, we will get once we patch the system with 11.1.2.4.200+

Once we patch, we will get import application option in Consolidation Administration.

In Import application, we can give Source and Target details and start migration. Check out screen shot below:

We need to create Database links to create link between Test and Dev environment, like UDL file we create in previous versions.

Once we create Database links, we can see schema in Source HFM Database Name and in next tab we will get list HFM applications.

In next tabs, we will give destinations details like application, description, Cluster, User Management project etc. We have options here to select Import Audit Tables, Import Data Tables, Use Filter for Data.

If we planning to use filter to select particular data, we can select the above options.

once we are done with options selection, click on Import application on right top corner.

If you are not able to see import application tab or any other tabs, check out browser compatible with this version or not.

HFM Migration in upto 11.1.2.3.xxx
https://hyperion-mady.blogspot.com/2017/03/hfm-migration_30.html


How to create Database links to use importapplication for HFM

Link:

https://docs.oracle.com/cd/E12032_01/doc/epm.921/html_hfm_admin_webhelp/frameset.htm?/cd/E12032_01/doc/epm.921/html_hfm_admin_webhelp/AdminHelp-05-18.html

http://blog.checkpointllc.com/hfm-copy-application-utility-makes-a-big-return-in-11.1.2.4.2

Thanks,
Mady

Terms and Conditions

Terms and Conditions of https://hyperion-mady.blogspot.com/  Below are the Terms and Conditions for use of https://hyperion-mady.blogspot.com/. Please read these carefully. If you need to contact us regarding any aspect of the following terms of use of our website, please contact us on the following email address - madhu.hyp2011@gmail.com.  By accessing the content of https://hyperion-mady.blogspot.com/ ( hereafter referred to as website ) you agree to the terms and conditions set out herein and also accept our Privacy Policy. If you do not agree to any of the terms and conditions you should not continue to use the Website and leave immediately.  You agree that you shall not use the website for any illegal purposes, and that you will respect all applicable laws and regulations.  You agree not to use the website in a way that may impair the performance, corrupt or manipulate the content or information available on the website or reduce the overall functionality of the website.  You agree not to compromise the security of the website or attempt to gain access to secured areas of the website or attempt to access any sensitive information you may believe exist on the website or server where it is hosted.  You agree to be fully responsible for any claim, expense, losses, liability, costs including legal fees incurred by us arising from any infringement of the terms and conditions in this agreement and to which you will have agreed if you continue to use the website.  The reproduction, distribution in any method whether online or offline is strictly prohibited. The work on the website and the images, logos, text and other such information is the property of https://hyperion-mady.blogspot.com/ ( unless otherwise stated ).  Disclaimer  Though we strive to be completely accurate in the information that is presented on our site, and attempt to keep it as up to date as possible, in some cases, some of the information you find on the website may be slightly outdated.  https://hyperion-mady.blogspot.com/ reserves the right to make any modifications or corrections to the information you find on the website at any time without notice.  Change to the Terms and Conditions of Use  We reserve the right to make changes and to revise the above mentioned Terms and Conditions of use.  Last Revised: 01-02-2019