Hyperion_BI介绍

Copyright©2005,Hyperion.Allrightsreserved.P.1什么是ESSBASE多维的OLAP数据平台;对数据从导入、存储、计算、汇总、分析、报表进行全方位处理预算实际销售成本毛利比率1月2月3月1季度BudgetActualSalesCOGSGrossMarginRatiosJanFebMarQtr1切片切块BudgetActualSalesCOGSGrossMarginRatiosJanFebMarQtr1单元格BudgetActualSalesCOGSGrossMarginRatiosJanFebMarQtr1Copyright©2005,Hyperion.Allrightsreserved.P.2Capabilities聚合Attributes&统计财务智能化&币种转换预测&时间序列智能化数据挖掘、回归预报分析多用户回写Procedural,Set,Relationship&BooleanLogicStoredProcedures,Triggers,&CustomFunctions/Macros100%并行架构可大规模扩展EssbaseAnalyticServicesBenefits改善需求绩效–划分市场，识别销售机会,增加线索形成，精确预见需求改善供应绩效–使供应、制造、和物流与变化的市场需求协调统一，以降低成本，投资于收入项目机会改善财务绩效–建立收益模型，完善计划，分摊资源，使业务运营与战略目标协调统一Copyright©2005,Hyperion.Allrightsreserved.P.3StatisticalAnalysis(Correlation,Trend,Analysis)统计分析(关联性，趋势，分析)VarianceReporting(Actual,Budget,Variance)差异报表(实际，预算，差异)InventoryTracking(Opening&EndingBalance)库存追踪(开始，结束平衡)Attributes(Style,Color,Sizeetc)Slicing,Dicing&PivotingAnalysis切片，切块，交叉分析Multi-CurrencySupport(US,HK,SIG……)ReportingusinglocalcurrencyTrackingandUpdatingcurrencycubeusingExcelWhat-IfanalysisMulti-userread/writeenvironment(Write-BackTechnology)ComplexAllocationBusinessAnalysisCopyright©2005,Hyperion.Allrightsreserved.P.4AllocationExampleFIX(TotalExpenses)Budget=@ALLOCATE(Budget-TotalExpenses,@CHILDREN(TotalExpenses),PYActual“,,share);ENDFIXCopyright©2005,Hyperion.Allrightsreserved.P.5TheOnlyAnalyticEngineForTheEntireBusiness•Businessrules•Forecasting•Planning•Currency•What-if?FINANCIAL•Massivedatavolumes•Realtime•Mining•Navigation•SparsedimensionsOPERATIONALNewNewNewCopyright©2005,Hyperion.Allrightsreserved.P.6满足全方位的分析应用战略的操作的市场销售人力资源物流供应信息技术财务审计执行管理商业活动效力呼叫中心分析投资回报率分析管道分析库存周转分析需求分析供应商绩效分析准时投递分析薪资分析单人成本分析雇佣成本分析IT成本分析网络容量分析结案比率利润分析预测风险承受分析损益报表产品收益率定价监管路线分析人力资本管理风险管理开支管理预算预测分析SLA监控Copyright©2005,Hyperion.Allrightsreserved.P.7SharedBusinessData&ProcessesFinancialManagement&ControlEnterprisePlanningQuery&ReportingEnterpriseAnalyticsWithanEnterpriseBPMSystemDestination/End-UsersHyperionBPMSystemDataSourcesDataWarehouseLegacySiebelSAPOracleOPERATIONALREPORTINGINTERACTIVEDASHBOARDFINANCIALREPORTINGCopyright©2005,Hyperion.Allrightsreserved.P.8多平台优化•NT•SolarisAIX•HP-UX•Linux为Web准备:•FullyJ2EE,Servlet•WebLogic•WebSphere•Tomcat•HTTP–防火墙透明共享库的可扩展性：•数据和元数据•交互性–跨平台元数据共享•Oracle,DB/2,•SQLServer•MySQL开放的元数据管理库：•基于XML的元数据交换•使得和ETL进行了整合数据仓库整合•OracleOCI•ODBC,WireProtocol企业整合•JMS,MQSeries,MSMQ•Automation,COM,EJB•Bidirectional•SAP,JDE,Siebel,PSFT•Over60adaptors企业安全性：•LDAP,NTLM,MSAD•基于安全模块API的插件•基于焦色的安全控制Web开发：•JSP•JavaBean•JavaScript•Java•COM/ActiveX•CORBAEssbaseXTDQ&R宽带报表服务•分布和集群、分页•容错能力多服务器管理•基于Web的管理•可扩展的J2EE架构•完整功能的脚本语言MaxL和Perl语言模块Oracle,DB/2SQLServer,Teradata,Sybase,Informix高扩展性的并行分析服务器：•完全的多线程，包括数据加载、计算、多用户读写•完全的服务器管理，零客户端维护•MOLAP方式的存储，高速度的展现•透明的关系数据库整合内容聚合和个性化•可扩展的整合桌面TCPIPHyperionPerformanceSuiteHyperionApplicationLink数据源读取层(ADM)开放式JavaAPIEssbaseXTDDeploymentServicesEssbaseXTDIntegrationServicesJDBCODBCOLEDBNativeEssbaseXTDAnalyticServicesOpen,NativeAPI-C,VB,JavaInlineJRE–externalcalculationsBPMAppsHyperionAnalyzerHyperionIntelligence&SQRSpread-sheetServicesHyperionApplicationBuilderHyperionReportsTCP/IPTCP/IPEssbaseXTDAdministrationServicesTCP/IPTCP/IPEssbaseObjectsActiveXHybrid,DrillThrough,TCP/IPPDF,HTMLZeroClientHTMLAppletorZeroClientHTMLPDF,DHTML,HTML,Word,XMLLightweightSpreadsheetClientHTTP(S)HyperionEssbaseXTD整体架构Copyright©2005,Hyperion.Allrightsreserved.P.9DataStorageOptionsForEveryBusinessNeedAggregateStorageBlockStorageAnalyticEngineAPIsEndUserandAdministrationInterfacesHybridAnalysisProcurement,&LogisticsAnalysisCustomer,&MarketingAnalysisForecasting,&ProfitabilityAnalysisBudgeting,&FinancialConsolidationsTransactionalDetailCopyright©2005,Hyperion.Allrightsreserved.P.10SuperiorPerformanceWithLargeDataSetsDataLoad:8minutesfor¾BillionRDBMSrowsCalculation:35minutesfor12dimensioncubeLevelofDetail:Analysisacross14MillioncustomeraccountsDiskFootprint:1TBRDBMSreducedto1.4GBEssbaseCubeQueryResponse:300XfasterthanROLAPsolution0.2SecondResponseAccountLevelAnalysis1,000ConcurrentQueriesCopyright©2005,Hyperion.Allrightsreserved.P.11RecordSettingUserScalabilityAPB-1OLAPBenchmarkMetricHyperionResultsConcurrentUsers10,000TotalNumberofQueries25,000,000AverageResponseTime2.4secondsAnalyticalQueriesPerMinute(AQM)247,524Price/Performance18XbetterthanOracle“HyperionEssbasedeliversmassiveandperhapsunrivalledscalability–itsindustrystandardAPB-1OLAPBenchmarkresultsareoutstandingwhencomparedtotheresultsofitsrivals.”AndrewKellet,TheButlerGroupCopyright©2005,Hyperion.Allrightsreserved.P.12EssbaseXTDAdministrationServicesCopyright©2005,Hyperion.Allrightsreserved.P.13HyperionEssbase的技术——与ERP/CRM的集成Copyright©2005,Hyperion.Allrightsreserved.P.14HyperionEssbase的技术——图形化的数据整合Copyright©2005,Hyperion.Allrightsreserved.P.15EssbaseSpreadsheetAdd-inCopyright©2005,Hyperion.Allrightsreserved.P.16在线，互动分析—直观、互动的在线分析，丰富的分析功能—适用于各种分析强度的多数用户—丰富的内置部署选项—完美应用于各种应用WebAnalysisCopyright©2005,Hyperion.Allrightsreserved.P.17高度图形化展示广泛多样的展示方式复杂报告布局异常颜色区分条件格式化交互式信息面板不对称电子表格版面简化报表制作点击分析无需编程Copy