introduction to hpcm
TRANSCRIPT
![Page 1: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/1.jpg)
HPCMHyperion Profitability and Cost Management
Introduction to HPCM
April 29, 2016
Srinivas Salguti
![Page 2: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/2.jpg)
• Proven and Trusted Track Record:• 250+ clients – all CPM / EPM focused
• 500+ CPM / EPM projects
• 150+ HFM projects
• 175+ FDM projects
• 100+ Planning / Essbase projects
• 20+ OneStream Clients (Market Leader)
• 100% client success (13+ years in business)
• 80 employees in 21 states
Finit Overview
![Page 3: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/3.jpg)
Why is Finit here?
Page 3
Finit takes pride in being a company of makers and Doers; people who dig in and get their hands dirty
We make and deliver personalized financial reporting solutions and experiences
…Not Company to Company, but Person to
Person
By listening, questioning, and analyzing
![Page 4: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/4.jpg)
The Finit Family
Page 4
Fully aligned with our clients, not just bottom line $
No debt or external ownership
Work with Finit employees, no subcontractors
Compensationbased on CLIENT SATISFACTION
PRIVATELY OWNED
CLIENT SATISFACTION
NOSUBCONTRACTORS
DEBT FREE
![Page 5: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/5.jpg)
Finit Values
Page 5
Our values on which we ask you to provide consultant feedback:
• Approach & Collaboration
• Integrity & Honesty
• Client Betterment
• Self Betterment
• Colleague Betterment
• Finit Betterment
• Work Effectiveness
• Impact & Innovation
• Proactiveness & Passion
Service Solutions Betterment
![Page 6: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/6.jpg)
Finit Customer Success
Page 6
Our values, culture, and approach to becoming a trusted advisor to our
customers has led to
100% customer success
for every Finit client (250+) and for every Oracle Hyperion project (500+)
![Page 7: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/7.jpg)
Some Finit Customers
![Page 8: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/8.jpg)
Questions
![Page 9: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/9.jpg)
About the Presenter
Slide 9
Srinivas Salguti
• Member of Finit’s Planning and Essbase Practice
• Worked in Enterprise performance management workspace for the last 12 + years• 10 years at Hyperion/Oracle consulting services
• Primary focus on Hyperion Planning and Essbase
• 3 HPCM full cycle implementations
• OBIEE integration with Essbase
• PBCS
• Certified implementation consultant• Hyperion Planning
• Essbase
![Page 10: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/10.jpg)
Agenda
• What is Profitability
• Oracle’s HPCM Architecture
• Model Components
• Demo
• Key Features of HPCM
• Q & A
Slide 10
![Page 11: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/11.jpg)
Profitability Questions
• What defines a profitable customer?
• What is the profit contribution margin of a product or a service?
• How do business processes impact profitability?
• Cost drivers are not clearly understood and as a result, cost-cutting initiatives are not targeted at the right places
• Focus only on cost and not revenue
Slide 11
![Page 12: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/12.jpg)
How companies try to tackle profitability questions
Slide 12
• Excel/Manual Based Processes and BI Tools Provide Incomplete Solutions
• Lack of process
• Lack of integration
• Lack of confidence
• Rigid, costly to maintain
• Inability to act
![Page 13: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/13.jpg)
What is Oracle Hyperion Profitability and Cost Management (HPCM)?
• A user-driven Performance Management application that:
• Measures, allocates and assigns Cost and Revenues
• Computes Profitability for business segments, customers and products
• Provides scenario modeling for decision making
• Actual Vs Budget
• What-If
• Is tightly integrated with EPM Technology Stack• Shared Services
• EPMA
• Essbase
• Reporting Tools
Slide 13
![Page 14: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/14.jpg)
Profitability Model Types
• Standard Profitability• Enables you to monitor and control direct contribution data for your entire model.
• Data for the Standard Profitability model is housed in both Essbase multidimensional databases and relational databases.
• Provides ability to use hierarchical structures.
• Detailed Profitability• Provides a single-step allocation of data from a single source to a destination for the
purpose of analyzing profitability.
• Data for the Detailed Profitability model is housed in relational databases only.
• Can handle extremely large volumes.
• Management Ledger Profitability• No concept of stages or layers.
• All structure is controlled through the organization of rule sets and rules under POVs.
• Designed for use by analysts who may not have much experience with Essbase or programming languages but have good understanding of management reporting.
Slide 14
![Page 15: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/15.jpg)
Profitability Model use cases
• Standard Model• Where focus is on contribution analysis which enables flow of cost and revenue through all
stages to determine where there is a chance to improve process
• Ex: Financial services - Customer & Branch profitability analysis – used HPCM model to allocated shared services to markets/branches and then to customer / product level to analysis profitability at lowest level
• Healthcare Services – Allocation Model for reimbursement of expenses.
• Detailed Profitability• Single step allocation process with pools or rates from single source to destination for
profitability analysis.
• Ex: Airline route analysis : Track route detailed cost analysis
• Management Ledger• Used by analysts who have deep domain expertise in computation and reporting methods of
management reporting
• Ex: Management reporting analysis : Management reporting analysts who would like to create cost/revenue allocations using defined rules to provide different views for management reporting.
Slide 15
![Page 16: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/16.jpg)
Oracle’s Hyperion Profitability & Cost Management
Slide 16
![Page 17: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/17.jpg)
HPCM Architecture (Standard Profitability)
Slide 17
Calculation
Cube
EPM ArchitectModel definition:
• Stages
• Drivers
• AssignmentsReporting
Cube
Deploy
dimensions
Profitability & Cost Management Model
Aggregate storageoutline
Reporting and Analysis tools:
• Financial Reporting
• Web Analysis
• Smart View
Transfer data
Maintain Metadata & Model design
Workspace
Hyperion Profitability & Cost Management Solution
Block storage outline
Calc script
![Page 18: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/18.jpg)
Oracle EPM Stack - Components of HPCM
• Performance Management Architect (EPMA) – Maintenance of application metadata
• HPCM – Model design and maintenance
• Workspace – Common product interface layer
• Shared Services – Security and product administration
• Essbase – Multi-dimension databases for calculation of models and reporting
• Relation DB – Used in-case of detailed model
• Reporting Tools (not all required) – Smartview Office Addin, Financial Reporting, Web Analysis, OBIEE
Slide 18
![Page 19: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/19.jpg)
HPCM Model Build Sequence
Slide 19
Transfer
EPMA
Interface
StagesDriver
Definitions
Driver
SelectionPOV
POV
Dimensions
AssignmentsAssignment
Rules
Deploy Calculation
and Reporting Cubes
Resource
Costs
Driver/Assignment
DataEssbase database
Reporting
Calculate
Generate Calc Scripts
Create / Deploy Application
HPCM
Interface
Members
Hierarchy
Alias
Property
Alias
Dimension
Business
Dimensions
Measures
Dimension
Calculate Genealogy
Changed Changed
Essbase database
Calculation
1
3
45
6
Sequence
Reporting
EPMA
Application
HPCM
Application
Essbase
Application
2
![Page 20: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/20.jpg)
Creating Applications - Steps
• Create Dimensions in EPMA
• Create Profitability Application in EPMA• Required System Dimensions:
• Measures
• Allocation Type
• Required User Dimensions:• At least 1 POV Dim
• At least 1 Business Dim
• Optional Dimensions:• Alias
• Attributes
• Validate and Deploy to HPCM
Slide 20
![Page 21: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/21.jpg)
HPCM Task Flow Overview
Slide 21
Define stages
Create drivers
Select drivers
Make assignments
Validate model structure
Generate Essbase Applications
Load data into Essbase
Run calculation scripts
Create reports
Validate calculations
Generate Calculation scripts
Validate the data
![Page 22: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/22.jpg)
HPCM Model Build - Stages
Slide 22
Define Stages – Stages define available segments for data allocations.
Stage One: GL Accounts
Stage Two: Processes
Stage Three: Products
Stage Four: Customers
General ledger (P&L)
Departments, Activities
Products
Customers, Products
![Page 23: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/23.jpg)
HPCM Model Build – Stages
Slide 23
Business Operations stage with two dimensions Departments and Activities.
![Page 24: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/24.jpg)
HPCM Model Build - Drivers – How Much ???
Page 24
Stage One
Stage Two
Drivers provide the formulas to allocate values at source intersections to their assigned destination intersections.
Data
Driver 1
Driver 2Data Data
![Page 25: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/25.jpg)
Driver Definitions
Page 25
How Salary is allocated -> Quantity * Rate
![Page 26: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/26.jpg)
HPCM model Build - Assignments
Page 26Page 26
Assignments define where and how to move data from one stage to another.
![Page 27: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/27.jpg)
HPCM model Build – Assignments Setup
Page 27Page 27
![Page 28: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/28.jpg)
HPCM Standard Model
Page 28Page 28
DEMO
![Page 29: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/29.jpg)
Key Features
Page 29Page 29
• Model / Driver Driven Approach
• Multi-Stage, Multi-Step Allocations
• Empowers users to execute/update allocation methodologies without depending on IT
• Traceability Maps
• Model Validation Reporting
![Page 30: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/30.jpg)
Traceability
Page 30Page 30
• Provide transparency into revenue and cost allocations.
• You may trace backwards and forwards from any point in the allocation model
![Page 31: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/31.jpg)
Model Validation
Page 31Page 31
• Model validation reporting helps ensure completeness of model.
• Stage Balancing follows the inputs and allocated outputs and include idle capacity and unassigned amounts
![Page 32: Introduction to HPCM](https://reader030.vdocuments.us/reader030/viewer/2022021417/5872afb01a28ab523c8b53a7/html5/thumbnails/32.jpg)
Thank You for Attending!
Page 32
Today’s Presenter:
Srinivas Salguti
General Questions:
Greg Barrett
Joe Mizerk
Copy of the slides or Recording:
Email us for a copy of the slides or a link to the recording
Past webinars:
www.finit.com/webinars
Follow us on Twitter for updates:
@Finit_Solutions