Hyperion 솔루션소개 이혁구 Hyperion Korea
목 차 I. Hyperion BPM II. Sarbanes/Oxley 및연결재무 III. BI Platform / KPI Dashboard IV. Hyperion 소개 2 of 50
전략경영관리통합솔루션 BPM Business Performance Management 3 of 50
CFO 가느끼는업무의중요도 Cost control, cost structure, cost reduction Sarbanes-Oxley implementation or compliance Capital structure ready for upturn Growth Strategy New rules & regulations Assuring a controlling environment 33% 25% 23% 21% 21% 19% 19% Gartner - CFO Survey 2003 4 of 50
CFO 역할의변화 Past Present Future Financial Control & Treasury Operations Partner Re-emphasis on Assurance Strategic Lead Strengthen the audit function More focus on compliance Improving analytics to support operations Continued emphasis on cost reduction Increased emphasis on strategy New emphasis on revenue enhancement 5 of 50
CFO 와전략경영관리 Consolidation & Reporting BSC Strategic Finance & Treasury The Compliance CFO The Strategic CFO Planning & Budgeting Planning & Budgeting CFO KPI Dashboard The Shareholders CFO The Prudent CFO Analysis & Simulation KPI Dashboard Strategic Finance & Treasury Consolidation & Reporting 6 of 50
전략경영관리는 Management Cycle Strategies Scorecarding Dashboards Consolidations Management Financial Legal Constraints Profitability Resources Revenues Variance Deviations Profitability Effectiveness Cash Budgets Demand Expenses Forecasts Resources Key Performance Indicators Benchmarking and Metrics Performance and Efficiency 7 of 50
기업전반에걸쳐사용되는경영관리도구 Executive Management STRATEGIC MANAGEMENT Goals/Strategies Financial & operational projections Weekly/monthly Operational Management OPERATIONAL MANAGEMENT Forecasts/variances Budgets Operating plans Resource allocations Daily/weekly Line Managers TACTICAL EXECUTION Targets Forecasts Activity management Hourly/daily 8 of 50
전략경영관리상세모델 9 of 50
IBM integrated management solution (ianalytics) 10 of 50
Value creating business Value destroying business 제조기업모델예시 Value Value Map analysis Shareholder Value Capital Invested 경영정보시스템 (EIS) 경영계획및 Rolling 재무 KPI BSC( 균형성과관리 ) 제출및승인관리 판매계획 재고계획 생산계획 비용계획 인원계획 구매계획 Simulation 물량변경 판가변경 구매가변경 비용변경 환율변경 배부 & 집계 추정 실적 대차대조표 Cash Flow 손익계산서 계획 vs. 실적 실적 / 성과분석 주요경영지표 (EVA,ROIC) 계획對실적분석 주요지표 Simulation 비전 전략 벤치마크 고객 프로세스 신제품학습 기준정보 통제경비 성과보상 PDM/PLM/BOM ERP SCM CRM HRM DW 11 of 50
Hyperion BPM 구성 12 of 50
Sarbanes / Oxley 및 연결재무 13 of 50
지난 20 년간기업회계규정의변화 14 of 50
Sarbanes / Oxley 법안이 CEO/CFO 에미치는영향 CEO 와 CFO 아래사항에대하여책임지고, 재무제표에서명하여야함 분기와반기보고서를철저히검토하였음 회계보고서상에허위사실이있거나중요한사실이누락되지아니함 인지하고있는모든회계정보가적절히표시되어있음 적절한내부보고및통제시스템에대한책임이있음 외부감사인및내부감사 ( 위원회 ) 에게내부통제상문제점및핵심인력에의한부정행위등를보고하였음 내부통제와관련된중요한변경내용을공시하였음. 단순히서명하는것은쉽지만많은책임과의무가따름 15 of 50
Sarbanes / Oxley 를지원하기위한시스템요구사항 Single version of the financial truth / book of record Accuracy and timeliness of close/reporting Workflow management Awareness of adjustments Tracking/visibility to audit trails Technology supporting the approval/certification process Internal control visibility at consolidation/reporting level Monitoring/visibility of overall close/reporting process 16 of 50
Best Practices in Finance Process Average World Class Closing cycle 5 8 days < 2 days Financial planning 4 months 1 month Level of budget detail % of time on forecasting 230 line items 15 line items 20% 44% Cost of finance 1.15% of rev. <.53% of rev. FTEs per $B 122 < 95 Source: Hackett Group Benchmarking Solutions Book of Numbers 17 of 50
S/O, Fast Closing 을충족하는연결시스템구현이미지 Application Layer Data Layer Package Layer Sarbanes /Oxley XBRL 18 of 50
연결과정의승인및통제과정지원 Monthly/ Quarterly Actual Results ERP/GL Monthly Forecast Annual Budget Local Regional Central Input/Load Submit Validate Input/Load Submit Validate Input/Load Submit Validate Approve Reject Approve Reject Approve Reject Process Review Approve Adjust Consolidate Submit Approve Reject Process Review Approve Adjust Consolidate Intercompany Currency Publish Reports SEC Tax Legal Treasury Management 19 of 50
새로운리포팅표준 : XBRL 20 of 50
Hyperion 솔루션의장점 Hyperion's Market Leadership Packaged Financial Intelligence Web Architected/Advanced Technology Smart Dimensionality Data Integration, Reporting, Analysis March 2002 Hyperion Financial Management Release 2.0 Receives Excellent Plus SPEXmark Rating See www.checkspex.com 21 of 50
전세계연결시장에서독보적위치고수 Financial consolidation, reporting and analysis market leader since 1981 70% Market share 3,500+ satisfied customers worldwide Budgeting 42% Financial Consolidation 33% Others 30% Hyperion 70% Perf Mgt 13% ABC 6% Other 5% Accounting Analytic Application Segments Source: IDC 22 of 50
BI Platform EIS Dashboard Portal 23 of 50
재무부문 ( BPM ) 을포함하는기업전반의인텔리전스제공 Profitability Analysis 30% Dashboards 5% General Reporting 5% HR Analysis 9% HR Headcount Reporting, Turnover/Retention Analysis, Labor Utilization Sales Pipeline/Forecasting, Territory/Rep Performance, Compensation Modeling Marketing Segmentation, Campaign Effectiveness, Customer Churn, Life Time Value Profitability Customer, Product, Service, Channel, etc Sales Analysis 20% Supply Chain Analysis 12% Marketing Analysis 19% Supply Chain Inventory Management, Supplier Analysis, Production Planning, Yield/Defect, Distribution/Routing General Reporting Data Warehouse, Transactional Systems Dashboards Spanning departments, geographies or business units 24 of 50
쉽고, 편리하고경제적인 BI 솔루션 정형화된리포팅 Ad Hoc 리포팅및분석 Metrics 리포팅 개인별 Dashboard 웹환경의 BI 빠르고, 쉽게구축및운영 Consistent Drag & Drop UI Secure, Scalable Architecture Common Web-based Foundation Flexible, Open Data Access 모든자원을활용가능한개방형구조 Data Warehouse Unstructured Data Application Data Mainframe Data 25 of 50
Σ ƒ 기업경영관리를완벽하게지원하기위한 BI Platform ETL: 데이터추출및 Mapping EAI : SAP,Oracle 등 ERP CRM, SCM, RDB 등 비용배부계산및통계분석환율환산시뮬레이션목표설정및할당 EIS KPI Dashboard Portal Excel 리포팅분석시뮬레이션모델링 σ Data and Information 26 of 50
기술적인특장점소개 O/S RDMS Security Metadata Programming Application Servers Messaging Middleware 업계표준지원 Windows, Unix, Linux, AS400, S390 Oracle, DB2, SQL Server, Teradata, Sybase LDAP, ADS, NTLM XML, CWM Java, JSP/ASP, C, Visual Basic, DreamWeaver Websphere, Weblogic, Tomcat JMS, MQ Series, MSMQ 쉽고유연한개발및운영환경 시스템최적화를통한최대확장성지원 Vast Data Volumes Extensive Dimensionality Fast Query Response Multi-User Write Back Small Update Windows Reduced Data Latency & Redundancy Sales 진정한 Thin 클라이언트구현 Daily Update Incremental Updates Custom Functions Custom Macros Third party extensions Win 32 Clients Active X Controls Hyperion Platform Procedural Calc Scripts Stored Procedures Database Triggers Proprietary RPCs Runtime Clients 27 of 50
BI Platform 구성도 Web Development JSP Java Bean JavaScript Java COM/ActiveX CORBA Scalable Repository Support for all Content and Metadata Interoperability - Sharable metadata across platform Oracle, DB/2, SQL Server MySQL Batteries Included Highly Scalable Parallel Analytic Server Fully multithreaded for load, calculation, multi user read/write Fully server side, zero session overhead MOLAP storage ensures speed of thought Transparent relational integration Open Metadata Repository XML Exchange for metadata definition ETL integration Warehouse Integration Oracle OCI ODBC, Wire Protocol PDF, HTML Hyperion Reports BPM Apps Inline JRE external calculations Oracle, DB/2 SQL Server, Teradata, Sybase, Informix Zero Client HTML Hyperion Application Builder TCP/ IP Hyperion Central Data Source Abstraction Layer (ADM) TCP/ IP Essbase Integration Services Applet or Zero Client HTML HTTP (S) Hyperion Analyzer TCPIP Open Java API PDF, DHTML, HTML, Word, XML Hyperion Objects ActiveX Essbase Deployment Services Open, Native API - C, VB, Java Essbase Analytic Services Hybrid, Drill Through, TCP/IP TCP/ IP Spreadsheet Services TCP/ IP Hyperion Application Link Lightweight Spreadsheet Client JDBC ODBC OLEDB Native Hyperion Intelligence Essbase Administration Services Content Aggregation and Personalization Scalable integrated desktop Built for the Web Fully J2EE, Servlet WebLogic WebSphere Tomcat HTTP firewall transparency Hyperion Intelligence Query & Reporting Enterprise visibility Ease of user Scalable Optimized for Multiple Platforms NT Solaris AIX HP-UX Linux Multiple Server Administration Administer via Web Scalable J2EE architecture Fully functional scripting language MaxL & Perl module Enterprise Security LDAP, NTLM, MSAD Plug in Security Modules API Role based security Enterprise Integration JMS, MQ Series, MSMQ Automation, COM, EJB Bi directional 28 of 50 SAP, JDE, Siebel, PSFT Over 60 adaptors
Hyperion BI 솔루션의장점 Capabilities Rapid web based deployment for dashboards, query and reporting Self service environment enables rapid publishing of interactive desktops to the web Broad access to relational, multidimensional, ERP/CRM sources Provides proactive information delivery to address all classes of user Benefits Enables rapid query and reporting against a wide range of sources Recognized ease of use Rich connectivity, content aggregation, easy web publishing Proven user scalability Extends reach to offline users Highest ratings for Ease of Use & Management 29 of 50
EIS - Sample sample 30 of 50
Dashboard - Sample 31 of 50
Portal - Sample 32 of 50
Hyperion 소개 33 of 50
Hyperion 소개 전략경영관리, 분석솔루션 ( BPM 및 BI) 국내약 80 대기업, 금융기관, 공기업, 통신회사고객 #1 in Business Performance Management Applications (Oct 2003) #1 in Budgeting & Planning 전세계약 9,000 고객 ( 포츈 500 기업중 50%) 매출규모 : 약 7 억불 #1 in OLAP /FCRA 전세계직원약 2,800 명 약 20 년이상축적된지식과다양한경험보유 34 of 50
경쟁사비교평가 35 of 50