Infrastructure Preparations for Oracle/Hyperion EPM 11.1.2.2

makeshiftklipInternet and Web Development

Oct 31, 2013 (3 years and 7 months ago)

121 views

Information with Integrity| www.indigo.co.nz

Charles Naslund

Indigo New Zealand

18
th

of March 2013

Infrastructure Preparations for


Oracle/Hyperion

EPM 11.1.2.2


Information with Integrity| www.indigo.co.nz

Agenda


Current EPM 11.1.2.2 Architecture


Preparations “Why Should I Care?



Server Sizing


Tuning for stability and performance


Q&A


Information with Integrity| www.indigo.co.nz

Agenda

Current EPM Architecture

Information with Integrity| www.indigo.co.nz

Oracle/Hyperion EPM
Architecture

Technical Architecture

HTTP Server (IIS, Apache, OHS)

Information with Integrity| www.indigo.co.nz

Oracle/Hyperion EPM
Architecture

Technical Architecture

Shared Services (Foundation)

HTTP Server (IIS, Apache, OHS)

Information with Integrity| www.indigo.co.nz

Oracle/Hyperion EPM
Architecture

Technical Architecture

Shared Services (Foundation)

HTTP Server (IIS, Apache, OHS)

Information with Integrity| www.indigo.co.nz

Oracle/Hyperion EPM
Architecture

Technical Architecture

Financial

Reporting

Web

Web

Analysis

OBIEE

Planning

EPMA

(Web App,
Data Sync)

Calc

Mgr.

Shared Services (Foundation)

HTTP Server (IIS, Apache, OHS)

Information with Integrity| www.indigo.co.nz

Oracle/Hyperion EPM
Architecture

Technical Architecture

Financial

Reporting

Web

Web

Analysis

OBIEE

Planning

EPMA

(Web App,
Data Sync)

Calc

Mgr.

Shared Services (Foundation)

Essbase

Provider

Svcs

Essbase

Admin

Services

Essbase

Studio

Server

HTTP Server (IIS, Apache, OHS)

Information with Integrity| www.indigo.co.nz

Oracle/Hyperion EPM
Architecture

Technical Architecture

HTTP Server (IIS, Apache, OHS)

Financial

Reporting

Web

Web

Analysis

Interactive

Reporting

Financial

Reporting

Svcs

OBIEE

Workspace Agent Service

Planning

EPMA

(Web App,
Data Sync)

EPMA

Dim
Svr

Calc

Mgr.

Shared Services (Foundation)

Essbase

Provider

Svcs

Essbase

Admin

Services

Essbase

Studio

Server

HFM/FDM

COM

Server

Information with Integrity| www.indigo.co.nz

Oracle/Hyperion EPM
Architecture

Technical Architecture

HTTP Server (IIS, Apache, OHS)

Financial

Reporting

Web

Web

Analysis

Interactive

Reporting

Financial

Reporting

Svcs

OBIEE

Workspace Agent Service

Planning

EPMA

(Web App,
Data Sync)

EPMA

Svc
Mgr

Calc

Mgr.

Shared Services (Foundation)

Essbase

Provider

Svcs

Essbase

Admin

Services

Essbase

Studio

Server

HFM/FDM

COM

Server

HFM/FDM

Web

HFM/FDM

Web

EPMA

Dim
Svr

Information with Integrity| www.indigo.co.nz

Oracle/Hyperion EPM
Architecture

Technical Architecture

HTTP Server (IIS, Apache, OHS)

Financial

Reporting

Web

Web

Analysis

Interactive

Reporting

Financial

Reporting

Svcs

OBIEE

Workspace Agent Service

Planning

EPMA

(Web App,
Data Sync)

EPMA

Svc
Mgr

Calc

Mgr.

Shared Services (Foundation)

Essbase

Provider

Svcs

Essbase

Admin

Services

Essbase

Studio

Server

HFM/FDM

COM

Server

HFM/FDM

Web

EPMA

Dim
Svr

Essbase

Server

Information with Integrity| www.indigo.co.nz

Oracle/Hyperion EPM
Architecture

Technical Architecture

HTTP Server (IIS, Apache, OHS)

Financial

Reporting

Web

Web

Analysis

Interactive

Reporting

Financial

Reporting

Svcs

OBIEE

Workspace Agent Service

Planning

EPMA

(Web App,
Data Sync)

EPMA

Svc
Mgr

Calc

Mgr.

Shared Services (Foundation)

Essbase

Provider

Svcs

Essbase

Admin

Services

Essbase

Studio

Server

HFM/FDM

COM

Server

HFM/FDM

Web

EPMA

Dim
Svr

Essbase

Server

ODI

Agent

Information with Integrity| www.indigo.co.nz

Oracle/Hyperion EPM
Architecture

Technical Architecture

HTTP Server (IIS, Apache, OHS)

Financial

Reporting

Web

Web

Analysis

Interactive

Reporting

Financial

Reporting

Svcs

OBIEE

Workspace Agent Service

Planning

EPMA

(Web App,
Data Sync)

EPMA

Svc
Mgr

Calc

Mgr.

Shared Services (Foundation)

Essbase

Provider

Svcs

Essbase

Admin

Services

Essbase

Studio

Server

HFM/FDM

COM

Server

HFM/FDM

Web

EPMA

Dim
Svr

Essbase

Server

ODI

Agent

Information with Integrity| www.indigo.co.nz

Oracle/Hyperion EPM
Architecture

Technical Architecture

HTTP Server (IIS, Apache, OHS)

Financial

Reporting

Web

Web

Analysis

Interactive

Reporting

Financial

Reporting

Svcs

OBIEE

Workspace Agent Service

Planning

EPMA

(Web App,
Data Sync)

EPMA

Svc
Mgr

Calc

Mgr.

Shared Services (Foundation)

Essbase

Provider

Svcs

Essbase

Admin

Services

Essbase

Studio

Server

HFM/FDM

COM

Server

HFM/FDM

Web

EPMA

Dim
Svr

Essbase

Server

ODI

Agent

API, RMI, HTTP(S)

HTTP(S)

DCOM

TCP/IP

JDBC, OLE DB

Client

Layer

Application

Layer

Database

Layer

Information with Integrity| www.indigo.co.nz

Agenda

Preparations “Why Should I Care?”

Information with Integrity| www.indigo.co.nz

Preparations “Why Should I Care?”

"When you're prepared, you're more confident. When you have a
strategy, you're more comfortable
.“

(Fred Couples)




Information with Integrity| www.indigo.co.nz

Preparations “Why Should I Care?”

Things to consider before Installation

Infrastructure Needs



Servers



Network



Databases



Workstations



Information with Integrity| www.indigo.co.nz

Preparations “Why Should I Care?”

Infrastructure Needs

Servers


Virtual or Tin?


Sizing Criteria


Number of simultaneous users



Application Demand


Type of Application


HFM


Planning

Information with Integrity| www.indigo.co.nz

Preparations “Why Should I Care?”

Infrastructure Needs

Servers



Application Demand


HFM


Primary Load on Relational DB


Secondary Load on Application Server


Light Load on Web


Planning


Primary Load on Essbase Server


Secondary Load on Web/Application


Light Load on Web

Information with Integrity| www.indigo.co.nz

Preparations “Why Should I Care?”

Infrastructure Needs

Servers



Application Demand


Reporting Use


Financial Reporting Load


HFM Data Source


Planning Data Source


Web/Application Server


Workspace


Financial Reporting Web

Information with Integrity| www.indigo.co.nz

Preparations “Why Should I Care?”

Infrastructure Needs

Servers



Application Demand


Reporting Use


Reporting and Analysis Load


Reporting and Analysis
Services


Data Source(s)


OBIEE Load


Web/Application Server


Data Source


Web Analysis


Web/Application Server


Data Source

Information with Integrity| www.indigo.co.nz

Preparations “Why Should I Care?”

Infrastructure Needs

Servers


Sizing Criteria


SLA Requirements


Redundancy


Load Balancing

Information with Integrity| www.indigo.co.nz

Preparations “Why Should I Care?”

Infrastructure Needs

Network


Impact Criteria on Network


Bandwidth


HFM:


Avg 64
-

128KB


Planning:


Avg 32


64KB


SmartView:


Avg 28KB


Reporting:


Report Size


Report Books


PDF


Information with Integrity| www.indigo.co.nz

Preparations “Why Should I Care?”

Infrastructure Needs

Network


Impact Criteria on Network


Application Type


Web


Static Data Sizes


Java Script


Performance is sensative to latentcy.


DCOM


Variable network port usage



Latency affects performance and user experience


Recommend a maximum of 125ms for best user experience


Information with Integrity| www.indigo.co.nz

Preparations “Why Should I Care?”

Things to consider before
Installation

Software Needs



Operating Systems (64 bit recommended)


Linux:


Redhat 4.x, 5.x


Oracle 4.x, 5.x


UNIX:


Solaris (2.9,10,11)


AIX (5.3, 6.1, 7.1)


HP
-
UX (11i) Itanium Only


Windows:


Server 2008 R2 (SP2+)


Server 2003 (SP3+)


Clients: XP (SP3+), 7,


Mac OS


OSX 10.6+ (Web Only)

Information with Integrity| www.indigo.co.nz

Preparations “Why Should I Care?”

Things to consider before
Installation

Software Needs



Client Browsers


IE 7.x, 8.x, 9.x


FireFox 10x



Productivity Tool Support


MS Office Suites 2003, 2007, 2008(Mac), 2010



Other Software


Adobe Reader


DCOM (Client and Server)


Flash


JRE 1.60_22+


.NET 3.5+


Information with Integrity| www.indigo.co.nz

Preparations “Why Should I Care?”

Things to consider before
Installation

Software Needs



Other Software


Application Servers


Weblogic 11gR1
(Licence Included
)


10.3.5 and 10.3.6


Web Servers


Oracle HTTP Server 11gR1


Microsoft IIS 6.0+ and 7.x


Websphere (Licenses Additional)


Newly supported with 11.1.2.2


7.0.0.19+ ND


Web Server


IBM HTTP Server 7.0+



Information with Integrity| www.indigo.co.nz

Preparations “Why Should I Care?”

Things to consider before
Installation

Software Needs



A Database repository is required to support EPM
metadata and security.



Supported Databases for Repositories


Oracle DB (10.2.0.4+, 11.1.07+, 11.2.0.1+)


Microsoft SQL Server (2005, 2008, 2008 R2)


IBM DB2 (9.7 FP3a, 9.5)



Most other database vendors are supported as
datasources.




Information with Integrity| www.indigo.co.nz

Preparations “Why Should I Care?”

Things to consider before
Installation

User Training



Administrator(s)


Oracle
University
:
http://tinyurl.com/
b2cajju


Training Venues


Virtual


Classroom


Self Taught


Onsite Indigo Training


Users


Oracle University: Depends on Product


EPM
Classes URL
: http://tinyurl.com/cyn59vf


Onsite Indigo Training



Information with Integrity| www.indigo.co.nz

Agenda

Server Sizing

Information with Integrity| www.indigo.co.nz

Server
Sizing 5


10 users

Information with Integrity| www.indigo.co.nz

Server Sizing
250 users

Information with Integrity| www.indigo.co.nz

Server Sizing
500 users

Information with Integrity| www.indigo.co.nz

Agenda

Tuning for stability and performance


Information with Integrity| www.indigo.co.nz

Tuning for stability and performance

Tuning Platforms



Server Operating Systems



Web Servers



Application Servers



Oracle Databases



Client Operating Systems



Client Web Browsers

Information with Integrity| www.indigo.co.nz

Tuning for stability and performance

Tuning Platforms

Server Operating Systems


Windows Parameters



Linux Parameters



Unix Parameters


Information with Integrity| www.indigo.co.nz

Tuning for stability and performance

Tuning Platforms

Server Operating Systems


Windows Parameters


MaxUserPort

(used to determine availability of user ports requested by applications such as
smartview, planning, etc.)


Default: 16383


Recommend: 65532


Use Netsh command to configure start port and range


netsh

int

ipv4 set
dynamicport

tcp

start=1025
num
=64508


Note: Use
netsh

int

ipv4 show
dynamicport

tcp


to determine dynamic port ranges



Receive Window Auto
-
Tuning Level


Win Server 2008 automatically adjusts TCP window scaling.


Some routers, firewalls, and OS’s are incompatible with it and could cause slow data transfer.


Disable TCP Auto
-
Tuning if your users experience slow network performance (ie: data sent very
slowly or drops data occasionally


CMD: netsh interface tcp show global





Set power option setting to “High Performance”


Ref:
http://support.microsoft.com/kb/2207548


Information with Integrity| www.indigo.co.nz

Tuning for stability and performance

Tuning Platforms

Server Operating Systems


Linux Parameters


Tcp_fin_timeout:


Default: 60


Recommend: 30


File Descriptors: (open files)


Default: 1024


Recommend 8192 (64 bit)


Tcp_max_syn_backlog


Default: 1024


Recommend 4096

Information with Integrity| www.indigo.co.nz

Tuning for stability and performance

Tuning Platforms

Server Operating Systems



Unix Parameters


Aix


Tcp_keepidle


Default:14400 (2 hours)


Recommend:600 (5 min)


Tcp_keepintvl


Default: 150


Recommend 10


Tcp_keepinit


Default: 150


Recommend 40


Listen Backlog


Default 1024


Recommend 8192


Socket Send and Receive Buffer Size


C
heck with IBM for optimal value for these values

Information with Integrity| www.indigo.co.nz

Tuning for stability and performance

Tuning Platforms

Server Operating Systems



Unix Parameters


Aix


User Limit Parameter


Set the following vlaues to Unlimited for 64
-
bit servers


Time (seconds)


File (blocks)


Data (kbytes)


Stack (kbytes)


Memory (kbytes)


Coredump (blocks)


Nofiles (descriptors)


Set to 8192 on 64
-
bit


SpinLooptime


Default: 40


Recommend 600


MALLOCOPTIONS


Set to multiheap:16

Information with Integrity| www.indigo.co.nz

Tuning for stability and performance

Tuning Platforms

Server Operating Systems



Unix Parameters


Solaris


File Descriptors (nofiles)


Default: 256


Recommend: 16384


Tcp_time_wait_interval


Default: 60000


Recommend: 30000


Tcp_xmit_hiwat and tcp_recv_hiwat


Calculated based on network bandwith and average latency


Recommend: (Bandwidth bits/sec) X ((Return Latency) X (8 bits/byte)


Solaris 9 Default = 48K


Very Fast Networks = >32K


Tcp_conn_hash_size


Default: 512 (Solaris 9, 0 in Solaris 10)


Recommend: 1024 (0 in Solaris 10)


Connection Backlog


Default 128 (max_q), 1024 (max_q0)


Recommend: 1024 (max_q), 4096 (max_q0)


Information with Integrity| www.indigo.co.nz

Tuning for stability and performance

Tuning Platforms

Web Servers



Oracle Https Server (OHS)


Settings are located in the
Middleware_Home/user_projects_epmsystem1/httpConfig/ohs/config/OHS/ohs_component/http.conf file


For Windows Uset these settings




Information with Integrity| www.indigo.co.nz

Tuning for stability and performance

Tuning Platforms

Web Servers



Oracle Https Server (OHS)


Settings are located in the
Middleware_Home/user_projects_epmsystem1/httpConfig/ohs/config/OHS/ohs_component/http.conf file


For Unix, use these settings



Information with Integrity| www.indigo.co.nz

Tuning for stability and performance

Tuning Platforms

Web Servers



IIS 7


Idle timeout


Default Value: 20


Recommend: 0


Regular time Interval


Default: 1740


Recommend 0


minBytesPerSecond


Default: 240


Recommended 50


Connection Timeout


Default: 120


Recommended 7200


Private Memory and Virtual Memory Limit


Set to 0 (64bit only)






Information with Integrity| www.indigo.co.nz

Tuning for stability and performance

Tuning Platforms

Web Servers



HTTP Compression/Caching


What is it?




Information with Integrity| www.indigo.co.nz

Tuning for stability and performance

Tuning Platforms

Web Servers



HTTP Compression/Caching


Why use compression?


Saves network bandwidth


Improves request and response latency


Applications which benefit from compression


HFM


Planning Web
Forms



Recommended only for Wide Area Networks, not LAN’s




Information with Integrity| www.indigo.co.nz

Tuning for stability and performance

Tuning Platforms

Application Servers



Oracle Weblogic


Increase the number of connection pool.


Use the Weblogic Administration Console to change the settings




Information with Integrity| www.indigo.co.nz

Tuning for stability and performance

Tuning Platforms

Application Servers



Oracle Weblogic


Tune 64bit Java Virtual Machines (JVM’s)


Jrocket JVM Settings








Sun JVM Settings




Information with Integrity| www.indigo.co.nz

Tuning for stability and performance

Tuning Platforms

Application Servers



IBM Websphere


Use the same settings as for Sun JVM



Information with Integrity| www.indigo.co.nz

Tuning for stability and performance

Tuning Platforms

Relational Databases



Oracle RDBMS


Init.Ora Settings


Processes=1500


Set Open_Cursors=7000


Set Cursor_Sharing=Force


Set Session_Cached_Cursors=100


Set Optimizer_Index_Cost_Adj to 50



Recommend that the DBA use the AWR and ADDM reports to analyze the user activity



As always, pay attention to the OS performance as well, especially CPU and RAM utilization on
the DB Server

Information with Integrity| www.indigo.co.nz

Tuning for stability and performance

Tuning Platforms

Client Operating Systems



Microsoft Windows


XP Professional


TCP/IP value limit


Default 10 (set in SP2)


Recommend 100


7





Apple OSX


None needed. Web Access Only



Information with Integrity| www.indigo.co.nz

Tuning for stability and performance

Tuning Platforms

Web Browsers



Internet Explorer


Performance increases in this order


IE 7


IE 8


IE 9


Firefox


Performs about 20% better than IE with EPM Web
forms




Information with Integrity| www.indigo.co.nz

Questions?

Summary and Q&A

Information with Integrity| www.indigo.co.nz


A decade of experience in Enterprise Performance
Management, Business Intelligence and Data Warehouse
solutions ~ Our sole focus


32 permanent staff, of which 24 are experienced consultants


Offices in Auckland, Wellington and Melbourne


Oracle certified Gold Partner


Over 50 Corporates and Government Customers


Our passion
-

Implementing world class
solutions for New Zealand organisations.


Who is Indigo?

Information with Integrity| www.indigo.co.nz


3 key tenets that shape and drive our partnership model.


We listen, agree and then implement in a transparent partnership,
not in isolation, with knowledge transfer a key success factor.


A successful partnership:


Our team brings extensive, in
-
depth experience in EPM, Data
Integration and Reporting with local NZ people.


You bring current in
-
depth knowledge of your business and it’s needs,
together with a knowledge on your data.


Honesty


Integrity


Professionalism

Indigo New Zealand Ltd

Information with Integrity| www.indigo.co.nz

Indigo Recent Sample Clients..