A Decade of Hits! The Evolution of Hyperion Financial Management

Chris BarbieriVice President

September 2014

Focus

Services

People

Methodology

Customers

Partnership

15 Years

700+ clients

1000+ projects

About Edgewater Ranzal

Dashboards & Scorecards, Financial Analytics &

Reporting, Operational Analytics, What-if

Analysis, Query & Reporting, Visual ExplorationFinancial performance, Legal,

Segment & Mgmt Reporting, Financial Close

HFM Optimization, Performance Lab

SOX Compliance SupportStrategic Finance, Planning, Budgeting,

Forecasting, Workforce Planning, Capital

Planning, Project Financial Planning

Data Integration, Financial Data

Management, Data Warehousing,

Master Data Management &DRM,

ETL Services, Automation

Project/Program Mgmt, EPM

Road Maps, Application

Reviews, Business

Requirements, Process Change,

Documentation

Installation, Upgrades,

Migration, System

Monitoring, Backup and

Recovery, Disaster Recovery,

Load Testing, Hardware Sizing,

Exalytics Benchmarking

Consolidation

Business

Intelligence

Enterprise

Planning

Infrastructure

Training &

Support Services

Project

Management

Data

Services

Costing &

Profitability

Mgmt

Support Services – Infrastructure &

Application Support Contracts

Key Teach Course Delivery: Planning, Essbase, Financial

Reporting, Smart View, HPCM, HFM, FDM, DRM, OBIEE

Custom Training Delivery: Process & Reporting

HPCM Standard & Detailed

Models, Waterfall Allocations,

Activity Based Costing, Customer,

Product & LOB Profitability

► Provide next generation product based on fanatical usability of Hyperion Enterprise– 12 dimensions plus Line Item Detail and Cell Text

– Windows and HTML user interfaces

– Scalable to hundreds of concurrent users

– Vbscript based rules language

– External authentication

► The suite– Hyperion Reports

– Hyperion Retrieve and Pivot Data (Excel)

– Hyperion Application Link (data integration)

► Version 1.0 launched 2000– First implementations in Spring 2001

► Release 2.0

► Web Data Entry

► Organization by Period

– Vital for European market and certain industries

► Ownership management module

► Custom dimension switch type and switch sign

– Facilitates cash flow development

► Win32 Rules Editor

The shift from thick client

to web client was a big hit

in 2001

► Adding functionality

– Process Management

– Extended Analytics

– Dynamic account type for Ratios

– Auditing

• Users on System

• Task Audit

• Data Audit

► Improving usability

– Java applets for web interaction

– End User Data Load Balancing

Java provided rich

functionality in 2003

► Overhauled web user interface: Tadpole– Made it more of an application look

– Workspace

► Intercompany transaction module

► Task Automation

► Hyperion Smart View for Office– Fully replaces Hyperion Retrieve and Pivot

– One Office integration tool for EPMA

► Shared services: Hyperion Hub– Centralized metadata

– Data synchronization

► Performance improvement for large data sets

Remove the

browser’s

toolbar and

we have a

web based

application

► “9” Numbering scheme synchronized with Essbase

► Combined report tools into a single product

► Access products through a unified portal called Workspace

(4.1 aka 4.0.5)

► Business Enterprise Performance Management Architect in 9.3– Long term replacement for Hub

– Application Library

► HyperRoll / Essbase Analytics Link– Patented technology synchronizes

HFM data in Essbase

– On-demand or real-time push from HFM to Essbase for reporting

► Hyperion acquires Upstream– Leading data integration software

“Ledgerlink on steroids”

– Fanatical customer base!

– Weblink renamed Financial Data Quality Management

► Phased Submission in 9.2

– Support for multiple submission and approval phases

throughout the close

• Phase 1: Day 3 - P&L and Balance Sheet

• Phase 2: Day 4 - Roll-forwards, Cash Flow

• Phase 3: Day 5 - supplemental schedules

► Equity Pick-Up module in 9.2.0.3 and 9.3.1

– The underlying principle of the equity pickup

adjustment is to provide a fair picture of the value of

the portfolio owned by the holding company.

► Numbering Scheme Synchronized with Oracle products

► 64 bit HFM engine– Raise the roof on memory for increased data set and

higher data volume

► Graphical rules module!– Calc Manager debuts for HFM, Essbase, Planning

► Consolidation ‘Journals”– Present automated consolidation entries including

intercompany elimination as journals

► Alternative to VBscript for business logic

► Common interface for Essbase and HFM

► Unified tool for

migrating application

artifacts between

applications and

between environments

► Annotations directly in Financial Reports

► Support for external documents in books too!

► Oracle Financial Management Analytics (OFMA)

– Pre-built OBIEE application and reports

– Wizard-based setup

► New modules in 11.1.2.2

– Account Reconciliation Module analytics

– Financial Data Quality Management analytics

11.1.2.2 11.1.2.3 11.1.2.4 11.1.2.x

► Disclosure Management introduced with 11.1.2.1– XBRL, Edgar, PDF

reporting

– Document Workflow

► Products integrate with HFM, Essbase, Planning or can be used stand-alone

► World class master data management system

– Acquired by Hyperion in 2005 as MDM

► Direct integration with EPMA in 11.1.2.2

► 11.1.2.3 integrates with Data Relationship Governance for excellent workflow capabilities

► Due to popular demand Oracle provides

“configurable dimensions” in 11.1.2.2

– Better alignment with ERP systems

– Customers moving to 5-7 custom dimensions

– Performance is very good

► Overhaul of User Interface

– Adopt Oracle’s ADF standards

– Synchronization with Oracle products

► Combine robust data movement engine of ODI

with FDM classic usability and extensibility

– Switch from Visual basic to Jython

– Another step toward multi-platform support

► Bring your iPads and other devices to work

► OFMA mobile app

► Quantitative Management and Reporting

– Address Europe’s Solvency II directive for insurance

industry (January 2016)

– Released for HFM 11.1.2.2, updated in 11.1.2.3

► Hyperion Tax Provisioning

� Purpose-Built / Out-of-Box: a Tax Provision

solution built on the Hyperion Financial Close

Suite:

1. Data Collection - automated & manual

2. Tax Provision Calculation - US GAAP & IFRS

3. Tax Reporting - out-of-box tax reports & ad-hoc

� Owned by Tax - Leverage existing investment

in Hyperion, but both Tax & Finance retain

the flexibility they need

� Integrates with Tax Compliance - Enhances &

integrates with tax compliance software

� Rapid Implementation & Ease of use: the

technology & expertise is already in the

Finance organization

► Removing the Microsoft dependency

– Yields platform choice

• Windows

• Linux

– Support Oracle virtualization

– Lower cost of ownership

► More complete suite available on Exalytics

– HFM, Shared Services, Financial Reports, FDMEE,

Planning

Core HFM

Shared

Services Data Integration

Metadata

Integration Reporting

Prebuilt

Applications

Work

flow

Web application

User

management

Financial Data Quality

Management EPMA

Financial

Reports QMR FCM

Configurable

dimensions Calc Manager Essbase Analytics Link

Data Relationship

Management Annotations HTP ARM

64 bit Workspace Data Synch

Data Relationship

Governance Smart View Starter Kits SDM

Intercompany

Transaction Module

LifeCycle

Management OBIEE

Data entry forms OFMA

Statutory support ARM Analytics

Auditing FDM Analytics

Dynamic Accounts

Disclosure

Management

Process Management

Extended Analytics

Task Automation

Equity Pick-up

Consolidation journals

Exalytics

► https://support.oracle.com/oip/faces/secure/km/DocumentDisplay.jspx?id=1092114.1

Chris Barbiericbarbieri@ranzal.com

Needham, MA

USA

+1.617.480.6173

www.ranzal.com

*Special thanks to Oracle and my

colleagues at Ranzal for

supporting screen shots and

historical documents