Oracle Hyperion: Middleware Home - EPM Oracle Home - EPM Oracle Instance

Middleware Home: Oracle WebLogic Server home and EPM Oracle Home can found under it.
Example:E:\Oracle\Middleware

EPM Oracle Home: Product files and its required tools is created within th EPM Oracle Home. The default Middleware_Home is EPMSystem11R1. For example if our middleware home is E:\Oracle\Middleware then EPM Oracle Home is E:\Oracle\Middleware\EPMSystem11R1

EPM Oracle Instance: In EPM Oracle Instance, there can be Oracle HTTP Server, Essbase Server, SOA server, Web Server and etc... The default location would be in this case is E:\Oracle\Middleware\user_projects\domains\EPMSystem . In a distributed environment, we should name all the Middleware Homes as the same.




Note. This directory hierarchy is similiar to Oracle BI architecture. It has also a middleware home and in it, there is weblogic server,instance home and Oracle BI Home.

Oracle Fusion Middleware: Running RDA For Hyperion - Remote Diagnostic Agent(RDA) - Hyperion için RDA Çalıştırmak

We have written about the RDA before for OBIEE and EBS.

1- http://berkeoz1.blogspot.com.tr/2014/01/oracle-e-business-suite-rda-nedir.html
2- http://berkeoz1.blogspot.com.tr/2014/07/oracle-fusion-middleware-running-rda.html

Now we would like to specify the usage of rda for Hyperion. The need to that has arisen to detect problems in the Hyperion system. What we had used before was the diagnostic tool of Hyperion.
(http://berkeoz1.blogspot.com.tr/2014/08/oracle-hyperion-starting-and-stopping.html)
However we will be using rda as a complementary tool to our diagnostic efforts.

Where is RDA?

RDA is found in the Middleware Home. (For example:E:\Oracle\Middleware\oracle_common\rda)

We could do the setup which is giving the appropriate details for running rda by "rda.cmd -S".

To list all the profiles that we can run we could use:

rda.exe -L

With that command all the modules and previously defined profiles to analyze the system can be found.



An example of the command to run RDA with using just the HFM module is below:

rda.cmd -vSCRP HFM

An example of the command to run RDA with using profile for HFM is below:

rda.cmd -vSCRP -p Hyperion1112_HFM

In the end, we would have something like the directory structure below in which we run first the "RDA_index.htm" file

References:

1-How to Use Remote Diagnostic Agent (RDA) to Gather Diagnostic Information On Oracle Hyperion Financial Management (HFM) Servers to Help Resolve Service Requests Faster [Video] (Doc ID 1100612.1)

Oracle Hyperion: Starting and Stopping HFM 11.1.2.3

START:

EPM System Installer provides us a single start script under EPM_ORACLE_INSTANCE/bin which is called start.bat depending on the operating system.
To start the system, we start from foundation server, and run the start.bat under the "E:\Oracle\Middleware\user_projects\epmsystem1\bin". Then we pass on to the application server and run the start.bat which also under this or a similar path "E:\Oracle\Middleware\user_projects\epmsystem2\bin".

To check if we have succeeded on starting the application, we could run EPM System Diagnostics.

STOP:

Stoping procedure is quite similar to starting procedure. To stop we could start from the application server then stop the foundation server.


What is  EPM System Diagnostics?

Epm System Diagnostics is a tool that makes the essantial checks on a system and produces a report in which it shows its analysis. EPM System Diagnostics can be found on both of the servers(Applciation and Foundation). After the analysis, reports are created int the following path which may change according to the installation "E:\Oracle\Middleware\user_projects\epmsystem2\diagnostics\reports\"
Example:"E:\Oracle\Middleware\user_projects\epmsystem1\diagnostics\reports\instance_report_20140813_034231.html"

These reports can be used to for historical evalution. For example to estimate a time period where  we have last succeeded on running some module or when some module just crashed, we could always check these things.

System Diagnostics exe can be found in the  EPM_ORACLE_INSTANCE/bin

EXE's  and URL's 

Oracle Hyperion Shared Services Console: http://machine_name:Port/interop.  This is found on the Foundation Server. Example: http://machine_name:28080/interop

EPM Workspace: Http://machine:port/workspace. Workspace URL's can be also found on foundation services.
Example. http://machine_name:19000workspace

Oracle Hyperion: HFM Applications and Menu Item Are Not Displayed In Workspace - Error

Financial Management related menu items in Workspace can disappear from time to time if there happens to be any change in the configuration. The following ways of


1-File -> Preferences -> Consolidation
2-File -> Open -> Applications -> Consolidation
3-Navigate (the "wheel") -> Applications -> Consolidation
4-Navigate (the "wheel") -> Administer -> Consolidation Administration, plus the items "Users On Systems", "System Messages" and "Manage Servers and Applications".

When this happens, it is usually due to some kind of system configuration or parameter change.

How to solve this problem?

The way to solve this problem is running the Web Server Configuration Task from the Foundation Server.
This error was mostly seen in HFM 11.1.1.3 but it is also the correct way to solve it in HFM 11.1.2.3.

We first go to Foundation Server and run the configurator.

Then we configure all the financial management tasks.

After that we configure only "Configure Web Server" task.

Make sure that the HFM component is selected and shows the correct address and port; complete the task and Finish. Then in order , stop the Foundation Workspace Web Application service, stop and restart the Foundation Workspace Agent service. At last restart the Foundation Workspace Web Application service

References:

1-http://concentricsolutions.helpserve.com/Knowledgebase/Article/View/22/1/hfm-applications-and-menu-item-are-not-displayed-in-workspace

Oracle Hyperion: Logs in HFM 11.1.2.3

When we need Hyperion Logs, usually to send the information to SR or to find and search the error in the internet, we have to know where they are. So we will list the log file locations in case of an emergency.

1-E:\Oracle\Middleware\diag

Diagnostics directory under Middleware is where we can find the information needed when we run diagnostics tool.


2-E:\Oracle\Middleware\EPMSystem11R1\logs

What we have under this directory, is the logs belonging to application. For example, copy application log is found here. BIPlus logs are placed here. Whether we have done the right configuration or not, its logs are written under this path.

3-E:\Oracle\Middleware\logs

This path is more like the installation log file.

4-E:\Oracle\Middleware\user_projects\epmsystem2\diagnostics

Diagnostics paths under the domain home is the real location where the runtime logs are placed. We need to be aware of this directory's presence.


Note:Paths may change according to the directory installation.


How to view the system logs? 

There is actually two tools for this purpose given by Hyperion. In HFM 11.1.2.3, the application server of Hyperion, under
"E:\Oracle\Middleware\EPMSystem11R1\products\FinancialManagement\Consultant Utilities\" , our two are placed. One is the HFM Error Log Viewer to search for errors, second is to lookup for error which is seen on the HFM Error Log Viewer. Moreover, our research for solution becomes easier.

Oracle Hyperion: Copying HFM Application - Running HfmCopyApplication.exe - HfmCopyApplication Çalıştırmak

In Hyperion 11.1.2.3 CopyApplication.exe is found in the C:\Oracle\Middleware\EPMSystem11R1\products\FinancialManagement\Server . Under the "Server" directory you could find HfmCopyApplication.exe which is used to copy the applications from one HFM server to another or within the environment.

What do we need to run it?

We need 2 UDL's or just one according to the need. If we are using it to transport the application from one environment to another then we need 2.

These UDL's are used in order to show the database information. Because our database is on SQL server, we need to use SQL UDL's, one for source, one for destination.


Why is it used?

It is used mainly for synchronization between Production and Development environments. Therefore it is highly cruical for companies.

Other than migration, it can be used to:

1-Backup
2-Copy
3-Recover

Where is it found?

\EPMSystem11R1\products\FinancialManagement\Server 

Depending on how you install it, it can be found under D:\Hyperion\products\FinancialManagement\Server in HFM 11.1.1.3

Where are its logs?

D:\Hyperion\logs\hfm in HFM 11.1.1.3
E:\Oracle\Middleware\EPMSystem11R1\logs\hfm in HFM 11.1.2.3

The paths may change depending on the installation directories.

Note: If you used HfmCopyApplication to create a new HFM application (not to overwrite the content of an existing one) you need to register the application to Shared Services before being able to use it. This can be accomplished by using the Register Application function found in EPM Workspace.

References:

1-Copying HFM Applications: http://hyperionfinn.blogspot.com.tr/2012/02/copying-hfm-applications-on-command.html

2-EPM Utilities: http://hyperionnz.blogspot.com.tr/2012/06/epm-utilities-that-you-should-know.html

3-http://oraclehyperionstuff.blogspot.com.tr/2012/02/how-to-backup-hfm-application-for.html