《Hyperion Sytem 9 BI 使管理和分析更简单》由会员分享，可在线阅读，更多相关《Hyperion Sytem 9 BI 使管理和分析更简单（43页珍藏版）》请在金锄头文库上搜索。
1、Hyperion System 9 BI+ 使管理和分析更简单使管理和分析更简单邵小卫商务智能售前总监海波龙中国区什么是商务智能？什么是商务智能？什么是商务智能？什么是商务智能？在90年代中期，Gartner Group提出了BI概念商业智能 (BI)是一组应用和技术工具集，可以用来收集、存储、分析和提供数据访问来帮助企业用户作更好的业务决策。BI应用包括决策支持系统、查询和报表、在线分析处理、统计分析、预测和数据挖掘是一个全面的概念，包括了OLAP、查询工具、报表工具。 “最终用户的信息访问和分析工具”架构和实现都各自不相同商业智能关系型数据查询工具报表工具OLAP数据集市/仓库工具分析应用
2、数据挖掘战略价值战略价值BI BI 与与与与 BPMBPM？80s 90s今天今天BI 平台平台BI套件BPM 系统系统BI工具工具BIBI架构带来了很多机遇架构带来了很多机遇架构带来了很多机遇架构带来了很多机遇Data Designer/ModelerProject Manager Technical ArchitectsData Warehouse AdministratorBusiness Requirements Analyst Database Administrator Data Acquisition (ETL) DeveloperSource: Chart from Gartn
3、er ResearchTransactionalInfrastructureFunctionalityOrganizationBusinessCRMLegacyERPSCMPoint-in-timeReal-timeETTIntegration BrokersData warehouseODSBI platforms, EBIS, data mining IT-centric/user-drivenOrganization drivers:Performance management, focus shifting to front-officeInformation Culture (inc
4、lusion, exclusion)User types, BI methodology, Skills and Bi departmentKey trends: Globalization, Virtualization, TransparencyBI Applications:StrategicAnalyticalOperationalQuery and reporting:Standard, cannedAd hoc, user-drivenHyperionHyperion Hyperion BIBI机会？机会？机会？机会？数据模型设计项目管理技术架构数据仓库管理业务需求分析数据库管理数
5、据获取开发Source: Chart from Gartner Research交易交易架构架构功能功能组织组织业务业务CRMLegacyERPSCM调度调度实时实时ETT整合导向整合导向数据仓库数据仓库ODSBI平台、平台、EBIS、数据挖掘、数据挖掘、IT为为中心中心/用户驱动用户驱动组织驱动组织驱动:绩效管理绩效管理, 聚焦移向前端办公室聚焦移向前端办公室信息使用习惯信息使用习惯 (内部的，外部的内部的，外部的)用户类型用户类型, BI方法论方法论, 技巧和技巧和BI 部门部门关键趋势关键趋势: 全球化、虚拟化、透明全球化、虚拟化、透明度度BI 应用应用:战略战略分析分析操作操作查询和报
6、表查询和报表:标准、标准、Ad hoc、用户驱动、用户驱动Hyperion全新的全新的全新的全新的HyperionHyperion系统架构系统架构系统架构系统架构应用架构BI平台工具BI平台服务Copyright 2007, Hyperion. All rights reserved.Hyperion System 9Hyperion System 9提高效率减少业务风险降低 TCO整合财务管理应用和BI平台的 BPM SystemINFORMATIONMANAGEMENTINFORMATION DELIVERYINFORMATIONPRODUCTIONHyperion System 9: H
7、yperion System 9: 国际化企业的管理系统国际化企业的管理系统国际化企业的管理系统国际化企业的管理系统OPERATIONALFINANCIALSCORECARDQUERYHyperion System 9: Hyperion System 9: 改变业务解决方案的管理系统改变业务解决方案的管理系统改变业务解决方案的管理系统改变业务解决方案的管理系统建立于丰富的经验建立于丰富的经验建立于丰富的经验建立于丰富的经验新的产品新的产品 | 新用户界面新用户界面 | 统一的架构统一的架构集成各种用户充分认可的集成各种用户充分认可的BI产品产品Hyperion IntelligenceHyp
8、erion AnalyzerHyperion ReportsHyperion SQR集成集成 多种多种BPM 产品产品Hyperion Performance ScorecardsHyperion Metrics（KPI）Hyperion EssbaseHyperion Financial Management and Hyperion PlanningSystem 9整合了用户充分认可的各种整合了用户充分认可的各种Hyperion技术技术“Windows on the Web”“Windows on the Web”的用户感觉的用户感觉的用户感觉的用户感觉一致性 BI的所有模块所有用户的界面
9、在线和离线交互性拖拽下钻和穿透旋转过滤效率纯HTML方式快捷访问自助式报表和仪表板创建自助式报表和仪表板创建存在的查询和报表点击点击点点产生产生业务分析业务分析组件模板关系型关系型多维型多维型BPM系统系统对任意数据源的透明访问对任意数据源的透明访问Essbase 先进的分析先进的分析先进的分析先进的分析商业规则预测分摊货币转换What-if?分析分析大量数据即时分析数据挖掘NavigationSparse Data Set财务财务业务业务继续全面利用强大的Essbase平台财务智慧Delivering Broad Capabilities仪表板财务报表生产报表指标管理Office整合Ad H
10、oc查询和报表记分卡多维度分析各种不同报表的支持各种不同报表的支持交互式报表自助式报表经典的管理报表旋转、切片、钻取等交互式分析报表企业级/业务报表任意格式报表核心业务报表解决方案财务报表强大的财务报表能力访问Hyperion Panning，HFM，Essbase和SAP BWAd-hoc查询和分析查询和分析关系数据源的Ad-hoc查询真正自助式的Ad-hoc查询直接数据源的访问完全图形化界面易于使用多维分析强大的分析功能 优秀的展现能力高度整合高度整合Microsoft Office对Office 强力的输出保持格式，高质量 Office 报表Font, 彩色，空间，等等可把里面的程式ma
11、p到Excel的程式可把内容输出到Word, PowerPoint, 或 Excel支持”数据 only” 输出Hyperion Smart View所有的海波龙产品共同的 MS Office add-in可跟所有的海波龙产品连接从Excel, Word, PowerPoint, 或 Outlook 可以利用数据 | Image | Form跟数据来源动态的连接共同的Point Of View支持Office Smart Tag可扩展的可扩展的SOA架构架构 标准支持SOAP, XML & WSDLJ2EE & .NET 开发环境可扩展，高性能分布和复制组件Services optimized
12、 for task-at-hand 64位支持灵活的用户模型为用户提供高交互性的瘦客户端为开发者提供强大的开发端工作台- 动态HTML技术开发客户端 Smart ViewOffice Add-InBI+ Core ServicesProduction Reporting ServicesInteractive Reporting ServicesFinancial Reporting ServicesEnterprise Metrics ServicesAnalytic ServicesPerformance Scorecard ServicesFoundation - Shared Serv
13、icesWeb App Server (s)BI+ Workspace Web-AppFinancial Reporting Web-AppInteractive Reporting Web-AppEnterprise Metrics Web-AppWeb Analysis Web-AppAnalytic Services Web-AppPerf Scorecard Web-AppShared Services Web-AppMDM Services Web-AppFinancial Mgmt Services Web-AppPlanning Services Web-AppFinancial
14、 Mgmt ServicesPlanning ServicesMDM ServicesHTTP ServerHyperion System 9单一架构的单一架构的BPM系统系统客户端客户端服务器服务器数据库数据库外部数据源外部数据源一致的视觉一致的视觉基于浏览器基于浏览器x.508支持支持HTMLApplets可选可选Microsoft Office支持支持SOA J2EE架构 Web服务支持基于标准的创新基于标准的创新 XML for Analysis JOLAP Java Data Mining Interface XBRL跨平台跨平台 Windows/UNIX Tomcat/WLS/WA
15、S可扩展可扩展集群:高可用性负载均衡所有主流数据库的支持所有主流数据库的支持多维和关系型数据库支持多维和关系型数据库支持各种数据源各种数据源Hyperion System 9Hyperion System 9单一架构的单一架构的单一架构的单一架构的BPMBPM系统系统系统系统客户端客户端服务器服务器数据库数据库外部数据源外部数据源一致的视觉一致的视觉基于浏览器基于浏览器x.508支持支持HTMLApplets可选可选Microsoft Office支持支持SOA J2EE架构 Web服务支持基于标准的创新基于标准的创新 XML for Analysis JOLAP Java Data Mini
16、ng Interface XBRL跨平台跨平台 Windows/UNIX Tomcat/WLS/WAS可扩展可扩展集群:高可用性负载均衡所有主流数据库的支持所有主流数据库的支持多维和关系型数据库支持多维和关系型数据库支持各种数据源各种数据源SOA 通过分布式的、可复制的服务提高效率和吞吐量通过分布式的、可复制的服务提高效率和吞吐量可扩展可扩展 更低的更低的TCO，更大的硬件利用，更大的硬件利用符合标准符合标准JDBCODBCXMLACWMSAP 认证的报表和分析认证的报表和分析 SAP BW OLAP BAPI 认证直接通过BAPI访问到SAP BW对象Financial reporting,
17、 production reporting& ad-hoc analysis of SAP BW数据Z爱报表和仪表板中混合SAP BW和关系型数据和和Google家族的整合家族的整合Google OneBox 整合快速的HS9 BI+ 共享库内容搜索可以搜索查看仪表板快照从搜索结果创建新查询Essbase BSOEssbase ASOIntelligenceSQRMetrics BuilderReportsAnalyzerMaster Data ManagementApplication Link AdvancedHyperion Hub新老产品对应表Essbase AnalyticsEnte
18、rprise AnalyticsInteractive ReportingProduction ReportingEnterprise MetricsFinancial ReportingWeb AnalysisMaster Data ManagementApplication Link AdvancedFoundation (Shared Services)Hyperion System 9 BI+HS 9 Foundation ServicesPerformance ScorecardStrategic Finance PlanningWorkforce PlanningFinancial
19、 ManagementPerformance ScorecardStrategic Finance PlanningWorkforce PlanningFinancial ManagementHyperion System 9 Apps+让最终用户能够快速产生帐簿质量的财务和管理报表内嵌的财务功能能够更加容易嵌入报表预算和预测的报表的财务格式支持更容易根据企业架构来创建独立的批量报表丰富的输出支持,包括：HTML、PDF和在线查看支持Hyperion应用, Hyperion Essbase Analytics, Hyperion Enterprise Analytics和SAP BWHyper
20、ion System 9 BI+ Hyperion System 9 BI+ Financial ReportingFinancial Reporting为所有的用户提供直观的、强大的和图形化的在线分析高级的分析功能，例如：排序、排列、过滤和用户定义计算多用的展现方式，有表格、图形、动态图钉板和交通灯等支持Hyperion应用, Hyperion Essbase Analytics, Hyperion Enterprise Analytics和SAP BWHyperion System 9 BI+ Hyperion System 9 BI+ Web AnalysisWeb AnalysisHy
21、perion System 9 BI+ Hyperion System 9 BI+ Interactive ReportingInteractive Reporting 对关系型数据源进行Ad-hoc查询和分析丰富的数据展现图形和图片旋转透视表交通灯基于模板和向导创建仪表板为移动用户提供离线能力通过突出显示显示指标Hyperion System 9 BI+ Hyperion System 9 BI+ Production ReportingProduction Reporting产生、管理和发布基于Web的海量的和展现质量的报表精确的格式能力参数化的报表自动预警和数据处理任务触发流程和支持闭合
22、循环交易和Web站点无缝整合支持关系型数据库, 业务数据源, SAP R/3 and SAP BWHyperion System 9 BI+Hyperion System 9 BI+Enterprise MetricsEnterprise MetricsOrganized by subject areaEnables rapid problem identificationFrom summary metrics to root cause analysisImprove understanding of business-critical information across the ent
23、ire enterprise Personalize and extend to ensure that the information received is appropriateHyperion System 9 BI+Hyperion System 9 BI+Essbase AnalyticsEssbase Analytics“One of the ten most influential technologies of the last decade”, Information Age magazineSophisticated financial and business anal
24、ysisPatented Multi-Dimensional database storage technologyThe premier platform for building Budgeting, Planning, Forecasting and Predictive applications Essbase: The multi-dimensional database technology that put online analytical processing (OLAP) on the business intelligence map. it spurred the cr
25、eation of scores of rival OLAP products - and billions of OLAP cubes. Information Age magazineAugust 2005World-Class Finance for Global OrganizationsHyperion System 9 Hyperion System 9 Essbase AnalyticsEssbase AnalyticsModel your business by taking spreadsheets to the next levelCalculation engine fo
26、r deriving results and creating aggregations, consolidations and complex calculations.Tight integration with Excel and “speed of thought” performance allow for a “conversation with the data”Forecasting, trend analysis, and other complex modeling, such as optimization or statistical analysis are supp
27、ortedIntegration with transaction and warehouse systemsOpen, published APIs allow for custom application developmentHyperion System 9 Hyperion System 9 Enterprise AnalyticsEnterprise AnalyticsSparse data set aggregation technologyMassive scalability users, dimensionality, dataVisualization of large
28、data setsOperational Analytics - Sales, Marketing, Manufacturing, Logistics, HRInspired by Essbase, with a common development environment“aggregate storage and sparse matrix data handling capabilities allow enterprise users to analyze across a much broader set of corporate data.”Madan Sheina, Comput
29、erwireWorld-Class Finance for Global OrganizationsHyperion System 9 Hyperion System 9 Enterprise AnalyticsEnterprise AnalyticsHighly granular data Enormous dimensionality: millions of members within a dimensionManages tight batch windows, minimal load and calc timesAllows navigation of large data se
30、ts Delivers “Speed of thought” performance to business usersIntegrates with transaction and data warehouse systemsWhat is Hyperion DMS?A data infrastructure layerA family of productsComprised of products that are sold independentlyNot an SKUHyperion System 9 Data Management Hyperion System 9 Data Ma
31、nagement ServicesServicesWhat does Hyperion DMSdo?It provides customers with a proven set of products for managing data, financial data quality, and master data associated with their BPM deploymentsThe ExtremesCustomer will prepare data and metadata to match Hyperion targetTechnically no need for Hy
32、perion DMS productsBPMA provides single point of entryCustomer wants a solution for preparing data and metadata to match Hyperion targetImplies direct connectivity to ERP/CRMSell DIM for data and metadata movement? ?SIMPLE CASECOMPLEX CASEFDM fits for financial data qualityMDM fits for master data c
33、hange managementMost Common IT Change Management Solutions变动管理缺乏过程控制变动管理缺乏过程控制In the HallOn the PhoneIn the MailPre-MDM Customer Scenario1.Accounts2.Entity3.Channel4.Product5.Project6.Location DWIT AdminE-MailOracleAdminReviewSpreadsheetPlanningAdminEssbaseAdminSpreadsheetDifferent people involvedIn
34、evitable manual processError-proneNo auditabilityNo effective way to rollback changesTime and resource consumingBusinessUserDWPost-MDM Customer Scenario Hyperion MDM solves the problemImplies establishing or improving current processBusinessUsers集中的变动管理集中的变动管理集中的变动管理集中的变动管理LegacyGLSAPCustomApplicati
35、onsOracleFinancialsPeoplesoftStagingODSDMETLEAIQuery & ReportingHyperion EssbaseHyperion PlanningHFMOther Reporting ToolsHyperionMDM ServerBusiness ProcessDMDWiSetupTree MoverBAPI / RFCsCustom / ETLFlat FileWhat is Hyperion Data Integration Management?A proven data integration platformBuilt for Hype
36、rion System 9Leverages Informatica PowerCenter technologyHyperion SystemHyperion System 9 Data Integration 9 Data Integration ManagementManagementWhat does Hyperion Data Integration Management do?Access, integrate, transform, and move data and metadataBetween Hyperion System 9 and virtually any syst
37、em, at any frequency, and any volume新新新新System 9 System 9 数据整合平台数据整合平台数据整合平台数据整合平台Robust ETLPowered by InformaticaBPM AdaptersCertified ERP / CRM Adapters财务数据质量管理财务数据质量管理财务数据质量管理财务数据质量管理A packaged solution for finance users that includes:Guided web-based workflow user interface for developing standa
38、rdized financial data management processesData preparation server for collecting, mapping, verifying and moving financial data from any source system BPM Adapters for Hyperion System 9 Financial Management, Planning, Essbase Analytics and HSF to reduce the data integration costs and data mapping com
39、plexities. Financial Data QualityAudit TrailsIntegrate SOX questionnairesStore current and historical mapping definitionsStore supporting documentsData Collectionand Transformation Read and interpret any G/L trial balance file Mapping validation against target system dimensions Data integrity checki
40、ng against data validation rulesInternal Controls Source financial document archival Prepackaged audit and internal control reports Comprehensive role based securityRepeatableProcesses Single standard and defined solution for any target application Standardized database schema Standard upward data certification process传递数据和程序的透明度传递数据和程序的透明度传递数据和程序的透明度传递数据和程序的透明度
