Installation Hyperion Performance Management Applications 11.1.2.1

Installation Hyperion Performance Management Applications 11.1.2.1

1. Introduction:

In this setup tutorial we are going to install Hyperion EPM in 2 virtual machines, I'm using Hyper-V for creating the virtual environment,I'm going to separate the database to the EPM applications to get more performance.

2. Architecture:

In our lab, I'm going to use Redhat Server 5.5 x64bit for Oracle database and Essbase Server, the EPM applications will be setup on Windows Server 2008 R2.

3. Oracle Database:

We need to install Oracle 11g database on Redhat Server 5.5
This link helps you to setup the Redhat OS and Oracle 11g:
http://itgration.blogspot.com/2014/11/oracle-11g-database-on-linux-redhat.html

It's better to install only Oracle 11g and after create the batabase.

3.1. Prerequisite Redhat Server 5.5:

Create a user install for EPM Hyperion, in our case I'll create hyperadmin.

• Fix the name of the servers (Redhat and Windows) in hosts file

• Disabling SELinux:

Edit /etc/selinux/config and change the setting by enforcing disabled
Reboot the server.

• Disable Firewall.

• Enabling the X11 server

Necessary to make the GUI installation
It is necessary to have on the client X11 emulator (eg software Xming) or you can install from the graphic (gnome Desktop).

• Right on Oracle Inventory

It is necessary to have the rights rwx (read-write-execute) on the directory or is the Oracle Inventory. (located the oraInventory directory). Add hyperadmin to dba group.

• Increase nofile Descriptors

The minimum value must be 4096 by default for the user who will launch the installer EPM
Make a ulimit -a to check the settings.

For oracle install user the value must be 2048.
For EPM Hyperion install user the value must be 4096.
Reboot the system

• Necessary packages for EPM Hyperion

You need to install these packages, otherwise you'll get failed at common component:
glibc i368 (32bits)
glibc 86_64 (64bits)

3.2. Prerequisite Database Oracle 11g:

 In our case, we will use an Oracle 11.2.0.1 database.

The database hosting the oracle schema must be created with one of the following character sets:

• NLS_CHARACTERSET :   UTF8 or AL32UTF8

• NLS_LENGTH_SEMANTICS = CHAR (because of UTF8  or AL32UTF8 )

• NLS_LANG : AMERICAN

• NLS_TERRITORY : AMERICA

• CURSOR_SHARING in Oracle to be set to the default setting : “EXACT”

• NLS_NUMERIC_CHARACTERSET = ". , "

Create a user for each of the following modules (for example):

Shared Services: HSS
Essbase Administration Service: EAS
Essbase Studio: ESBSTUDIO
Reporting and Analysis: BIPLUS
Planning: HPSYS
Calculation Manager: CALC
Performance Manager Architect: EPMA


The users must have their role as pattern:

CREATE SESSION
CREATE VIEW
DBA
RESOURCE (should be by default)

4. EPM Hyperion Windows Server 2008 R2:

4.1. Prerequisite Windows Server 2008 R2:

• Disable the firewall.

• Fix the name of servers in hosts file.

• Install Role IIS.

• Install user must have Administrator right.

• Disable User Account Control Settings.

4.2. Installation of Oracle 11g Client:

The Oracle Client needed on Windows Server to communicate with the database, You should install the 64bits Client. Download it from here.

Select Administrator

Choose the Directory you want to install in.

After the install go to the directory  [DISK letter]:\app\Administrator\product\11.2.0\client_1\network\admin
Create a file named tnsnames.ora
Enter the following information to connect to the database (juste modify the database name and the server name).

HYPER =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = EPMLINUX) (PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = HYPER)
    )
  )

Test the connection to the database, open a cmd command and tape tnsping "name of database"

4.3. Installation of EPM Hyperion:

Go to the directory of EPM and execute installTool.bat

Choose where you want to install

Select the product you want to install

Installation completed without any error, we are good to go for configuration.

4.3. Configuration of EPM Hyperion:

4.3.1. Shared Services configuration:

First step is to configure the Shares service with HSS account

Select Performe first-time coniguration of Shared Services database, enter the server name, the database, the user (HSS) and the password.

Select Deploy to Application Server.

Give a password for the weblogic domain

Enter a password for the Shared Services admin

4.3.2. Reporting and Analysis configuration:

In Task Panel, select Reporting and Analysis

Select Perform first-time configuration of database.
Enter the database server, database name, RA user and password

4.3.3. Planning configuration:

In Task Panel, select Planning

Select Perform first-time configuration of database.
Enter the database server, database name, Planning user and password 

4.3.4.  Configuration Calculation Manager:

In Task Panel, select Calculation Manager

Select Perform first-time configuration of database.
Enter the database server, database name, CM user and password 

4.3.5.  Configuration Performance Management Architect:

In Task Panel, select Performance Management Architect

Select Perform first-time configuration of database.
Enter the database server, database name, EPMA user and password 

4.3.6. Configuration Essbase Provider Services:

In Task Panel, select Essbase Provider Services

4.3.7. Configuration Essbase Studio:

In Task Panel, select Essbase Studio

Select Perform first-time configuration of database.
Enter the database server, database name, Essbase Studio user and password 

4.3.8. Configuration Essbase Administration Services:

In Task Panel, select Essbase Administration Services

Select Perform first-time configuration of database.
Enter the database server, database name, EAS user and password 

4.3.9. Configuration Web Server:

In Task Panel, select Configure Web Server.

Now all applications are configured. Go to Windows Services and change the start type to Manual.
Start all Hyperion Services.

5. EPM Hyperion Redhat Server 5.5:

5.1. Installation Essbase Server:

It's necessary to copy the install folder in the server and the install user must has right to execute from it. In terminal, point on the directory and execute ./installTool.sh

Choose the directory where you install Essbase Server

Select Essbase server, client and Foundation Services Web Applications.

5.2. Configuration Essbase Server:

Click on configure

Select Connect to a previously configure Shared Services database.
Enter the login HSS (Shared Service) and password.

Enter a password for weblogic domain.

Click finish to complete the configuration.

5.3. Start Essbase Server:

To start the Essbase server go to bin directory /Oracle/Middelware/user_project/epmsystem/bin
Execute ./opmnctl startall

To stop Essbase Server: ./opmnctl stopall
To view the status of Essbase Server: ./opmnctl status

6. EPM Hyperion workspace:

In Internet explorer, enter the link of workspace: http://Server_Name:19000/workspace