Tuesday, June 25, 2013

EPM System V11.1.2.2 - Sample 2 servers architecture

As I have mentioned before, I am in process of upgrading Hyperion EPM System from V11.1.1.3 to V11.1.2.2. So, the basic requirement was to finalize the architecture.
It helps a lot to understand Hyperion EPM System.

The architecture is based on 5 different layers:
  1. Database layer (RDBMS)
  2. Foundation layer (Shared Services)
  3. Application layer (Hyperion applications - HFM, FDM)
  4. Web layer 
  5. Client layer (HFM client, FDM client, FR studio, SMartview)

Tuesday, June 18, 2013

Customizing Logon page and Launch application page - EPM V11.1.2.2


Logon Page Customizing

Logon Page is the one which comes when we type the product URL with index.
Or, if we type the URL without index, the next window opens with Logon Page.

Logon_Panel.gif is the image shown on logon page of all EPM system products.


To change the logon page of any product, we need to change logon_panel.gif at following two locations

1.       Static directories of the application

Static directories of applications are present in Hyperion_Home directory at following location.
D:\Oracle\Middleware\EPMSystem11R1\common\epmstatic

2.       Respective ear/war files of the application

We need to change logon image in EAR/WAR files as EAR/WAR files get deployed when services are started/restarted if any changes are made to them.
So, if we only change in the static directory, changes will be lost if by any reason EAR/WAR for the application gets deployed again while restarting services.

Workspace Logon page customizing

1.       Static directory changes

Change Logon_Panel.gif at following location:
  • D:\Oracle\Middleware\EPMSystem11R1\common\epmstatic\bpmui\themes\theme_tadpole\images_global
  • D:\Oracle\Middleware\EPMSystem11R1\common\epmstatic\bpmui\themes\theme_tadpole_hc\images_global
2.       EAR/WAR file changes
Change Logon_Panel.gif at following location:
  • D:\Oracle\Middleware\EPMSystem11R1\common\bpmui-common\11.1.2.0\bpmui.war\bpmstatic\themes\theme_fusionfx\images_global\
  • D:\Oracle\Middleware\EPMSystem11R1\common\bpmui-common\11.1.2.0\bpmui.war\bpmstatic\themes\theme_tadpole\images_global\
  • D:\Oracle\Middleware\EPMSystem11R1\common\bpmui-common\11.1.2.0\bpmui.war\bpmstatic\themes\theme_tadpole_hc\images_global\

Launch application page Customizing

When we type product URL without index.jsp, the page opens with Launch application button.
The image on this launch application page is splash image and we can modify this splash image to customize launch application page.
   
 
To change the splash image, we need to modify splash image file for particular product at following two locations.
1.       Static directories of the application
Static directories of applications are present in Hyperion_Home directory at following location.
(Hyperion_Home = D:\Oracle\Middleware\EPMSystem11R1)
Hyperion_Home \common\epmstatic
                                Splash image is then present at:
Hyperion_Home \common\epmstatic\application\images

2.       Respective ear/war files of the application
We need to change logon image in EAR/WAR files as EAR/WAR files get deployed when services are started/restarted if any changes are made to them.
So, if we only change in the static directory, changes will be lost if by any reason EAR/WAR for the application gets deployed again while restarting services.

                                Hyperion_Home \products\Foundation\workspace\InstallableApps\productear\ product.war\static\images\

Workspace Launch application page customizing

1.       Static directory changes

Change SplashScreenSystem9BIPlus.gif at following location:
  • D:\Oracle\Middleware\EPMSystem11R1\common\epmstatic\wspace\images
2.       EAR/WAR file changes
Change SplashScreenSystem9BIPlus.gif at following location:
  • D:\Oracle\Middleware\EPMSystem11R1\products\Foundation\workspace\InstallableApps\Workspace.ear\ workspace.war\static\images\


Monday, June 17, 2013

Installation and Configuration of Hyperion EPM System V11.1.2.2

The current HFM application resides on V11.1.1.3 in production environment. And we are in process of upgrading to V11.1.2.2.
Though production environment is distributed, we have got one development environment consisting only one server. So, I am going to try installing and configuring Hyperion EPM system V11.1.2.2 on this single server environment.

As the server was already used before for Hyperion EPM system, I did not care much about pre-requisites. Otherwise, before starting installation and configuration of Hyperion EPM system, we should really follow the pre-requisite checklist. I will cover this pre-requisite checklist soon in this blog.

Once required installers from the bundle of EPM system V11.1.2.2 installers from Oracle Edelivery site are extracted in one folder, run installTool.cmd as an administrator




Before proceeding further, let us take a brief overview about the environment used. I am here interested in single server HFM-FDM application environment. To give the exact idea, refer to following architecture.



So, we are interested in installing HFM and FDM on our server. Please refer following post of this blog to get the exact idea of required installers.
As per our requirement, I selected only Foundation Services, HFM and FDM components from the installation list.






Once the installation is successful, we can either start for configuration or we can finish up the installation process and select to configure later.

Selected configure to complete the configuration process.


Before starting installation of Hyperion EPM System V11.1.2.2, we need to create DB schemas for required components. The topic will be covered in details in a separate post about pre-requisite checklist.
Right now, I am giving a list of DB schemas I created on Oracle 11g DB residing on Unix server.
Shared Services
Hyp11_hss
HFM
Hyp11_hfm
FDM
Hyp11_fdm3

Hyp11_fdm4

Hyp11_fdm5

Referring to above table, give DB schema details.


I decided to go step by step for configuration. First configured only common settings of Shared Services and configured Shared Services DB.
After that, I selected to deploy foundation services to application server.
 The default application web server is Weblogic which gets installed along with EPM system. I am using this default application web server.

We have got two options either to deploy to single managed server which is referred as compact deployment or we can choose to deploy to separate managed servers.
These managed servers are created on weblogic admin server.

Compact Deployment

 Separate Managed Servers:


I selected deployment on separate managed servers; deployment takes several minutes and almost checks our patience. The only good thing is to see changing messages like deploying shared services, creating server for shared services while configuration.

We are now remaining to configure Foundation services web server. This will be the last option we will be doing after completing whole configuration.
Now, we will be configuring HFM components.

Select to start IIS features.
Refering to our DB schema table, please give proper schema details created for HFM.

As weblogic domain is already created while configuring Foundation Services, select option to deploy to existing weblogic doman.

As I am going to deploy on separate managed servers, another managed server HFMWeb0 will be created on weblogic admin server.

 Configure DCOM. Enter user in format "DomainName/Username"

 Configure application Server and cluster.
 
Configure  HFM Web server

Provide application web directory and directory name.

 Configure Provider services which enables SmartView

Configure HFMLCM service which enables Life Cycle management

Enable Web Services.

 


During this first attempt, DCOM configuration was failed.
While investigation, found that, the user “hyperionepm” which I was using for installation and configuration of Hyperion EPM system V11.1.2.2 is connected to secondary domain controller but the during configuration, only primary domain controller was hit for DCOM configuration.

We are connected to following domain controller.


For this issue, a new dll file was provided by Oracle as a temporary solution so that if the user does not exist on primary domain controller, it checks if the user exists on secondary domain controller.
A patch will be provided later for production environment.

After HFM, FDM is configured.


Thursday, June 13, 2013

Hyperion EPM System V11.1.2.2 Installers


I am in the process of upgrading all our present environments from Hyperion EPM system V11.1.1.3 to V11.1.2.2

To start with, I decided to go through various installers of V11.1.2.2 present on oracle edelivery site.
Following installers of EPM system V11.1.2.2 are present on www.edelivery.oracle.com


The following 4 zip files contain Foundation services

 EPM System Release 11.1.2.2.0 for < Platform > Part 1 V31875-01
 EPM System Release 11.1.2.2.0 for < Platform > Part 2 V31876-01
 EPM System Release 11.1.2.2.0 for < Platform > Part 3 V31922-01
 EPM System Release 11.1.2.2.0 for < Platform > Part 4 V31877-01

 EPM System Release 11.1.2.2.0 for < Platform > Part 1 V31875-01

This is similar to the EPM System Installer and it contains
  • Installer
  • Common products
  • Product common components
  • Essbase common components
  • Opmn

 EPM System Release 11.1.2.2.0 for < Platform > Part 2 V31876-01

This installer is all about Weblogic. It contains:
  • Weblogic Common components

 EPM System Release 11.1.2.2.0 for < Platform > Part 3 V31922-01

This zip file contains:
  • Static Contents
  • Shared Services
  • OCM
  • Oracle Common Home
  • Tools – HSS Migration Utility
  • Workspace

EPM System Release 11.1.2.2.0 for < Platform > Part 4 V31877-01

This file contains
Analysis and Reporting Framework
EPMA
Calc manager

EPM System Release 11.1.2.2.0 for < Platform > Part 5 V32795-01 

All the applications are bundled in this file.  In this upgrade case, I am interested only in HFM and FDM as those are used in our application, but I will still need to download Planning, strategic finance and all listed components. It then shows all these components while installation. Don’t get confused with unwanted components and ignore them while installation.J
  • AIF
  • ACF
  • HFM
  • Finance close management
  • HPM
  • HPS
  • FDM
  • HSF
  • Planning

EPM System Release 11.1.2.2.0 for < Platform > Part 6 V31879-01 

Part 6 zip file is all about Essbase. It contains
  • APS
  • EAS
  • EIS
  • Essbase
  • Studio
As I am interested in HFM and FDM, I won’t need to download this part. If you are interested in establishing only Essbase environment, then you need to download first 4 parts and part6. Part 5 won’t be required.
For environments with Essbase and planning application, you will need all 6 parts.

EPM System Release 11.1.2.2.0 for < Platform > Part 7 V31880-01

This zip file contains Interactive Reporting and Production Reporting assemblies
  • IR client
  • IR
  • Production Reporting client
  • Production Reporting

EPM System Release 11.1.2.2.0 Client Installers for Microsoft Windows V32789-01:

This zip file contains following clients. As a result, I will end up in downloading the entire file even if I am interested in single client.

  • Disclosure Management
  • EAS Console
  • Essbase Client
  • Essbase Studio
  • Excel Addin
  • HFM Client
  • FR studio
  • Offline Planning
  • Predictive Planning
  • Smart View
  • Strategic Finance Client


EPM System Release 11.1.2.2.0 for < Platform > Oracle HTTP Server V31881-01

This file contains separate Oracle HTTP server. We can skip this component if we are planning to use weblogic server as web server. Weblogic server comes along with our Foundation services. I am planning to skip this component.
  • OHS

EPM System Release 11.1.2.2.0 Data Relationship Management V31868-01

It is all about Data Relationship Management (MDM)
  •  DRM