This effort came out of an interest in seeing how long it would take to stand up a minimal environment for Hyperion EPM 11.1.1.3. Although, this is no longer the premier-supported version of Hyperion EPM, I thought it was a good place to start looking into deployment concerns and challenges, since it is the start of the 11g line. I started my experiment with two Virtualbox Windows XP instances: a 4 GB one for the database repository, shared services and Hyperion Financial Reports, and a 1 GB instance for Essbase. Full disclosure: the instances had been created previously, and Oracle Express Edition 11g was already installed on my database/SS server.

So, in total the effort took about 15 hours, including a couple false starts, restarts and rabbit holes. I came away with some tips for future:

  • Make sure you are using a browser which is compatible with your version of Hyperion EPM. I spent an hour trying to figure out why Shared Services was not working, only to discover that 11.1.1.3 does not work with the latest Firefox or Chrome.
  • Do not use server names that include hyphens – they break a lot of processes in the installation. I had to back out and restart because of this, after renaming my servers.
  •  Sequencing matters. Here is what I followed:
    1. Install and configure Foundation/Shared Services first,
    2. Install the various products (HFR, Essbase).
    3. Do a separate install for Essbase Administration Services, after Essbase is installed (including the server, client and EAS client).
    4.  If you wish to install the EAS web client, make sure you have an app server installed first (Weblogic, Tomcat, etc).

This was a fun effort, I’m looking forward to deploying a few other apps in the instance, as well as bumping it up a version to the currently supported EPM 11.1.2.3 in future exercises.

Like!
0
Duane Cato March 12, 20147:28 am

Confirmed XE 11G was up and working on the database server:
C:\Documents and Settings\Administrator>tnsping hyp_epm_svc

TNS Ping Utility for 32-bit Windows: Version 11.2.0.2.0 – Production on 12-MAR-2
014 08:07:28

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:
C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\sqlnet.ora

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=169.254.25.129)(PORT=1521))(ADDRESS=PROTOCOL=TCP)(HOST=192.168.2.6)(PORT=1521)))
OK (20 msec)

Duane Cato March 12, 20147:35 am

Removed garbage schema objects from the planned Hyperion schemas:
EPMSS – Shared Services repository db schema
EPMEAS – Essbase Admin Services repository db schema
EPMBI – BI core repository db schema

Duane Cato March 12, 20147:39 am

Installed legacy BEA Weblogic 9.23 on the SS server by running server923_win32.exe

Duane Cato March 12, 20147:57 am

Downloaded and installed Java 7 from http://java.com.
Downloaded and installed Oracle SQL Developer from
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html (not strictly necessary, but I like it).

Duane Cato March 12, 20148:10 am

Downloaded and installed Java 7 from http://java.com.
Downloaded and installed Java SDK 7 from http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html.
Downloaded and installed Oracle SQL Developer from
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html (not strictly necessary, but I like it).

Duane Cato March 12, 20148:38 am

Installed Shared Services only (EPMDB, EPMSS, first-time) by running the Fusion Installer InstallTool.cmd command:

Duane Cato March 12, 20149:40 am

Completed first-time configure of Shared Services on EPMDB database, using EPMSS schema.

Duane Cato March 12, 20149:46 am

Completed first-time configure of Shared Services on EPMDB database, using EPMSS schema.

Duane Cato March 12, 20149:52 am

Configured workspace:

Duane Cato March 12, 201410:15 am

Configured workspace:

Duane Cato March 12, 201411:05 am

Turned out that Provider services were left out, so had to reinstall and configure that:

Duane Cato March 12, 20149:38 pm

Next:
Started configuration of the Essbase server:
Downloaded and installed Java 7.

Installed Oracle Express Edition 11g on the server, and turned off the database, since the plan is to use the instance on the Shared Service server as the product repository.
Finally, ran the InstallTool.cmd to install the Essbase Server (32-bit)

Duane Cato March 12, 201411:59 pm

Installed HFR Reports/SS server with options EPMDB, EPMSS, connect to existing shared services.

Duane Cato March 13, 20149:51 pm

Last action was to install Essbase Administrative Services on the Essbase server, so the EAS client could manage cubes, applications, etc. This was done by running the InstallTool.cmd command and selecting only
the Essbase Administrative Services (32-bit for this OS). You don’t have to add Foundation unless you want to mirror your shared services on the Essbase server, which is a different effort entirely. I removed it afterwards.

Duane Cato March 13, 20149:55 pm

Last action was to install Essbase Administrative Services on the Essbase server, so the EAS client could manage cubes, applications, etc. This was done by running the InstallTool.cmd command and selecting only
the Essbase Administrative Services (32-bit for this OS). You don’t have to add Foundation unless you want to mirror your shared services on the Essbase server, which is a different effort entirely. I removed it afterwards.