Hyperion Sytem 9 BI 使管理和分析更简单

1、hyperion system 9 bi+ 使管理和分析更简单使管理和分析更简单邵小卫商务智能售前总监海波龙中国区什么是商务智能？什么是商务智能？在90年代中期，gartner group提出了bi概念商业智能 (bi)是一组应用和技术工具集，可以用来收集、存储、分析和提供数据访问来帮助企业用户作更好的业务决策。bi应用包括决策支持系统、查询和报表、在线分析处理、统计分析、预测和数据挖掘是一个全面的概念，包括了olap、查询工具、报表工具。 “最终用户的信息访问和分析工具”架构和实现都各自不相同商业智能关系型数据查询工具报表工具olap数据集市/仓库工具分析应用数据挖掘战略价值战略价值bi 8

2、0s 90s今天今天bi 平台平台bi套件bpm 系统系统bi工具工具bi架构带来了很多机遇架构带来了很多机遇data designer/modelerproject manager technical architectsdata warehouse administratorbusiness requirements analyst database administrator data acquisition (etl) developersource: chart from gartner researchtransactionalinfrastructurefunctionality

3、organizationbusinesscrmlegacyerpscmpoint-in-timereal-timeettintegration brokersdata warehouseodsbi platforms, ebis, data mining it-centric/user-drivenorganization drivers:performance management, focus shifting to front-officeinformation culture (inclusion, exclusion)user types, bi methodology, skill

4、s and bi departmentkey trends: globalization, virtualization, transparencybi applications:strategicanalyticaloperationalquery and reporting:standard, cannedad hoc, user-drivenhyperionhyperion 数据模型设计项目管理技术架构数据仓库管理业务需求分析数据库管理数据获取开发source: chart from gartner research交易交易架构架构功能功能组织组织业务业务crmlegacyerpscm调

5、度调度实时实时ett整合导向整合导向数据仓库数据仓库odsbi平台、平台、ebis、数据挖掘、数据挖掘、it为为中心中心/用户驱动用户驱动组织驱动组织驱动:绩效管理绩效管理, 聚焦移向前端办公室聚焦移向前端办公室信息使用习惯信息使用习惯 (内部的，外部的内部的，外部的)用户类型用户类型, bi方法论方法论, 技巧和技巧和bi 部门部门关键趋势关键趋势: 全球化、虚拟化、透明全球化、虚拟化、透明度度bi 应用应用:战略战略分析分析操作操作查询和报表查询和报表:标准、标准、ad hoc、用户驱动、用户驱动hyperion全新的全新的hyperion系统架构系统架构应用架构bi平台工具bi平台服务c

6、opyright 2007, hyperion. all rights reserved.hyperion system 9 提高效率 减少业务风险 降低 tco整合财务管理应用和bi平台的 bpm systeminformationmanagementinformation deliveryinformationproductionhyperion system 9: 国际化企业的管理系统国际化企业的管理系统operationalfinancialscorecardqueryhyperion system 9: 建立于丰富的经验建立于丰富的经验新的产品新的产品 | 新用户界面新用户界面 |

7、统一的架构统一的架构集成各种用户充分认可的集成各种用户充分认可的bi产品产品 hyperion intelligence hyperion analyzer hyperion reports hyperion sqr集成集成 多种多种bpm 产品产品 hyperion performance scorecards hyperion metrics（kpi） hyperion essbase hyperion financial management and hyperion planningsystem 9整合了用户充分认可的各种整合了用户充分认可的各种hyperion技术技术“windows

8、 on the web”的用户感觉的用户感觉一致性 bi的所有模块所有用户的界面在线和离线交互性拖拽下钻和穿透旋转过滤效率纯html方式快捷访问自助式报表和仪表板创建自助式报表和仪表板创建存在的查询和报表点击点击点点产生产生业务分析业务分析组件模板关系型关系型多维型多维型bpm系统系统对任意数据源的透明访问对任意数据源的透明访问essbase 先进的分析先进的分析 商业规则 预测 分摊 货币转换 what-if?分析 分析大量数据 即时分析 数据挖掘 navigation sparse data set财务财务业务业务 继续全面利用强大的essbase平台 财务智慧delivering bro

9、ad capabilities仪表板财务报表生产报表指标管理office整合ad hoc查询和报表记分卡多维度分析各种不同报表的支持各种不同报表的支持交互式报表自助式报表经典的管理报表旋转、切片、钻取等交互式分析报表企业级/业务报表任意格式报表核心业务报表解决方案财务报表强大的财务报表能力访问hyperion panning，hfm，essbase和sap bwad-hoc查询和分析查询和分析关系数据源的ad-hoc查询真正自助式的ad-hoc查询直接数据源的访问完全图形化界面易于使用多维分析强大的分析功能 优秀的展现能力高度整合高度整合对office 强力的输出保持格式，高质量 office

10、 报表font, 彩色，空间，等等可把里面的程式map到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 开发环

11、境可扩展，高性能分布和复制组件services optimized for task-at-hand 64位支持灵活的用户模型为用户提供高交互性的瘦客户端为开发者提供强大的开发端工作台- 动态html技术开发客户端 smart viewoffice add-inbi+ core servicesproduction reporting servicesinteractive reporting servicesfinancial reporting servicesenterprise metrics servicesanalytic servicesperformance scorecard

12、 servicesfoundation - shared servicesweb 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-appp

13、lanning services web-appfinancial mgmt servicesplanning servicesmdm serviceshttp serverhyperion system 9客户端客户端服务器服务器数据库数据库外部数据源外部数据源一致的视觉一致的视觉基于浏览器基于浏览器x.508支持支持htmlapplets可选可选microsoft office支持支持soa j2ee架构 web服务支持基于标准的创新基于标准的创新 xml for analysis jolap java data mining interface xbrl跨平台跨平台 windows/un

14、ix tomcat/wls/was可扩展可扩展集群:高可用性负载均衡所有主流数据库的支持所有主流数据库的支持多维和关系型数据库支持多维和关系型数据库支持各种数据源各种数据源hyperion system 9客户端客户端服务器服务器数据库数据库外部数据源外部数据源一致的视觉一致的视觉基于浏览器基于浏览器x.508支持支持htmlapplets可选可选microsoft office支持支持soa j2ee架构 web服务支持基于标准的创新基于标准的创新 xml for analysis jolap java data mining interface xbrl跨平台跨平台 windows/uni

15、x tomcat/wls/was可扩展可扩展集群:高可用性负载均衡所有主流数据库的支持所有主流数据库的支持多维和关系型数据库支持多维和关系型数据库支持各种数据源各种数据源soa 通过分布式的、可复制的服务提高效率和吞吐量通过分布式的、可复制的服务提高效率和吞吐量可扩展可扩展 更低的更低的tco，更大的硬件利用，更大的硬件利用符合标准符合标准jdbcodbcxmlacwmsap sap bw olap bapi 认证直接通过bapi访问到sap bw对象financial reporting, production reporting& ad-hoc analysis of sap bw

16、数据z爱报表和仪表板中混合sap bw和关系型数据和和google onebox 整合快速的hs9 bi+ 共享库内容搜索可以搜索查看仪表板快照从搜索结果创建新查询essbase bsoessbase asointelligencesqrmetrics builderreportsanalyzermaster data managementapplication link advancedhyperion hubessbase analyticsenterprise analyticsinteractive reportingproduction reportingenterprise met

17、ricsfinancial reportingweb analysismaster data managementapplication link advancedfoundation (shared services)hyperion system 9 bi+hs 9 foundation servicesperformance scorecardstrategic finance planningworkforce planningfinancial managementperformance scorecardstrategic finance planningworkforce pla

18、nningfinancial managementhyperion system 9 apps+让最终用户能够快速产生帐簿质量的财务和管理报表内嵌的财务功能能够更加容易嵌入报表预算和预测的报表的财务格式支持更容易根据企业架构来创建独立的批量报表丰富的输出支持,包括：html、pdf和在线查看支持hyperion应用, hyperion essbase analytics, hyperion enterprise analytics和sap bwhyperion system 9 bi+ 为所有的用户提供直观的、强大的和图形化的在线分析高级的分析功能，例如：排序、排列、过滤和用户定义计算多用的展

19、现方式，有表格、图形、动态图钉板和交通灯等支持hyperion应用, hyperion essbase analytics, hyperion enterprise analytics和sap bwhyperion system 9 bi+ hyperion system 9 bi+ 对关系型数据源进行ad-hoc查询和分析丰富的数据展现 图形和图片 旋转透视表 交通灯 基于模板和向导创建仪表板为移动用户提供离线能力通过突出显示显示指标hyperion system 9 bi+ 产生、管理和发布基于web的海量的和展现质量的报表精确的格式能力参数化的报表自动预警和数据处理任务触发流程和支持闭合

20、循环交易和web站点无缝整合支持关系型数据库, 业务数据源, sap r/3 and sap bwhyperion system 9 bi+organized by subject areaenables rapid problem identificationfrom summary metrics to root cause analysisimprove understanding of business-critical information across the entire enterprise personalize and extend to ensure that the

21、information received is appropriatehyperion system 9 bi+“one of the ten most influential technologies of the last decade”, information age magazinesophisticated financial and business analysispatented multi-dimensional database storage technologythe premier platform for building budgeting, planning,

22、 forecasting and predictive applications essbase: the multi-dimensional database technology that put online analytical processing (olap) on the business intelligence map. it spurred the creation of scores of rival olap products - and billions of olap cubes. information age magazineaugust 2005world-c

23、lass finance for global organizationshyperion system 9 model your business by taking spreadsheets to the next levelcalculation engine for deriving results and creating aggregations, consolidations and complex calculations.tight integration with excel and “speed of thought” performance allow for a “c

24、onversation with the data”forecasting, trend analysis, and other complex modeling, such as optimization or statistical analysis are supportedintegration with transaction and warehouse systemsopen, published apis allow for custom application developmenthyperion system 9 sparse data set aggregation te

25、chnologymassive scalability users, dimensionality, datavisualization of large 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 user

26、s to analyze across a much broader set of corporate data.”madan sheina, computerwireworld-class finance for global organizationshyperion system 9 highly granular data enormous dimensionality: millions of members within a dimensionmanages tight batch windows, minimal load and calc timesallows navigat

27、ion of large data sets delivers “speed of thought” performance to business usersintegrates with transaction and data warehouse systemswhat is hyperion dms? a data infrastructure layer a family of products comprised of products that are sold independently not an skuhyperion system 9 data management s

28、erviceswhat 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 hyperion dms produc

29、tsbpma 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 change managementmos

30、t common it change management solutions变动管理缺乏过程控制变动管理缺乏过程控制in the hallon the phonein the mailpre-mdm customer scenario1.accounts2.entity3.channel4.product5.project6.location peoplesoftoraclefinancialssapcustomplanningessbaseessbaseessbasedwit admine-mailoracleadminreviewspreadsheetplanningadminessba

31、seadminspreadsheetdifferent people involvedinevitable manual processerror-proneno auditabilityno effective way to rollback changestime and resource consumingbusinessuseretleaioraclefinancialssapcustombi toolsessbaseessbaseolapetleaidwpost-mdm customer scenario mdm serverhyperion mdm solves the probl

32、emimplies establishing or improving current processpeoplesoftbusinessusers集中的变动管理集中的变动管理legacyglsapcustomapplicationsoraclefinancialspeoplesoftstagingodsdmetleaiquery & reportinghyperion essbasehyperion planninghfmother reporting toolshyperionmdm serverbusiness processdmdwisetuptree moverbapi /

33、rfcscustom / etlflat filewhat is hyperion data integration management? a proven data integration platform built for hyperion system 9 leverages informatica powercenter technologyhyperion system 9 data integration managementwhat does hyperion data integration management do? access, integrate, transform, and move data and metadata between hyperion system 9 and virtually any system, at any frequency, and any volume新新system 9 数据整合平台数据整合平台 robust etl powered by informatic