Hyperion EPM Overview
&
Case Study
Agenda
• Introduction
• EPM Product Overview
• Case Study
Introduction
Use Hyperion?
Oracle Integrated
BI
ERP
FDQMAcct Close
Planning
Oracle Integrated
• ERP - Actual Amounts• FDQM – Load / Map Data• HFM – Consolidated Actual Amounts• HP – Budget / Planning• BI Tools
Financial Close• Hyperion Financial Management (HFM)
– Comprehensive, Web-based application that delivers global financial consolidation, reporting & analysis.
• Hyperion Financial Close Mgt– Centralizes mgt of all period-end close activities,
replacing checklists with dynamic dashboards that give users ability to immediately view & act on info.
• Hyperion Disclosure Mgt– Centralize & effectively manage the development of
XBRL tagged submissions
Planning• Hyperion Planning
– Centralized, Excel & Web-based planning, budgeting and forecasting solution that integrates financial & operational planning processes and improves business predictability.
• Hyperion Workforce Planning– Planning module that makes headcount, salary, &
compensation planning fast and efficient across the enterprise.
• Hyperion Capital Asset Planning– Planning module that automates the planning of capital
assets and capital asset related expenses,
Case Study
• Growing US medical company
• Headquarters in Northwest
• Multiple sites across country
• Annual Budget Process done manually in Excel
Challenges
• Extremely time consuming– Build and manage model – What if analysis– Report on data
• Comparative reporting Actual vs. Budget• Track versions of budget amounts• Minimal controls in place• Security of data – on laptop• Not easy to share with others• Consolidating amounts
Solution
• Jibe Jumpstart Implementation• Implement Hyperion EPM System – Planning
– Central repository database – Integrates actual and budget amounts– Standard calculations– Decentralize Planning – Uses multi-dimensional hierarchies
• Use BI Tools– Financial Reports – Well formatted reports– Excel Smart View – Ad hoc analysis
Project Phases
• Requirements / Design
• Build / Unit Test
• Test
• Deploy / Go Live
What is so unique about this project?
Implementation
• They built most of the application themselves
• For a tiny fraction of the time and cost
• In less than 3 months
How is that possible?
Jump Start
• Consultant for project involved in sales cycle• Hosted Application• Customized detailed training session• Design session for current and future needs• Prioritize requirements & assign to phases• Keep only ‘must have’ items in phase 1• Detailed design document• Weekly task review sessions• Jibe built initial calculations• Detailed calculation review
Timeline
3/25 - Initial Sales Meeting4/1 – Scoping discussion4/12 – Customized training4/14 – Design session4/19 – Jibe installs / hosts Hyperion4/30 – Approve detailed design document5/1 – Create Planning application shellMay – Company X builds systemJune – Company X tests systemJuly 1st – Go Live – Start annual budget process
Phase 1
• Finance owns and maintains system• Budget for:
– Revenues– Expenses– Individual employee expenses including existing
and new employees– Capital Expenditures
• Load current year budget and actual amounts • Comparative Income Statement reporting• Use Department Excel templates
Phase 1 (con’t)
• Calculations– Aggregations– Clear Data– Project Allocation– Employee Expenses
• Deferred Compensation• Shift Differential• Salary Adjustment• Bonus• 401K• Payroll Taxes• Benefits• Temporary Labor
Phase 2 - Expand• Phase 2 - < 2 Months• Calculation Training• Add additional calculations
– New hire salary– Depreciation– Allocations
• Start quarterly forecasting within system• Web Forms• Reports• Calculations
• Automate calculations to run nightly
Phase 3
• Phase 3 - < 2 Months– Decentralize data entry to ~45 departments
• Expand Budgeting and Reporting – Balance Sheet – Cash Flow
Benefits• Decentralization
– Departments took ownership of their data– Provided better understanding of data– Workflow identified bottlenecks
• BI Tools– Less mgt emails asking for data– Less time to develop budget & forecasts– More time & improved analysis tools
Key Characteristics
• Small Core Team• 1-2 people who makes decisions• Availability• Committed / Incentive to succeed• Standardized stable hierarchies, data entry,
calculations and reporting
DEMO
Workspace
Planning
Smart View
Reporting
Web Analysis
Ad Hoc Analysis