ESSBASE OLAP Budget Actual Sales COGS Gross Margin

什么是ESSBASE 多维的OLAP数据平台; 对数据从导入、存储、计算、汇总、分析、报表进行全方位处理切片 Budget Actual 预算 Sales COGS 实际 Gross Margin Ratios 销售 Ja n F e b M ar 成本毛利比率 1月 2月 3月 Copyright © 2005, Hyperion. All rights reserved. 1季度 Budget Actual Sales COGS Gross Margin Ratios Budget Actual Q Sales tr COGS 1 Gross Margin Ratios 单元格 J a n F e b M Q a tr r 1 J a n 切块 F e b M a r 1 Q tr 1

Business Analysis < Statistical Analysis (Correlation, Trend, Analysis) < Variance Reporting (Actual, Budget, Variance) < Inventory Tracking (Opening & Ending Balance) < Attributes ( Style, Color, Size etc) < Slicing, Dicing & Pivoting Analysis < Multi-Currency Support (US, HK, SIG……) < Reporting using local currency < Tracking and Updating currency cube using Excel < What-If analysis < Multi-user read / write environment (Write-Back Technology) < Complex Allocation Copyright © 2005, Hyperion. All rights reserved. 3

Allocation Example FIX("Total Expenses") Budget = @ALLOCATE(Budget->"Total Expenses", @CHILDREN("Total Expenses"), "PY Actual“ , ,

The Only Analytic Engine For The Entire Business • What-if? • Business rules • Forecasting • Massive data volumes • Real time New • Mining • Planning • Navigation • Currency FINANCIAL Copyright © 2005, Hyperion. All rights reserved. • Sparse dimensions New OPERATIONAL 5

With an Enterprise BPM System Siebel Enterprise Planning Oracle Financial Management & Control Shared Business Data & Processes Enterprise Analytics SAP Destination/End-Users OPERATIONAL REPORTING Hyperion BPM System Query & Reporting INTERACTIVE DASHBOARD Data Warehouse FINANCIAL REPORTING Data Sources Legacy Copyright © 2005, Hyperion. All rights reserved. 7

Hyperion Essbase XTD整体架构 Zero Client HTML PDF, HTML Applet or Zero Client HTML PDF, DHTML, Word, XML Lightweight Spreadsheet Client HTTP (S) Hyperion Application Builder Hyperion Reports Hyperion Analyzer Hyperion Intelligen ce & SQR Spreadsheet Services Open, Native API - C, VB, Java Inline JRE – external calculations Essbase XTD Analytic Services Hybrid, Drill Through, TCP/IP Essbase XTD Integration Services Oracle, DB/2 SQL Server, Teradata, Sybase, Informix Copyright © 2005, Hyperion. All rights reserved. Hyperion Application Link JDBC OLEDB Native Essbase XTD Administration Services Essbase XTD Deployment Services TCP/ IP BPM Apps 开放的元数据管理库： • 基于XML的元数据交换 • 使得和ETL进行了整合数据仓库整合 • Oracle OCI • ODBC, Wire Protocol Active. X 为Web准备: • Fully J 2 EE, Servlet • Web. Logic • Web. Sphere • Tomcat • HTTP – 防火墙透明 Essbase XTD Q&R 宽带报表服务 • 分布和集群、分页 • 容错能力开放式Java API TCPIP TCP/ IP 高扩展性的并行分析服务器： • 完全的多线程，包括数据加载、计算、多用户读写 • 完全的服务器管理，零客户端维护 • MOLAP方式的存储，高速度的展现 • 透明的关系数据库整合 Essbase Objects 数据源读取层 (ADM) TCP/ IP 共享库的可扩展性： • 数据和元数据 • 交互性 – 跨平台元数据共享 • Oracle, DB/2, • SQL Server • My. SQL 内容聚合和个性化 • 可扩展的整合桌面 Hyperion Performance Suite TCP/ IP Web开发： • JSP • Java Bean • Java. Script • Java • COM/Active. X • CORBA 多平台优化 • NT • Solaris AIX • HP-UX • Linux 多服务器管理 • 基于Web的管理 • 可扩展的J 2 EE架构 • 完整功能的脚本语言Max. L和Perl 语言模块企业安全性： • LDAP, NTLM, MSAD • 基于安全模块API的插件 • 基于焦色的安全控制企业整合 • JMS, MQ Series, MSMQ • Automation, COM, EJB • Bi directional • SAP, JDE, Siebel, PSFT • Over 60 adaptors 8

Data Storage Options For Every Business Need End User and Administration Interfaces APIs Analytic Engine Aggregate Storage Procurement, & Logistics Analysis Customer, & Marketing Analysis Copyright © 2005, Hyperion. All rights reserved. Hybrid Analysis Transactional Detail Block Storage Forecasting, & Profitability Analysis Budgeting, & Financial Consolidations 9

Superior Performance With Large Data Sets £ Data Load: 8 minutes for ¾ Billion RDBMS rows £ Calculation: 35 minutes for 12 dimension cube £ Level of Detail: Analysis across 14 Million customer accounts £ Disk Footprint: 1 TB RDBMS reduced to 1. 4 GB Essbase Cube £ Query Response: 300 X faster than ROLAP solution Account Level Analysis 1, 000 Concurrent Queries Copyright © 2005, Hyperion. All rights reserved. 0. 2 Second Response 10

Record Setting User Scalability APB-1 OLAP Benchmark Metric Hyperion Results Concurrent Users 10, 000 Total Number of Queries 25, 000 Average Response Time 2. 4 seconds Analytical Queries Per Minute (AQM) 247, 524 Price/Performance Copyright © 2005, Hyperion. All rights reserved. 18 X better than Oracle “Hyperion Essbase delivers massive and perhaps unrivalled scalability – its industry standard APB-1 OLAP Benchmark results are outstanding when compared to the results of its rivals. ” Andrew Kellet, The Butler Group 11

Essbase XTD Administration Services Copyright © 2005, Hyperion. All rights reserved. 12

Hyperion Essbase的技术——与 ERP/CRM的集成 Copyright © 2005, Hyperion. All rights reserved. 13

Hyperion Essbase的技术——图形化的数据整合 Copyright © 2005, Hyperion. All rights reserved. 14

Essbase Spreadsheet Add-in Copyright © 2005, Hyperion. All rights reserved. 15

Financial Reporting £ £ £ Copyright © 2005, Hyperion. All rights reserved. 生产品质, 高度格式化，管理报表为Hyperion Essbase, Hyperion Planning, Hyperion Financial Management, SAP BW (Joyce) 报表而设计拖放式报表制作，可重用组件通过打印, HTML, PDF发布用标准Web browsers (zeroclient) 发布信息，不需要二次维护 18

DEMO

Hyperion Performance Suite 架构 Client Browser/Windows Designer / Explorer Intelligence Client Intelligence i. Server (Client Server) (Plug-In) (HTML Client) Windows / UNIX / Linux HTTP Server SQR Developer (Client Server) Foundation Web Server | Application Server (HTML & Servlets) Intelligence Service SQR Engine Data Access Service API (ODBC, Essbase, Oracle, etc. ) Data Sources Foundation Services Session Manager Log Service Authorization Usage Tracking Authentication Service Manager Event & Job Service Repository Service Windows / UNIX / Linux ODBC Data Multi. Enterprise Sources Relational Dimensional DW / DM Sources Copyright © 2005, Hyperion. All rights reserved. JDBC Repository 21

Hyperion Performance Suite Functional Architecture Client Design View Interact Analyze Administer Server Query Results Publish & Subscribe 508 Compliant Pivot Browse Pixel Perfect Data Sources Repository Copyright © 2005, Hyperion. All rights reserved. Chart Scheduling Secure Bursting Report Dashboard Personal Pages High Volume OLAP Query Administration 3 rd Party Content ODBC Data Multi. Enterprise Sources Relational Dimensional DW / DM Sources 22

集成信息，全面查看绩效 Copyright © 2005, Hyperion. All rights reserved. 24

报表生成－14万页，50页每秒 Copyright © 2005, Hyperion. All rights reserved. 29

Copyright © 2005, Hyperion. All rights reserved. 30

Copyright © 2005, Hyperion. All rights reserved. 31

Copyright © 2005, Hyperion. All rights reserved. 32

Copyright © 2005, Hyperion. All rights reserved. 33

即席查询拖放式查询，通过 Client/Server连接或者在Web上查询 Copyright © 2005, Hyperion. All rights reserved. £ 自动联接

Hyperion Intelligence——交互式报表 Copyright © 2005, Hyperion. All rights reserved. 39

仪表盘 Copyright © 2005, Hyperion. All rights reserved. 40

Godfrey’s Dashboard Worldwide Sales Dashboard Sales Forecast Variance Sales Forecast vs. Opportunities Sales Competitor & Sales Partner Copyright © 2005, Hyperion. All rights reserved. Sales Q +/- 1 Opportunities & Product Gross License Daily Rev Trend & Product Trend Top Sales Opportunities & Top Cust. Direct/Indirect 41

One System for All Modes of BI Production Reporting Financial Reporting Interactive Reporting Dashboards Metrics Management Advanced Analytics Data Mining & Visualization Copyright © 2005, Hyperion. All rights reserved. 42