Introducing Enterprise Performance Management 2008.12
Agenda Why Oracle s EMP/BI? Oracle의 EPM 개요 Oracle의 BI 개요 결론
Why Oracle s EMP/BI?
시장에서의리더 BI, CPM, DW 분야의 Leader Magic Quadrant for Business Intelligence Platforms, 2008 Magic Quadrant for CPM Suites, 2007 Magic Quadrant for Data Warehouse Database Management Systems, 2007 The Magic Quadrant is copyrighted 2008 by Gartner, Inc. and is reused with permission. The Magic Quadrant is a graphical representation of a marketplace at and for a specific time period. It depicts Gartner's analysis of how certain vendors measure against criteria for that marketplace, as defined by Gartner. Gartner does not endorse any vendor, product or service depicted in the Magic Quadrant, and does not advise technology users to select only those vendors placed in the "Leaders" quadrant. The Magic Quadrant is intended solely as a research tool, and is not meant to be a specific guide to action. Gartner disclaims all warranties, express or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose. These Magic Quadrant graphics were published by Gartner, Inc. as part of larger research notes and should be evaluated in the context of the entire reports. The Gartner reports are available upon request from Oracle. Sources: Gartner, Inc., Magic Quadrant for Business Intelligence Platforms, 2008 by James Richardson, Kurt Schlegel, Bill Hostmann, Neil McMurchy, 1 February 2008 Gartner, Inc., Magic Quadrant for CPM Suites, 2007 by Nigel Rayner, Neil Chandler, John E. Van Decker, 19 December 2007 Gartner, Inc., Magic Quadrant for Data Warehouse Database Management Systems, 2007 by Donald Feinberg and Mark A. Beyer, 10 October 2007
Oracle s EPM 비젼 오늘에집중하고, 내일을위한계획 전략적목표를기업운영의사결정에연계 모든관리프로세스를통합 의사결정활동에일관되고, 신뢰할수있는통찰력을전달 낮은비용과시스템의복잡성감소 기업성과에대한 Single version of the truth 제공
One System for All EPM Activities Goal Setting Modeling Planning Monitoring Analysis Reporting
Oracle s EPM 개요
Oracle s EPM 시스템 EPM WORKSPACE Desktop Web Search Office Alerts Mobile PERFORMANCE MANAGEMENT APPLICATIONS Strategy Management Business Planning Profitability Management Financial Reporting & Compliance Svcs. BI Applications Contact Order Supply Mktg. BI APPLICATIONS Center Mgmt. Chain HR Finance BUSINESS INTELLIGENCE FOUNDATION Business Common Intelligence Enterprise Information Foundation Model FUSION MIDDLEWARE SOA Data Quality Data Integration MDM Identity Management Content Management Business Process Management OLTP & ODS Systems Data Warehouse Data Mart OLAP SAP, Oracle, Siebel, PeopleSoft, Custom Excel XML Business Process
Oracle s Hyperion Financial Management 재무통합, 리포팅과분석 특징 Customization의용이성 통합의용이성 재무데이터품질관리 완전한감사추적 (Audit Trails) 유연한워크플로우 강력한리포팅 재무현업의소유와운영환경장점 재무수치에대한정확성제공 재무처리 (Cycle) 시간의단축 수집과유형성의자동화 준수 (Compliance) 비용의저비용화 처리속도와민첩성
Hyperion Financial Management 주요기능 패키지화된재무기능 연결및리포팅관련기능 환율환산 내부거래자동상계 수정분개 (Soft closing) 계정과목특성 ( 대차, 손익, 비재무구분 ) Time Intelligence (FY 와 CY 의구분등 ) 다양한언어로 Description 기술가능 (10 개언어 ) US, UK GAAP, IAS, KGAAP 등 Multi GAAP consolidation 지원 Financial Consolidation 지능화된다차원구조 다차원구조 연결경영관리에필요한 8 개기본차원 (Scenario, Period, Year, View, Entity, Value, Account, Intercompany) Customize 가능한 4 개차원 자회사단위별연결뿐아니라전략사업단위별관리연결 자회사, 전략사업부 (SBU), 제품, 지역, 판매망등 쉽고유연한 Multi Consolidation 시뮬레이션및시나리오버전관리 지능화된차원들은전체시스템에서공유하여사용 계정과목특성, 적용환율, 조직특성등각차원의지능화 이를기반으로구축, 유지보수, Navigation 을통한리포팅 / 분석이용이 ( 당월 / 누계, 회기누계, 비율분석등 )
Oracle s Hyperion Planning 특징 전략적경영 ( 사업 ) 계획의수립 모델링과시뮬레이션지원 What-if 분석 엑셀통합 전사적협업 (Collaboration) Native 리포팅과분석 경영계획과예산수립 특장점 처리성능 처리정확성 재무와운영의분개 (Align) 회계관리 (Accountability) 과거, 현재와미래의사업성과에대한가시성제공
Hyperion Planning 주요기능 전사경영계획 대용량데이터및사용자지원을통해전사차원의일원화된경영계획프로세스지원 전사차원의계획수립의용이성확보 강력한취합및배부기능 일괄된계획시스템의관리및통제기능으로프로세스단축
Hyperion Planning 주요기능 유연한모델링 경영계획업무를지원하기위한목적으로개발된 Package 자체내장기능 - 경영계획조직관리를위한기능, Assumption 의관리를위한기능, Account 관리를위한기능, Cost Center, Profit Center 등 - 경영계획편성에필요한기능 Version 관리기능, 시나리오관리기능, 배부기능등 완벽한웹환경지원
Hyperion Planning 주요기능 Business Rule Setting 경영계획모듈에내장되어있는 Business Rule 을이용하여 Setting Graphical Mode 와 Script Mode 모두를지원 - Graphical Mode : 배부및 DB 운영상의기본기능을제공 Visual 한환경에서직관적으로판단하여 Rule Setting 을할수있도록지원 - Script Mode : Forecasting, DCF 계산, Interest Rate 계산등에필요한약 250 여개의확장함수를내장하여재무및경영계획작업을원활히수행할수있도록지원 비즈니스로직구현을위한업무단계를요약하여표시 비즈니스로직구현을위한 setting
Hyperion Planning 주요기능 Powerful Workflow & Process 일정관리를위한업무진행현황을관리하기위한 Workflow Management 기능지원 ( 데이터마감관리, 입력현황, Version관리등 ) Smart View (Office Integration) 웹에서작성한 Template 을 Excel 에서동일하게사용할수있으며, Off Line 상태에서작업수행 Offline Planning - planning on the go. One MS Excel add-in, allowing access on or off-line. Users download Hyperion Planning forms to Smart View. Can develop budgets, plans and forecasts unconnected, anywhere! Re-synchronize to server when ready.
Hyperion Planning 사례화면
Hyperion Planning 사례화면
Hyperion Planning 사례화면
Oracle s Hyperion Performance Scorecard 전략적성과관리시스템의개발프로세스는 KPI( 지표 ) 설정및이를전략과조직의스코어카드와연계, 각성과부분에대한목표설정, 상시적인모니터링을통한성과파악, 각성과결과에대한 Drill Down을통한심층원인추적, 추적된원인에대한결과를조직적으로공유하고 Feedback을통한개선활동그리고최종적인성과평가로나누어집니다. 전략과 KPI ( 지표 ) 연계 성과목표설정 성과파악 ( 전략맵 ) 심층원인추적 Feedback & Corrective Action 성과평가
Hyperion Performance Scorecard 주요기능 Client Browser 설계자관리자결과집계리포트 & 분석경보 Server Measures (KPI) Frameworks 직원스코어카드목표이니셔티브 차트 추세 노트 전략 / 조직 /Cause & Effect 맵 경보 리포트프로세스관리 Essbase Cube 생성 Data Data Import Meta Data Repository Security Interoperability Audit Trail and Logs
Hyperion Performance Scorecard 사례화면 1 1. 모니터링할조직의전략맵을선택 2. CSF 중상세정보를조회할시더블클릭으로선택 2 3. 해당 CSF 의상세현황을확인 ( 모든조회는 보고날짜 기준의상태이다.) 3
Hyperion Performance Scorecard 사례화면 1. 조직별성과분석 2. 전략별성과분석 3. 지표상세분석및의견교환 4. 인과관계에의한원인추적 5. 추세및비교분석 6. 다차원 Drill down 분석
Hyperion Performance Scorecard 사례화면
Oracle의 BI 개요
확장되고통합된분석 Infrastructure 제공 데이터통합 비정형분석 대화식대시보드 Essbase Analytics 리포팅과정보배포 전향적감지와통보 모바일분석환경 MS Office 와 Outlook 통합환경 공용전사정보모델 (Common Enterprise Information Model) 통합된보안, 사용자관리, 개인화다차원계산과통합엔진 OLTP & ODS 시스템 데이터웨어하우스데이터마트 Essbase SAP, Oracle PeopleSoft, Siebel, Custom Apps Files Excel XML 비즈니스프로세스
통합된사용자인터페이스 대시보드 비정형 Alert Reporting
완전하고, Pre-built된최상의 BI Solutions Auto Comms & Media Complex Mfg Consumer Sector Energy Financial Services High Tech Insurance & Health Life Sciences Public Sector Travel & Trans Sales Service & Contact Center Marketing Order Management & Fulfillment Supply Chain Financials Human Resources Pipeline Analysis Churn Propensity Campaign Scorecard Order Linearity Supplier Performance A/R & A/P Analysis Employee Productivity Triangulated Forecasting Sales Team Effectiveness Customer Satisfaction Resolution Rates Response Rates Product Propensity Orders vs. Available Inventory Cycle Time Analysis Spend Analysis Procurement Cycle Times GL / Balance Sheet Analysis Customer & Product Profitability Compensation Analysis HR Compliance Reporting Up-sell / Cross-sell Service Rep Effectiveness Loyalty and Attrition Backlog Analysis Inventory Availability P&L Analysis Workforce Profile Cycle Time Analysis Service Cost Analysis Market Basket Analysis Fulfillment Status Employee Expenses Expense Management Turnover Trends Lead Conversion Service Trends Campaign ROI Customer Receivables BOM Analysis Cash Flow Analysis Return on Human Capital Prebuilt adapters: Other Operational & Analytic Sources Oracle BI BI Suite Suite Enterprise Edition Plus
결론
EPM 시장에서의 Oracle의차별화전략 광범위한솔루션과아키텍쳐의제공 가장완전한성과관리 Application 제공 사전제작된 (Pre-packaged) BI Application을통한운영 BI 제공 가장포괄적인 Semantic Layer 임의의환경으로통합가능한 Hot Pluggable 제공 Oracle과 Non-Oracle 플랫폼과 Application으로의개방성제공 IT Infrastructure로의 Plug & Play 가가능한모듈화된시스템제공 Fusion Middleware의활용 대시보드이상의분석기능제공 가장강력한 OLAP Server의제공 단일한통합 MDM 기반기술제공 재무와예측모델링을사용하는데있어서의용이성제공