Transcript Slide 1

<Insert Picture Here>
EPM – rodina aplikácií pre riadenie výkonu spoločností
Martina BRAUNEROVÁ
Principal sales consultant
Disclaimer
This document in any form, software or printed matter, contains proprietary
information that is the exclusive property of Oracle. Your access to and use of this
confidential material is subject to the terms and conditions of your Oracle Software
License and Service Agreement, which has been executed and with which you agree to
comply. This document and information contained herein may not be disclosed, copied,
reproduced or distributed to anyone outside Oracle without prior written consent of
Oracle. This document is not part of your license agreement nor can it be incorporated
into any contractual agreement with Oracle or its subsidiaries or affiliates.
This document is for informational purposes only and is intended solely to assist you in
planning for the implementation and upgrade of the product features described. It is
not a commitment to deliver any material, code, or functionality, and should not be
relied upon in making purchasing decisions. The development, release, and timing of
any features or functionality described in this document remains at the sole discretion
of Oracle.
Due to the nature of the product architecture, it may not be possible to safely include
all features described in this document without risking significant destabilization of
the code.
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
2
Agenda
• Čo je Enterprise Performance Management ?
• Prehľad o Financial Close Process
• Prehľad o Enterprise Planning
• Prehľad o Profitability Managemente a Planningu
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
3
Architektúra manažérskeho IS
Oracle BI
jednotná
prezentačná
vrstva
Dashboardy , prezentačná vrstva
Dashboardy , prezentačná vrstva
Metriky / KPI
Set
Goals
Oracle BI
Server
Logický model / vrátane oblasti
Enterpise
Performance
Management
Applications
Data Warehouse /
Datový model
Priamy
prístup k
zdrojovýmdát
am
Firma 1
Analyze
Proces načítania dát
Staging Area
ETL
Proces extrakcie
DAC
Automatizácia
Fyzické mapovania
Plan
Align
Insight
Performance
Action
Report
Monitor
Hyperion
Essbase
Firma 2
Banka
Firma3
Firma4
Datové zdroje
Dalšie
Technologická architektúra
Reporty, Analýzy
Reporty, Analýzy
Čo je Enterprise Performance
Management :
Aplikačné
produkty
Link
strategies
to pokrývajú:
plans and execution,
Monitor
financial
and operational
• Performance
Management
aplikácie results
• GRC Suite
against
goals, and applying analytics to
• BI Applications
• Essbase
Drive
• OBIEEenterprise-wide performance
improvement.
Copyright © 2011 Oracle and/or its affiliates. All rights reserved.
5
Piliere riadenia výkonu
Common Reporting & Interaction
Governance Risk and Compliance
Strategy Management
Planning & Forecasting
Financial Close
Profitability Management
Common Integration & Analysis
Data Quality and Consistent Dimensions
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
6
<Insert Picture Here>
Prehľad o Finančný
uzávierkový proces
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
7
Presnosť a správnosť časovania finančného
uzávierkového procesu
Riešenia pre špičkové riadenie finančného
uzávierkového procesu
Close Sub Ledgers
into GL (i.e. AR, AP,
FA, etc.)
Sub Ledger Close
General
Ledger Close
Gather and validate
complete data sets to
support all financial
reporting needs (i.e.
Legal Entity, Segment,
Management, Tax,
Sustainability Metrics,
etc.)
Data
Assurance
Perform Reconciliations
• Bank Reconciliations
• Standard Account Recon
• Sub Ledger Recon
Post Accruals
Consolidation
Deliver self
service reporting
to the
organization for
performance
discussions and
plan realignment
Internal Mgmt
Reporting
Automate consolidated
financial reporting
leveraging multiple
hierarchies/dimensions
and calculations (i.e. CTA,
FASB, KPI’s, FX,
Retained Earnings,
Topside Entries etc.)
External
Financial
Reporting
Automate and
deliver Edgar &
XBRL filings,
Statutory filings,
Tax, etc.
Filing
Automate external
reporting
gathering
disclosures and
financial
information
Výzvy finančného uzávierkového procesu
Sub Ledger Close
General
Ledger Close
Data
Assurance
Consolidation
Internal Mgmt
Reporting
External
Financial
Reporting
Filing
Pobočka 1
¥
Pobočka 2
Rozdiely v metodike účtovania
Chyby v manuálnych opravaách zápisov
£
Joint Venture
CAD
HR System
Sesterská
spoločnosť
$
Komplexné vlastnícke štruktúry
Heterogénne, fragmentované systémové
prostrdie
Časová náročnosť uzávierkového procesu s chýbajúcou internou
kontrolou nemôže byť zárukou správnych výsledkov bez podpory
systémov pre riadenie finančného uzávierkového procesu, je
obrazom riadenia businessu a firemnej stratégie
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
10
Financial Consolidation
Sub Ledger Close
General
Ledger Close
Data
Assurance
Consolidation
Internal Mgmt
Reporting
External
Financial
Reporting
Challenges
Best Practices
• Dáta sú v HK, v Excel, atď.
• Vnútropodnikové eliminácie
sú manuálne
• Zostavy sú tvorené excelom
• Reconciliácie sú v rôznych
dátových zdrojoch
• Verifikácia vstupných dát
• Konsolidovaný zdroj pre
reporting
• Centralizícia kalkulácií
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Filing
11
Štatutárny reporting
Sub Ledger Close
General
Ledger Close
Data
Assurance
Consolidation
Internal Mgmt
Reporting
External
Financial
Reporting
Výzvy
Best Practices
• Manuálna trorba zostáv
• Manuálny mamnagement
vlastníckych štruktúr
• Manuálne zmeny v zostavách
• Heterogénne prostredie pre
reporting
• Automatický reporting
• Automatické workflow
• Vlastnícke štruktúry
automaticky zahrnuté
• Vizibilita reportingu a
jednotnosť platformy
Copyright © 2009, Oracle and/or its affiliates. All rights reserved.
Filing
12
<Insert Picture Here>
Architektúra riešenia
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
13
Kľúčové komponenty riešenia
Financial Close Best Practices
CFO Dashboard
Governance, Risk & Compliance
Financial
CloseClose
Workflow
Hyperion
Financial
Manager
ERP:
Oracle, SAP,
Legacy, Other
Hyperion
Financial
Data Data
Quality
Assurance
Management
Transactions
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Tax
Calculations
Hyperion
Financial
Financial
Consolidation
Management Financial
Financial
and
Reporting,
Essbase
Mgmt.
Reporting
Tax
Filing
Hyperion
Document
Disclosure
Management
& Filing
Management
Reporting
14
<Insert Picture Here>
Prehľad Enterprise
Planning
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
15
One Window, not Multiple
Oracle EPM Workspace
• Personalizácia
• Obsahová
navigácia
• OBIEE integrácia
• Spája všetky
aplikácie EPM v
jednom prostredí
Jednotný Microsoft Office Interface
Smart View pre Office
• Adhoc Reporting
• Stylized Output:
–
–
–
–
Formats
Tables
Charts
Formulae
• Data Entry and
Apps Processing
• Word and PPT
• Now works with
OBIEE as source
Integrovaný reporting a analyzy
• Sofistikované ad-hoc
analýzy
• Kvalitný štatutárny reporting
• Jednoduchá a rýchla tvorba
reportov
• Komplexná
vnútroorganizačná štruktúra
• Automatcká kontrola
rozpočtu, rozpočtové
modely a aproximácie
Analytická aplikácia ako nástroj poznania a
kvalitného riadenia
Dimension Library
• Local and shared dimensions
• Application build wizard
• Reuse building blocks
Calculation Manager
• Visual design of business rules
• Share rules across all applications
• Reuse calculation components
Life Cycle Manager
• Move between Dev, Test and Production
• Application migration wizard
• Comparison and audit reporting
Drill-down do detailov transakcií
Budget vs Actuals
Audit Trail
Ledger Detail
Plánovací model reflektuje business
• Predefined dimensions
–
–
–
–
–
–
–
Account
Entity
Scenario
Version
Period
Year
Currency
• Customized dimensions
–
–
–
–
Product
Customer
Channel
…
Vstup dát prostredníctvom web a Excel
•
•
•
•
•
Form layout
Display options
Form contents
Access permissions
Business rules
Komplexná správa rozpočtu znižuje náklady
údrby
Data entry forms
Reports
Calculations
Hyperion Smart View™ for Office
• Use MS Office to enter,
analyze and report budget data
• MS Excel add-in allowing
access on or off-line
• Users download forms to Excel
• Manipulate data just like
the full web client
• Synchronize to server
when ready
Hyperion Workforce Planning
Improve Headcount, Salary and Compensation Planning
• Packaged solution for quick
implementations
• Plan salary and other
compensation at any level
• Add, edit and delete
employees and new hires
• Pre-defined or custom
calculations for taxes, etc.
• Integrates actuals
from HR systems
• Test scenarios in real-time
for impact analysis
Viac ako 25 rokov skúseností
2009
Close Process, Disclosure Management, Electronic Reporting
2005
Accelerated Filings, IFRS
2002
Sarbanes-Oxley, SAS99, COSO
2001
Euro – Euro Transition
1997
FAS131/IAS17 – Segment Reporting
1989
FAS95/IAS7 – Cash Flow Reporting
1988
FAS94/IAS27 – Minority Interests
1982
FAS52/IAS29 – Fx Trans
3,500 Customers
Hyperion
Financial Management
Hyperion
Enterprise
Micro Control
Global Impact
Copyright © 20011 Oracle and / or its affiliates. All rights reserved.
27
Kľúčové vlastnosti
• Riadená finačná konsolidácia s
funkcionalitou reportingu
• Kompletná dohľadateľnosť,
workflow a validácia
• “Smart Dimensionality”
• Flexibilný “what if” scenár
management funkcií
• Silný reportingový a analytický
nátroj
• Plná integrácia s ERP a
ostatnými transakčnými
systémami
• Jednoduché prispôsobenie
Copyright © 2009, Oracle and / or its affiliates. All rights reserved.
28
Manažérsky reporting
Helps understand
• Risks and future implications
• Of business alternatives and decisions
Forecasts Financial &
Operational
Budgets Financial &
Operational
Operational Data - Actuals
• Multiple data sources
• Financial KPIs and
Operational KPIs
• Frequent updates
Copyright © 2009, Oracle and / or its affiliates. All rights reserved.
•
•
•
•
Many iterations
New data created
Forward looking
Variance & what-if
analyses
• CXOs and Managers
• Knowledge workers
• Analysts
29
Najvyšší stupeň sofistikácie v plánovaní
Run models based
on key strategies
Set targets
Long-term strategic
plan
Annual
budget / plan
Seed targets to
annual
operating plan
Start annual
process
Validate operational
feasibility to
financial plan
Validate
operational
feasibility
Update forecast
with latest budget
and actuals
Evaluate
workforce and
capital
Evaluate resource
and capital
requirements
Monthly /
rolling
forecast
Update longterm strategic
plan
Update strategic
plan with latest
forecast
Assess and Manage Risk
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
30
Diskonektované plánovanie spôsobuje neefektivitu
práce
• Time – cycles take too long,
missed opportunities and
obsolete plans
Long-Term
Planning
Treasury
Plans
• Quality – data integrity, lack of
standardization and
communication
M&A
Senior Management
• Flexibility – lack of
responsiveness to changes
• Cost – many wasted resources,
questionable benefits
Annual Plan &
Forecast
Headcount
Plans
FP&A
Departmental
Plans
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Revenue &
Cost Models
31
<Insert Picture Here>
Architektúra riešenia
Copyright © 20011 Oracle and/or its affiliates. All rights reserved.
32
Kľúčové komponenty riešenia
Planning Best Practices
Crystal Ball
Predictive Modeling
& Simulation
Functional Plans
Long-Term
Hyperion
Financial
Strategic
Planning
Finance
Hyperion
Workforce
Workforce
Planning
Planning
Hyperion
Capital Assets
Capital
Assets
Planning
Planning
Project
Planning
Marketing
Planning
For detailed cost &
Revenue Planning
Operational
Revenue
Cost
Hyperion&Cost
andModeling
Profitability
Planning
Planning,
Budgeting
& Forecasting
Hyperion
Planning
Forward-looking
Hyperion Analytic
Essbase Engine
Financial
Detail
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Operational
Detail
33
<Insert Picture Here>
Itegrované Profitability
Analyses & Planning
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
34
Problém
Profitabilitná analýza –
Cesta k výnosnému businessu
Financial &
Operational Data
from Planning
Process
Data
Collection
Drivers
of Cost
Allocations
Entity
Profitability
Full Service
Costing
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.
Profitability
Analysis
New
Insights
to
Forecast
Decision
Support
Variance
Analysis
between
Actual & Plan
Update
Plans
Otázky