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.