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

Requirement - Oracle EPM 11.1.2.4 Architecture / Hyperion 11.1.2.4 Architecture

Requirement - Oracle EPM 11.1.2.4 Architecture / Hyperion 11.1.2.4 Architecture – Sample Production and Pre-Production / UAT Hyperion Architecture with all the Luxury of modern features but with minimum cost

Business Sponsor requirement:

1. I want to have proven market standard Hyperion Architecture that all my competitor are doing
2. I have limited one time budget
3. I have limited recurring budget

Solution Architect requirement:

1. I want to have layered Architecture
2. I want Load Balancing Architecture
3. I want High Availability
4. I need a business continuity plan for my Hyperion Environment
5. We have two data centre; can we have data centre level fail-over or load balancing.
6. I want a single sign on in my Hyperion System. (I do not want Hyperion System to challenge me while login. But due to the sensitive data in Hyperion System and organization have given a directive, I am ok with external authentication)
7. In our organization Hyperion is mission critical application. (I know it is not but, I want to grab more attention as there is no other task in my hand right now)

End User requirement:

1. I want no new environment. I am happy with what I have. But if I have to use Hyperion (to save my job), I need extremely user friendly system.
2. I do not want a new set of user id and password to log into Hyperion System
3. I want the system should not log me off even if I go for a coffee or a chat over coffee with my college.
4. I want to use Excel to create a mission critical report with many metric, that no one in the universe can do except me. I do not have any specific requirement to give for that report while building the system.
5. I want Hyperion System should give me email alert that should go to my “Ignore email” folder.

List of Hyperion Modules customer want:

• Hyperion Financial Management (HFM) – two application
• Hyperion Planning (Planning) – two application each with Plan Type 1 and 2. No ASO reporting
• Hyperion Essbase (Essbase) – In addition to planning, 1 more BSO and 1 more ASO
• Oracle Hyperion Financial Reporting – 25 HFM report and 40 Planning report
• Oracle Hyperion Smart View for Office – User will have their own. But there will be around 10 excel based smart view template which will reside in workspace folder
• Hyperion Financial Data quality Management Enterprise Edition (FDMEE)
• Enterprise Performance Management Architect (EPMA)
• Hyperion Financial Close Management (FCM)
• Hyperion Supplemental Data Management (SDM)
• Oracle Enterprise Performance Reporting Cloud Service (EPRCS) – Cloud based Annual Group Report and BU Report preparation

Total Named User / Peak Concurrent User estimation:

• ·         Year 1 - 50 (20)
• ·         Year 2 - 150 (45)
• ·         Year 3 - 250 (63)

Upgrade Plan:

a) No upgrade in next 3 years. All Oracle published patches will be applied

Note: All of the above are fictitious requirement and you know why I have to say this.In the next “Tyne Article”, I’ll give the Oracle EPM / Hyperion Architecture diagram, sizing and few more recommendation and options to chose.

Hello World

Hello Hyperion World !
1234