Hyperion_BI介绍

Click to edit Master title style,Click to edit Master text styles,Second level,Third level,Fourth level,Fifth level,Copyright 2005,Hyperion.All rights reserved.,P.,*,什么是,ESSBASE,多维的,OLAP,数据平台,;,对数据从导入、存储、计算、汇总、分析、报表进行全方位处理,预算,实际,销售,成本,毛利,比率,1,月,2,月,3,月,1,季度,Budget,Actual,Sales,COGS,Gross Margin,Ratios,Jan,Feb,Mar,Qtr1,切片,切块,Budget,Actual,Sales,COGS,Gross Margin,Ratios,Jan,Feb,Mar,Qtr1,单元格,Budget,Actual,Sales,COGS,Gross Margin,Ratios,Jan,Feb,Mar,Qtr1,1,Copyright 2005,Hyperion.All rights reserved.,Capabilities,聚合,Attributes&,统计,财务智能化&币种,转,转换,预测&,时,时间序列智,能,能化,数据挖掘、,回,回归预报分,析,析,多用户回写,Procedural,Set,Relationship&BooleanLogic,Stored Procedures,Triggers,&Custom Functions/Macros,100%,并行架构可,大,大规模扩展,Essbase Analytic Services,Benefits,改善需求绩,效,效,划分市场，,识,识别销售机,会,会,增加线索形,成,成，精确预,见,见需求,改善供应绩,效,效,使供应、制,造,造、和物流,与,与,变化的市场,需,需求协调统,一,一,，以降低成,本,本，投资于,收,收入项目机,会,会,改善财务绩,效,效,建立收益模,型,型，完善计,划,划，分摊资,源,源，使,业务运营与,战,战略目标协,调,调统一,2,Copyright,2005,Hyperion.All rights reserved.,Statistical Analysis(Correlation,Trend,Analysis),统计分析,(,关联性，趋,势,势，分析,),Variance Reporting(Actual,Budget,Variance),差异报表,(,实际，预算,，,，差异,),InventoryTracking(Opening&Ending Balance),库存追踪,(,开始，结束,平,平衡,),Attributes(Style,Color,Size etc),Slicing,Dicing&Pivoting Analysis,切片，切块,，,，交叉分析,Multi-CurrencySupport(US,HK,SIG,),Reportingusinglocal currency,Tracking and Updating currencycubeusing Excel,What-If analysis,Multi-userread/write environment(Write-BackTechnology),Complex Allocation,Business Analysis,3,Copyright,2005,Hyperion.All rights reserved.,AllocationExample,FIX(TotalExpenses),Budget=ALLOCATE(Budget-Total Expenses,CHILDREN(Total Expenses),PY Actual“,share);,ENDFIX,4,Copyright 2005,Hyperion.All rights reserved.,The Only Analytic Engine For The Entire Business,Business rules,Forecasting,Planning,Currency,What-if?,FINANCIAL,Massive data volumes,Real time,Mining,Navigation,Sparsedimensions,OPERATIONAL,New,New,New,5,Copyright 2005,Hyperion.All rights reserved.,满足全方位的分,析,析应用,战略的,操作的,战术的,市场销售,人力资源,物流供应,信息技术,财务审计,执行管理,商业活动,效力,呼叫中心,分析,投资回报率,分析,管道,分析,库存,周转,分析,需求,分析,供应商,绩效,分析,准时,投递,分析,薪资,分析,单人,成本,分析,雇佣成本,分析,IT,成本,分析,网络,容量,分析,结案,比率,利润分析,预测,风险承受,分析,损益报表,产品,收益率,定价,监管,路线分析,人力资本,管理,风险管理,开支,管理,预算,预测,分析,SLA,监控,6,Copyright 2005,Hyperion.All rights reserved.,Shared Business Data&Processes,Financial Management&Control,Enterprise Planning,Query&Reporting,Enterprise Analytics,With anEnterprise BPM System,Destination/End-Users,Hyperion BPM System,Data Sources,Data Warehouse,Legacy,Siebel,SAP,Oracle,OPERATIONAL REPORTING,INTERACTIVE DASHBOARD,FINANCIAL REPORTING,7,Copyright 2005,Hyperion.All rights reserved.,多平台优化,NT,SolarisAIX,HP-UX,Linux,为,Web,准备,:,Fully J2EE,Servlet,WebLogic,WebSphere,Tomcat,HTTP,防火墙透明,共享库的可扩展,性,性：,数据和元数据,交互性,跨平台元数据共,享,享,Oracle,DB/2,SQL Server,MySQL,开放的元数据管,理,理库：,基于,XML,的元数据交换,使得和,ETL,进行了整合,数据仓库整合,OracleOCI,ODBC,Wire Protocol,企业整合,JMS,MQSeries,MSMQ,Automation,COM,EJB,Bi directional,SAP,JDE,Siebel,PSFT,Over 60adaptors,企业安全性：,LDAP,NTLM,MSAD,基于安全模块,API,的插件,基于焦色的安全,控,控制,Web,开发：,JSP,Java Bean,JavaScript,Java,COM/ActiveX,CORBA,EssbaseXTD Q&R,宽带报表服务,分布和集群、分,页,页,容错能力,多服务器管理,基于,Web,的管理,可扩展的,J2EE,架构,完整功能的脚本,语,语言,MaxL,和,Perl,语言模块,Oracle,DB/2 SQL Server,Teradata,Sybase,Informix,高扩展性的并行,分,分析服务器：,完全的多线程，,包,包括数据加载、,计,计算、多用户读,写,写,完全的服务器管,理,理，零客户端维,护,护,MOLAP,方式的存储，高,速,速度的展现,透明的关系数据,库,库整合,内容聚合和个性,化,化,可扩展的整合桌,面,面,TCPIP,Hyperion PerformanceSuite,Hyperion,Application Link,数据源读取层,(ADM),开放式,Java API,Essbase XTD Deployment Services,Essbase XTD,Integration Services,JDBC,ODBC,OLEDB,Native,Essbase XTD Analytic Services,Open,Native API-C,VB,Java,Inline JRE external calculations,BPM Apps,Hyperion Analyzer,Hyperion Intelligence&SQR,Spread-sheetServices,Hyperion ApplicationBuilder,Hyperion Reports,TCP/IP,TCP/IP,EssbaseXTD Administration Services,TCP/IP,TCP/IP,EssbaseObjects,ActiveX,Hybrid,DrillThrough,TCP/IP,PDF,HTML,Zero Client,HTML,Appletor,Zero Client,HTML,PDF,DHTML,HTML,Word,XML,LightweightSpreadsheet,Client,HTTP(S),Hyperion Essbase XTD,整体架构,8,Copyright 2005,Hyperion.All rights reserved.,Data StorageOptions For Every Business Need,Aggregate Storage,BlockStorage,Analytic Engine,APIs,End User andAdministration Interfaces,HybridAnalysis,Procurement,&Logistics,Analysis,Customer,&Marketing,Analysis,Forecasting,&Profitability,Analysis,Budgeting,&Financial,Consolidations,Transactional,Detail,9,Copyright 2005,Hyperion.All rights reserved.,Superior Performance With Large DataSets,Data Load,:8 minutesfor Billion RDBMS rows,Calculation,:35 minutesfor 12 dimensioncube,Levelof Detail,:Analysis across14 Million customer accounts,Disk Footprint,:1TBRDBMSreduced to 1.4GB EssbaseCube,QueryResponse,:,300X,fasterthanROLAPsolution,0.2 Second Response,Account Level Analysis,1,000 Concurrent Queries,10,Copyright 2005,Hyperion.All rights reserved.,RecordSetting User Scalability,APB-1 OLAP Benchmark Metric,Hyperion Results,Concurrent Users,10,000,Total Number of Queries,25,000,000,Average Response Time,2.4 seconds,Analytical Queries Per Minute(AQM),247,524,Price/Performance,18X,better than Oracle,“,Hyperion Essbase delivers,ma