Oracle EPM 11.1.2.4 Development Architecture for 8-10 Concurrent User

As I have promised, this is the first architecture diagram. Few more to follow...

After a long discussion and delayed confirmation for project go ahead, your customer has suddenly realized they have to start the project immediately. They have asked for the sizing and unhappily conveyed the message their organization has a lead time of 10 weeks before delivering any server. So they are requesting if they can have some bare minimum configuration that can be given even without going for any procurement and obviously virtual server.

If situation does not permits to have best practices to follow and other so called factor of safety, you can follow the below architecture.

Oracle EPM 11.1.2.4 Development Architecture for 8-10 Concurrent User

Assumption (Type of User):

• One project manager who occasionally log into Hyperion System
• One wise Functional consultant will be mostly limited to giving details either email or word / excel document for various requirements / requirement clarification
• One system admin; who will also help here and there
• One HFM Functional (CPA/CFA/etc.)
• One HFM Developer
• One Planning Functional Consultant
• One Planning Developer
• One  Reporting Builder
• One FDMEE / Data Loader
• One all-rounder technical who will cover DRM/HFM Metadata/Planning outline building part and etc.
• One watchdog who need access to everywhere but movement would limited on tail only

So there should be around 8 concurrent user every time

Following primary modules are required to be installed

• Oracle Hyperion Shared Service 11.1.2.4
• Oracle Hyperion Workspace 11.1.2.4
• Oracle Hyperion Financial Reporting 11.1.2.4.003
• Oracle Hyperion Financial Management (HFM) 11.1.2.4.101
• Oracle Data Relationship Management (DRM) 11.1.2.4
• Oracle Hyperion Planning 11.1.2.4
• Oracle Hyperion Essbase 11.1.2.4                
• Oracle Financial Data quality Management (FDMEE) 11.1.2.4
• Oracle Financial Close Management 11.1.2.4
• Oracle SOA 11.1.1.7.0
• Oracle EPMA 11.1.2.4

We need minimum two dedicated virtual or physical server and a shared or dedicated database

Oracle database is my recommendation

Serve 1 and 2: OS Recommended Windows 2012 Enterprise Edition
CPU: Minimum 8 core (per core 2.1 GHz or more, dedicated)
RAM: 32GB or more (Dedicated RAM only).
Disk: Minimum 80 GB or more

*** MUST *** dedicated I/O on each server : Minimum 20MBPS

DB Server: Oracle Enterprise Linux, Oracle 11.2g+

Shared database with mentioned schema in diagram. 

All schema can be created in two tablespace. 

FDMEE in one tablespace and rest in other tablespace.

Note: Before Starting installation of Oracle EPM FCM suite, please ensure you have dedicated RAM, you absolutely have no issue with network and CPU usage % while logged in come down to less than 1% or 0%.

 

Oracle EPM 11.1.2.4 Development Architecture