Hyperion Sytem 9 BI 使管理和分析更簡(jiǎn)單

1、hyperion system 9 bi+ 使管理和分析更簡(jiǎn)單使管理和分析更簡(jiǎn)單邵小衛(wèi)商務(wù)智能售前總監(jiān)海波龍中國(guó)區(qū)什么是商務(wù)智能？什么是商務(wù)智能？在90年代中期，gartner group提出了bi概念商業(yè)智能 (bi)是一組應(yīng)用和技術(shù)工具集，可以用來(lái)收集、存儲(chǔ)、分析和提供數(shù)據(jù)訪問(wèn)來(lái)幫助企業(yè)用戶作更好的業(yè)務(wù)決策。bi應(yīng)用包括決策支持系統(tǒng)、查詢和報(bào)表、在線分析處理、統(tǒng)計(jì)分析、預(yù)測(cè)和數(shù)據(jù)挖掘是一個(gè)全面的概念，包括了olap、查詢工具、報(bào)表工具。 “最終用戶的信息訪問(wèn)和分析工具”架構(gòu)和實(shí)現(xiàn)都各自不相同商業(yè)智能關(guān)系型數(shù)據(jù)查詢工具報(bào)表工具olap數(shù)據(jù)集市/倉(cāng)庫(kù)工具分析應(yīng)用數(shù)據(jù)挖掘戰(zhàn)略價(jià)值戰(zhàn)略價(jià)值bi 8

2、0s 90s今天今天bi 平臺(tái)平臺(tái)bi套件bpm 系統(tǒng)系統(tǒng)bi工具工具bi架構(gòu)帶來(lái)了很多機(jī)遇架構(gòu)帶來(lái)了很多機(jī)遇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 數(shù)據(jù)模型設(shè)計(jì)項(xiàng)目管理技術(shù)架構(gòu)數(shù)據(jù)倉(cāng)庫(kù)管理業(yè)務(wù)需求分析數(shù)據(jù)庫(kù)管理數(shù)據(jù)獲取開發(fā)source: chart from gartner research交易交易架構(gòu)架構(gòu)功能功能組織組織業(yè)務(wù)業(yè)務(wù)crmlegacyerpscm調(diào)

5、度調(diào)度實(shí)時(shí)實(shí)時(shí)ett整合導(dǎo)向整合導(dǎo)向數(shù)據(jù)倉(cāng)庫(kù)數(shù)據(jù)倉(cāng)庫(kù)odsbi平臺(tái)、平臺(tái)、ebis、數(shù)據(jù)挖掘、數(shù)據(jù)挖掘、it為為中心中心/用戶驅(qū)動(dòng)用戶驅(qū)動(dòng)組織驅(qū)動(dòng)組織驅(qū)動(dòng):績(jī)效管理績(jī)效管理, 聚焦移向前端辦公室聚焦移向前端辦公室信息使用習(xí)慣信息使用習(xí)慣 (內(nèi)部的，外部的內(nèi)部的，外部的)用戶類型用戶類型, bi方法論方法論, 技巧和技巧和bi 部門部門關(guān)鍵趨勢(shì)關(guān)鍵趨勢(shì): 全球化、虛擬化、透明全球化、虛擬化、透明度度bi 應(yīng)用應(yīng)用:戰(zhàn)略戰(zhàn)略分析分析操作操作查詢和報(bào)表查詢和報(bào)表:標(biāo)準(zhǔn)、標(biāo)準(zhǔn)、ad hoc、用戶驅(qū)動(dòng)、用戶驅(qū)動(dòng)hyperion全新的全新的hyperion系統(tǒng)架構(gòu)系統(tǒng)架構(gòu)應(yīng)用架構(gòu)bi平臺(tái)工具bi平臺(tái)服務(wù)c

6、opyright 2007, hyperion. all rights reserved.hyperion system 9 提高效率 減少業(yè)務(wù)風(fēng)險(xiǎn) 降低 tco整合財(cái)務(wù)管理應(yīng)用和bi平臺(tái)的 bpm systeminformationmanagementinformation deliveryinformationproductionhyperion system 9: 國(guó)際化企業(yè)的管理系統(tǒng)國(guó)際化企業(yè)的管理系統(tǒng)operationalfinancialscorecardqueryhyperion system 9: 建立于豐富的經(jīng)驗(yàn)建立于豐富的經(jīng)驗(yàn)新的產(chǎn)品新的產(chǎn)品 | 新用戶界面新用戶界面 |

7、統(tǒng)一的架構(gòu)統(tǒng)一的架構(gòu)集成各種用戶充分認(rèn)可的集成各種用戶充分認(rèn)可的bi產(chǎn)品產(chǎn)品 hyperion intelligence hyperion analyzer hyperion reports hyperion sqr集成集成 多種多種bpm 產(chǎn)品產(chǎn)品 hyperion performance scorecards hyperion metrics（kpi） hyperion essbase hyperion financial management and hyperion planningsystem 9整合了用戶充分認(rèn)可的各種整合了用戶充分認(rèn)可的各種hyperion技術(shù)技術(shù)“windows

8、 on the web”的用戶感覺(jué)的用戶感覺(jué)一致性 bi的所有模塊所有用戶的界面在線和離線交互性拖拽下鉆和穿透旋轉(zhuǎn)過(guò)濾效率純html方式快捷訪問(wèn)自助式報(bào)表和儀表板創(chuàng)建自助式報(bào)表和儀表板創(chuàng)建存在的查詢和報(bào)表點(diǎn)擊點(diǎn)擊點(diǎn)點(diǎn)產(chǎn)生產(chǎn)生業(yè)務(wù)分析業(yè)務(wù)分析組件模板關(guān)系型關(guān)系型多維型多維型bpm系統(tǒng)系統(tǒng)對(duì)任意數(shù)據(jù)源的透明訪問(wèn)對(duì)任意數(shù)據(jù)源的透明訪問(wèn)essbase 先進(jìn)的分析先進(jìn)的分析 商業(yè)規(guī)則 預(yù)測(cè) 分?jǐn)?貨幣轉(zhuǎn)換 what-if?分析 分析大量數(shù)據(jù) 即時(shí)分析 數(shù)據(jù)挖掘 navigation sparse data set財(cái)務(wù)財(cái)務(wù)業(yè)務(wù)業(yè)務(wù) 繼續(xù)全面利用強(qiáng)大的essbase平臺(tái) 財(cái)務(wù)智慧delivering bro

9、ad capabilities儀表板財(cái)務(wù)報(bào)表生產(chǎn)報(bào)表指標(biāo)管理office整合ad hoc查詢和報(bào)表記分卡多維度分析各種不同報(bào)表的支持各種不同報(bào)表的支持交互式報(bào)表自助式報(bào)表經(jīng)典的管理報(bào)表旋轉(zhuǎn)、切片、鉆取等交互式分析報(bào)表企業(yè)級(jí)/業(yè)務(wù)報(bào)表任意格式報(bào)表核心業(yè)務(wù)報(bào)表解決方案財(cái)務(wù)報(bào)表強(qiáng)大的財(cái)務(wù)報(bào)表能力訪問(wèn)hyperion panning，hfm，essbase和sap bwad-hoc查詢和分析查詢和分析關(guān)系數(shù)據(jù)源的ad-hoc查詢真正自助式的ad-hoc查詢直接數(shù)據(jù)源的訪問(wèn)完全圖形化界面易于使用多維分析強(qiáng)大的分析功能 優(yōu)秀的展現(xiàn)能力高度整合高度整合對(duì)office 強(qiáng)力的輸出保持格式，高質(zhì)量 office

10、 報(bào)表font, 彩色，空間，等等可把里面的程式map到excel的程式可把內(nèi)容輸出到word, powerpoint, 或 excel支持”數(shù)據(jù) only” 輸出hyperion smart view所有的海波龍產(chǎn)品共同的 ms office add-in可跟所有的海波龍產(chǎn)品連接從excel, word, powerpoint, 或 outlook 可以利用數(shù)據(jù) | image | form跟數(shù)據(jù)來(lái)源動(dòng)態(tài)的連接共同的point of view支持office smart tag可擴(kuò)展的可擴(kuò)展的soa架構(gòu)架構(gòu)標(biāo)準(zhǔn)支持soap, xml & wsdlj2ee & .net 開發(fā)環(huán)

11、境可擴(kuò)展，高性能分布和復(fù)制組件services optimized for task-at-hand 64位支持靈活的用戶模型為用戶提供高交互性的瘦客戶端為開發(fā)者提供強(qiáng)大的開發(fā)端工作臺(tái)- 動(dòng)態(tài)html技術(shù)開發(fā)客戶端 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客戶端客戶端服務(wù)器服務(wù)器數(shù)據(jù)庫(kù)數(shù)據(jù)庫(kù)外部數(shù)據(jù)源外部數(shù)據(jù)源一致的視覺(jué)一致的視覺(jué)基于瀏覽器基于瀏覽器x.508支持支持htmlapplets可選可選microsoft office支持支持soa j2ee架構(gòu) web服務(wù)支持基于標(biāo)準(zhǔn)的創(chuàng)新基于標(biāo)準(zhǔn)的創(chuàng)新 xml for analysis jolap java data mining interface xbrl跨平臺(tái)跨平臺(tái) windows/un

14、ix tomcat/wls/was可擴(kuò)展可擴(kuò)展集群:高可用性負(fù)載均衡所有主流數(shù)據(jù)庫(kù)的支持所有主流數(shù)據(jù)庫(kù)的支持多維和關(guān)系型數(shù)據(jù)庫(kù)支持多維和關(guān)系型數(shù)據(jù)庫(kù)支持各種數(shù)據(jù)源各種數(shù)據(jù)源hyperion system 9客戶端客戶端服務(wù)器服務(wù)器數(shù)據(jù)庫(kù)數(shù)據(jù)庫(kù)外部數(shù)據(jù)源外部數(shù)據(jù)源一致的視覺(jué)一致的視覺(jué)基于瀏覽器基于瀏覽器x.508支持支持htmlapplets可選可選microsoft office支持支持soa j2ee架構(gòu) web服務(wù)支持基于標(biāo)準(zhǔn)的創(chuàng)新基于標(biāo)準(zhǔn)的創(chuàng)新 xml for analysis jolap java data mining interface xbrl跨平臺(tái)跨平臺(tái) windows/uni

15、x tomcat/wls/was可擴(kuò)展可擴(kuò)展集群:高可用性負(fù)載均衡所有主流數(shù)據(jù)庫(kù)的支持所有主流數(shù)據(jù)庫(kù)的支持多維和關(guān)系型數(shù)據(jù)庫(kù)支持多維和關(guān)系型數(shù)據(jù)庫(kù)支持各種數(shù)據(jù)源各種數(shù)據(jù)源soa 通過(guò)分布式的、可復(fù)制的服務(wù)提高效率和吞吐量通過(guò)分布式的、可復(fù)制的服務(wù)提高效率和吞吐量可擴(kuò)展可擴(kuò)展 更低的更低的tco，更大的硬件利用，更大的硬件利用符合標(biāo)準(zhǔn)符合標(biāo)準(zhǔn)jdbcodbcxmlacwmsap sap bw olap bapi 認(rèn)證直接通過(guò)bapi訪問(wèn)到sap bw對(duì)象financial reporting, production reporting& ad-hoc analysis of sap bw

16、數(shù)據(jù)z愛(ài)報(bào)表和儀表板中混合sap bw和關(guān)系型數(shù)據(jù)和和google onebox 整合快速的hs9 bi+ 共享庫(kù)內(nèi)容搜索可以搜索查看儀表板快照從搜索結(jié)果創(chuàng)建新查詢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+讓最終用戶能夠快速產(chǎn)生帳簿質(zhì)量的財(cái)務(wù)和管理報(bào)表內(nèi)嵌的財(cái)務(wù)功能能夠更加容易嵌入報(bào)表預(yù)算和預(yù)測(cè)的報(bào)表的財(cái)務(wù)格式支持更容易根據(jù)企業(yè)架構(gòu)來(lái)創(chuàng)建獨(dú)立的批量報(bào)表豐富的輸出支持,包括：html、pdf和在線查看支持hyperion應(yīng)用, hyperion essbase analytics, hyperion enterprise analytics和sap bwhyperion system 9 bi+ 為所有的用戶提供直觀的、強(qiáng)大的和圖形化的在線分析高級(jí)的分析功能，例如：排序、排列、過(guò)濾和用戶定義計(jì)算多用的展

19、現(xiàn)方式，有表格、圖形、動(dòng)態(tài)圖釘板和交通燈等支持hyperion應(yīng)用, hyperion essbase analytics, hyperion enterprise analytics和sap bwhyperion system 9 bi+ hyperion system 9 bi+ 對(duì)關(guān)系型數(shù)據(jù)源進(jìn)行ad-hoc查詢和分析豐富的數(shù)據(jù)展現(xiàn) 圖形和圖片 旋轉(zhuǎn)透視表 交通燈 基于模板和向?qū)?chuàng)建儀表板為移動(dòng)用戶提供離線能力通過(guò)突出顯示顯示指標(biāo)hyperion system 9 bi+ 產(chǎn)生、管理和發(fā)布基于web的海量的和展現(xiàn)質(zhì)量的報(bào)表精確的格式能力參數(shù)化的報(bào)表自動(dòng)預(yù)警和數(shù)據(jù)處理任務(wù)觸發(fā)流程和支持閉合

20、循環(huán)交易和web站點(diǎn)無(wú)縫整合支持關(guān)系型數(shù)據(jù)庫(kù), 業(yè)務(wù)數(shù)據(jù)源, 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變動(dòng)管理缺乏過(guò)程控制變動(dòng)管理缺乏過(guò)程控制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集中的變動(dòng)管理集中的變動(dòng)管理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 數(shù)據(jù)整合平臺(tái)數(shù)據(jù)整合平臺(tái) robust etl powered by informatic