1 / 30

Hyperion EPM Overview & Case Study

Hyperion EPM Overview & Case Study. Agenda. Introduction EPM Product Overview Case Study. Introduction. Use Hyperion?. Oracle Integrated. Oracle Integrated. ERP - Actual Amounts FDQM – Load / Map Data HFM – Consolidated Actual Amounts HP – Budget / Planning BI Tools.

locke
Download Presentation

Hyperion EPM Overview & Case Study

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Hyperion EPM Overview & Case Study

  2. Agenda • Introduction • EPM Product Overview • Case Study

  3. Introduction • Use Hyperion?

  4. Oracle Integrated

  5. Oracle Integrated • ERP - Actual Amounts • FDQM – Load / Map Data • HFM – Consolidated Actual Amounts • HP – Budget / Planning • BI Tools

  6. 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

  7. 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,

  8. Case Study • Growing US medical company • Headquarters in Northwest • Multiple sites across country • Annual Budget Process done manually in Excel

  9. 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

  10. 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

  11. Project Phases • Requirements / Design • Build / Unit Test • Test • Deploy / Go Live

  12. What is so unique about this project?

  13. Implementation • They built most of the application themselves • For a tiny fraction of the time and cost • In less than 3 months

  14. How is that possible?

  15. 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

  16. Timeline • 3/25 - Initial Sales Meeting • 4/1 – Scoping discussion • 4/12 – Customized training • 4/14 – Design session • 4/19 – Jibe installs / hosts Hyperion • 4/30 – Approve detailed design document • 5/1 – Create Planning application shell • May – Company X builds system • June – Company X tests system • July 1st – Go Live – Start annual budget process

  17. 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

  18. 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

  19. 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

  20. Phase 3 • Phase 3 - < 2 Months • Decentralize data entry to ~45 departments • Expand Budgeting and Reporting • Balance Sheet • Cash Flow

  21. 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

  22. Key Characteristics • Small Core Team • 1-2 people who makes decisions • Availability • Committed / Incentive to succeed • Standardized stable hierarchies, data entry, calculations and reporting

  23. DEMO

  24. Workspace

  25. Planning

  26. Smart View

  27. Reporting

  28. Web Analysis

  29. Ad Hoc Analysis

More Related