Hyperion Sytem 9 BI 使管理和分析更簡單

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

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

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

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

7、統(tǒng)一的架構(gòu)統(tǒng)一的架構(gòu)集成各種用戶充分認可的集成各種用戶充分認可的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整合了用戶充分認可的各種整合了用戶充分認可的各種hyperion技術(shù)技術(shù)“windows

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

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

10、 報表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ù)來源動態(tài)的連接共同的point of view支持office smart tag可擴展的可擴展的soa架構(gòu)架構(gòu)標準支持soap, xml & wsdlj2ee & .net 開發(fā)環(huán)

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

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

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

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

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

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