Table of Contents:
This document presents the recommended steps to build a typical Oracle Essbase development environment on a single server running Microsoft Windows. A typical Essbase development environment comprises the following products:
Oracle Essbase Studio
Oracle Hyperion Smart View for Office
Oracle Essbase Administration Services
Required products including Oracle Database, Oracle WebLogic Server, and Oracle HTTP Server
Table 1. Server Requirements
|Server Operating System||Windows 2008 R2 x64|
|Memory||16 GB RAM|
|Disk||200 GB Disk|
Use a local Windows user account, for example, epmrapid_user, that satisfies these requirements. This account is referred to as the deployment account in this document:
The deployment account is a member of the Administrators group on the server.
The following local security policies are assigned to the deployment account either directly or by granting them to the Administrators group:
Act as part of the operating system
Bypass traverse checking
Log on as a batch job
Log on as a service
User account control is disabled for the deployment account.
The password that you select for this account will be used as the password for Oracle Database Administrator, Oracle Database User, WebLogic Administrator, and EPM Administrator. This password is referred to as the deployment password throughout this document.
The deployment password must conform to the following guidelines:
Contain at least one uppercase letter
Contain at least one numeral
Be at least eight characters long
Contain no special characters
An example of an acceptable deployment password is 1Rapidepm.
To verify that local security policies are assigned to the deployment account:
To turn off user account control:
The deployment process involves the following steps and takes approximately three hours:
Step 1: Downloading Installation Files (approximately 20 minutes)
Step 2: Installing and Configuring Oracle Database Express Edition (approximately 10 minutes)
Step 3: Installing and Configuring EPM System(approximately 50 minutes)
To download media packs from Oracle E-Delivery website:
Using a browser, go to http://www.oracle.com/technetwork/database/express-edition/downloads/index.html.
Using a browser, connect to http://edelivery.oracle.com.
EPM System 220.127.116.11.0 for Microsoft Windows x64 (64-bit) (Part 1)
EPM System 18.104.22.168.0 for Microsoft Windows x64 (64-bit) (Part 2)
EPM System 22.214.171.124.0 for Microsoft Windows x64 (64-bit) (Part 3)
EPM System 126.96.36.199.0 for Microsoft Windows x64 (64-bit) (Part 4)
EPM System 188.8.131.52.0 for Microsoft Windows x64 (64-bit) (Part 6)
EPM System Release 184.108.40.206.0 Client Installers for Microsoft Windows
You will be warned about overwriting some existing files. Select Yes.
To install and configure Oracle Database:
create user EPMRAPID_USER identified by "DEPLOYMENT_PWD";
grant RESOURCE,CONNECT,CREATE SESSION,CREATE VIEW to EPMRAPID_USER;
This process takes approximately 50 minutes.
To install EPM System files:
The following Foundation Components under Foundation Services:
Foundation Services Web Applications
Static Content Files
WebLogic Application Server
The following Essbase components:
Essbase Administration Services Web Application
Essbase Studio Server
Service Name or SID––Enter XE.
User Name––Enter epmrapid_user.
Password––Enter the deployment password.
Administrator Password––Enter the deployment password.
Confirm Administrator Password––Reenter the deployment password.
The deployment process takes approximately 20 minutes.
Using Windows Explorer, navigate to epm_rapid_unzipped/EssbaseStudio.
Oracle Enterprise Performance Management System runs diagnostic scripts. Diagnostic Test results are displayed in your browser.
User Name—Enter admin.
Password—Enter the deployment password.
Oracle Essbase Administration Services Console opens.