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

HyperionSystem9BI+

使管理和分析更簡單邵小衛(wèi)商務(wù)智能售前總監(jiān)海波龍中國區(qū)什么是商務(wù)智能？在90年代中期，GartnerGroup提出了BI概念商業(yè)智能(BI)是一組應(yīng)用和技術(shù)工具集，可以用來收集、存儲(chǔ)、分析和提供數(shù)據(jù)訪問來幫助企業(yè)用戶作更好的業(yè)務(wù)決策。BI應(yīng)用包括決策支持系統(tǒng)、查詢和報(bào)表、在線分析處理、統(tǒng)計(jì)分析、預(yù)測和數(shù)據(jù)挖掘是一個(gè)全面的概念，包括了OLAP、查詢工具、報(bào)表工具?！白罱K用戶的信息訪問和分析工具〞架構(gòu)和實(shí)現(xiàn)都各自不相同商業(yè)智能關(guān)系型數(shù)據(jù)查詢工具報(bào)表工具OLAP數(shù)據(jù)集市/倉庫工具分析應(yīng)用數(shù)據(jù)挖掘戰(zhàn)略價(jià)值BI與BPM？80’s–90’s今天BI平臺(tái)BI套件BPM系統(tǒng)BI工具BI架構(gòu)帶來了很多機(jī)遇DataDesigner/ModelerProjectManager

TechnicalArchitectsDataWarehouseAdministratorBusinessRequirementsAnalyst

DatabaseAdministratorDataAcquisition(ETL)DeveloperSource:ChartfromGartnerResearchTransactionalInfrastructureFunctionalityOrganizationBusinessCRMLegacy…ERPSCMPoint-in-timeReal-timeETTIntegrationBrokersDatawarehouseODSBIplatforms,EBIS,dataminingIT-centric/user-drivenOrganizationdrivers:Performancemanagement,focusshiftingtofront-officeInformationCulture(inclusion,exclusion)Usertypes,BImethodology,SkillsandBidepartmentKeytrends:Globalization,Virtualization,TransparencyBIApplications:StrategicAnalyticalOperationalQueryandreporting:Standard,cannedAdhoc,user-drivenHyperionHyperionBI時(shí)機(jī)？數(shù)據(jù)模型設(shè)計(jì)工程管理技術(shù)架構(gòu)數(shù)據(jù)倉庫管理業(yè)務(wù)需求分析數(shù)據(jù)庫管理數(shù)據(jù)獲取開發(fā)Source:ChartfromGartnerResearch交易架構(gòu)功能組織業(yè)務(wù)CRMLegacy…ERPSCM調(diào)度實(shí)時(shí)ETT整合導(dǎo)向數(shù)據(jù)倉庫ODSBI平臺(tái)、EBIS、數(shù)據(jù)挖掘、IT為中心/用戶驅(qū)動(dòng)組織驅(qū)動(dòng):績效管理,聚焦移向前端辦公室信息使用習(xí)慣

(內(nèi)部的，外部的)用戶類型,BI方法論,技巧和BI部門關(guān)鍵趨勢:全球化、虛擬化、透明度BI應(yīng)用:戰(zhàn)略分析操作查詢和報(bào)表:標(biāo)準(zhǔn)、Adhoc、用戶驅(qū)動(dòng)Hyperion全新的Hyperion系統(tǒng)架構(gòu)應(yīng)用架構(gòu)BI平臺(tái)工具BI平臺(tái)效勞Copyright?2007,Hyperion.Allrightsreserved.HyperionSystem9提高效率減少業(yè)務(wù)風(fēng)險(xiǎn)降低TCO整合財(cái)務(wù)管理應(yīng)用和BI平臺(tái)的BPMSystemINFORMATIONMANAGEMENTINFORMATIONDELIVERYINFORMATIONPRODUCTIONHyperionSystem9:

國際化企業(yè)的管理系統(tǒng)OPERATIONALFINANCIALSCORECARDQUERYHyperionSystem9:

改變業(yè)務(wù)解決方案的管理系統(tǒng)建立于豐富的經(jīng)驗(yàn)新的產(chǎn)品|新用戶界面|統(tǒng)一的架構(gòu)集成各種用戶充分認(rèn)可的BI產(chǎn)品HyperionIntelligenceHyperionAnalyzerHyperionReportsHyperionSQR集成多種BPM產(chǎn)品HyperionPerformanceScorecardsHyperionMetrics〔KPI〕HyperionEssbaseHyperionFinancialManagementandHyperionPlanningSystem9整合了用戶充分認(rèn)可的各種Hyperion技術(shù)“WindowsontheWeb〞

的用戶感覺一致性

BI的所有模塊所有用戶的界面在線和離線交互性拖拽下鉆和穿透旋轉(zhuǎn)過濾效率純HTML方式快捷訪問自助式報(bào)表和儀表板創(chuàng)立存在的查詢和報(bào)表點(diǎn)擊點(diǎn)產(chǎn)生業(yè)務(wù)分析組件模板關(guān)系型多維型BPM系統(tǒng)對任意數(shù)據(jù)源的透明訪問Essbase

先進(jìn)的分析先進(jìn)的分析商業(yè)規(guī)那么預(yù)測分?jǐn)傌泿呸D(zhuǎn)換What-if?分析分析大量數(shù)據(jù)即時(shí)分析數(shù)據(jù)挖掘NavigationSparseDataSet財(cái)務(wù)業(yè)務(wù)繼續(xù)全面利用強(qiáng)大的Essbase平臺(tái)財(cái)務(wù)智慧DeliveringBroadCapabilities儀表板財(cái)務(wù)報(bào)表生產(chǎn)報(bào)表指標(biāo)管理Office整合AdHoc查詢和報(bào)表記分卡多維度分析各種不同報(bào)表的支持交互式報(bào)表自助式報(bào)表經(jīng)典的管理報(bào)表旋轉(zhuǎn)、切片、鉆取等交互式分析報(bào)表企業(yè)級/業(yè)務(wù)報(bào)表任意格式報(bào)表核心業(yè)務(wù)報(bào)表解決方案財(cái)務(wù)報(bào)表強(qiáng)大的財(cái)務(wù)報(bào)表能力訪問HyperionPanning，HFM，Essbase和SAPBWAd-hoc查詢和分析關(guān)系數(shù)據(jù)源的Ad-hoc查詢真正自助式的Ad-hoc查詢直接數(shù)據(jù)源的訪問完全圖形化界面易于使用多維分析強(qiáng)大的分析功能

優(yōu)秀的展現(xiàn)能力高度整合MicrosoftOffice對Office強(qiáng)力的輸出保持格式，高質(zhì)量Office報(bào)表Font,彩色，空間，等等可把里面的程式map到Excel的程式可把內(nèi)容輸出到Word,PowerPoint,或Excel支持〞數(shù)據(jù)only〞輸出HyperionSmartView所有的海波龍產(chǎn)品共同的MSOfficeadd-in可跟所有的海波龍產(chǎn)品連接從Excel,Word,PowerPoint,或Outlook可以利用數(shù)據(jù)|Image|Form跟數(shù)據(jù)來源動(dòng)態(tài)的連接共同的PointOfView支持OfficeSmartTag可擴(kuò)展的SOA架構(gòu)標(biāo)準(zhǔn)支持SOAP,XML&WSDLJ2EE&.NET開發(fā)環(huán)境可擴(kuò)展，高性能分布和復(fù)制組件Servicesoptimized

fortask-at-hand64位支持靈活的用戶模型為用戶提供高交互性的瘦客戶端為開發(fā)者提供強(qiáng)大的開發(fā)端工作臺(tái)

-動(dòng)態(tài)HTML技術(shù)開發(fā)客戶端

SmartView

OfficeAdd-InBI+CoreServicesProductionReportingServicesInteractiveReportingServicesFinancialReportingServicesEnterpriseMetricsServicesAnalyticServicesPerformanceScorecardServicesFoundation-SharedServicesWebAppServer(s)BI+WorkspaceWeb-AppFinancialReportingWeb-AppInteractiveReportingWeb-AppEnterpriseMetricsWeb-AppWebAnalysisWeb-AppAnalyticServicesWeb-AppPerfScorecardWeb-AppSharedServicesWeb-AppMDMServicesWeb-AppFinancialMgmtServicesWeb-AppPlanningServicesWeb-AppFinancialMgmtServicesPlanningServicesMDMServicesHTTPServerHyperionSystem9

單一架構(gòu)的BPM系統(tǒng)客戶端效勞器數(shù)據(jù)庫外部數(shù)據(jù)源一致的視覺基于瀏覽器x.508支持HTML

Applets可選MicrosoftOffice支持SOAJ2EE架構(gòu)Web效勞支持基于標(biāo)準(zhǔn)的創(chuàng)新XMLforAnalysisJOLAPJavaDataMiningInterfaceXBRL跨平臺(tái)Windows/UNIXTomcat/WLS/WAS可擴(kuò)展集群:高可用性

負(fù)載均衡所有主流數(shù)據(jù)庫的支持多維和關(guān)系型數(shù)據(jù)庫支持各種數(shù)據(jù)源HyperionSystem9

單一架構(gòu)的BPM系統(tǒng)客戶端效勞器數(shù)據(jù)庫外部數(shù)據(jù)源一致的視覺基于瀏覽器x.508支持HTML

Applets可選MicrosoftOffice支持SOAJ2EE架構(gòu)Web效勞支持基于標(biāo)準(zhǔn)的創(chuàng)新XMLforAnalysisJOLAPJavaDataMiningInterfaceXBRL跨平臺(tái)Windows/UNIXTomcat/WLS/WAS可擴(kuò)展集群:高可用性

負(fù)載均衡所有主流數(shù)據(jù)庫的支持多維和關(guān)系型數(shù)據(jù)庫支持各種數(shù)據(jù)源SOA–通過分布式的、可復(fù)制的效勞提高效率和吞吐量可擴(kuò)展

–更低的TCO，更大的硬件利用符合標(biāo)準(zhǔn)JDBCODBCXMLACWMSAP認(rèn)證的報(bào)表和分析

SAPBWOLAPBAPI認(rèn)證直接通過BAPI訪問到SAPBW對象Financialreporting,productionreporting

&ad-hocanalysisofSAPBW數(shù)據(jù)Z愛報(bào)表和儀表板中混合SAPBW和關(guān)系型數(shù)據(jù)和Google家族的整合GoogleOneBox整合快速的HS9BI+共享庫內(nèi)容搜索可以搜索查看儀表板快照從搜索結(jié)果創(chuàng)立新查詢EssbaseBSOEssbaseASOIntelligenceSQRMetricsBuilderReportsAnalyzerMasterDataManagementApplicationLinkAdvancedHyperionHub新老產(chǎn)品對應(yīng)表EssbaseAnalyticsEnterpriseAnalyticsInteractiveReportingProductionReportingEnterpriseMetricsFinancialReportingWebAnalysisMasterDataManagementApplicationLinkAdvancedFoundation(SharedServices)HyperionSystem9BI+HS9FoundationServicesPerformanceScorecardStrategicFinancePlanningWorkforcePlanningFinancialManagementPerformanceScorecardStrategicFinancePlanningWorkforcePlanningFinancialManagementHyperionSystem9Apps+讓最終用戶能夠快速產(chǎn)生帳簿質(zhì)量的財(cái)務(wù)和管理報(bào)表內(nèi)嵌的財(cái)務(wù)功能能夠更加容易嵌入報(bào)表預(yù)算和預(yù)測的報(bào)表的財(cái)務(wù)格式支持更容易根據(jù)企業(yè)架構(gòu)來創(chuàng)立獨(dú)立的批量報(bào)表豐富的輸出支持,包括：HTML、PDF和在線查看支持Hyperion應(yīng)用,HyperionEssbaseAnalytics,HyperionEnterpriseAnalytics和SAPBWHyperionSystem9BI+

FinancialReporting為所有的用戶提供直觀的、強(qiáng)大的和圖形化的在線分析高級的分析功能，例如：排序、排列、過濾和用戶定義計(jì)算多用的展現(xiàn)方式，有表格、圖形、動(dòng)態(tài)圖釘板和交通燈等支持Hyperion應(yīng)用,HyperionEssbaseAnalytics,HyperionEnterpriseAnalytics和SAPBWHyperionSystem9BI+

WebAnalysisHyperionSystem9BI+

InteractiveReporting

對關(guān)系型數(shù)據(jù)源進(jìn)行Ad-hoc查詢和分析豐富的數(shù)據(jù)展現(xiàn)圖形和圖片旋轉(zhuǎn)透視表交通燈基于模板和向?qū)?chuàng)立儀表板為移動(dòng)用戶提供離線能力通過突出顯示顯示指標(biāo)HyperionSystem9BI+

ProductionReporting產(chǎn)生、管理和發(fā)布基于Web的海量的和展現(xiàn)質(zhì)量的報(bào)表精確的格式能力參數(shù)化的報(bào)表自動(dòng)預(yù)警和數(shù)據(jù)處理任務(wù)觸發(fā)流程和支持閉合循環(huán)交易和Web站點(diǎn)無縫整合支持關(guān)系型數(shù)據(jù)庫,業(yè)務(wù)數(shù)據(jù)源,SAPR/3andSAPBWHyperionSystem9BI+

EnterpriseMetricsOrganizedbysubjectareaEnablesrapidproblemidentificationFromsummarymetricstorootcauseanalysisImproveunderstandingofbusiness-criticalinformationacrosstheentireenterprisePersonalizeandextendtoensurethattheinformationreceivedisappropriateHyperionSystem9BI+

EssbaseAnalytics“Oneofthetenmostinfluentialtechnologiesofthelastdecade〞,InformationAgemagazineSophisticatedfinancialandbusinessanalysisPatentedMulti-DimensionaldatabasestoragetechnologyThepremierplatformforbuildingBudgeting,Planning,ForecastingandPredictiveapplicationsEssbase: Themulti-dimensionaldatabasetechnologythatputonlineanalyticalprocessing(OLAP)onthebusinessintelligencemap.…itspurredthecreationofscoresofrivalOLAPproducts-andbillionsofOLAPcubes.

InformationAgemagazineAugust2005World-ClassFinanceforGlobalOrganizationsHyperionSystem9

EssbaseAnalyticsModelyourbusinessbytakingspreadsheetstothenextlevelCalculationengineforderivingresultsandcreatingaggregations,consolidationsandcomplexcalculations.TightintegrationwithExceland“speedofthought〞performanceallowfora“conversationwiththedata〞Forecasting,trendanalysis,andothercomplexmodeling,suchasoptimizationorstatisticalanalysisaresupportedIntegrationwithtransactionandwarehousesystemsOpen,publishedAPIsallowforcustomapplicationdevelopmentHyperionSystem9

EnterpriseAnalyticsSparsedatasetaggregationtechnologyMassivescalability–users,dimensionality,dataVisualizationoflargedatasetsOperationalAnalytics-Sales,Marketing,Manufacturing,Logistics,HRInspiredbyEssbase,withacommondevelopmentenvironment“…aggregatestorageandsparsematrixdatahandlingcapabilitiesallowenterpriseuserstoanalyzeacrossamuchbroadersetofcorporatedata.〞MadanSheina,ComputerwireWorld-ClassFinanceforGlobalOrganizationsHyperionSystem9

EnterpriseAnalyticsHighlygranulardataEnormousdimensionality:millionsofmemberswithinadimensionManagestightbatchwindows,minimalloadandcalctimesAllowsnavigationoflargedatasetsDelivers“Speedofthought〞performancetobusinessusersIntegrateswithtransactionanddatawarehousesystemsWhatisHyperionDMS?Adatainfrastructurelayer

AfamilyofproductsComprisedofproductsthataresoldindependentlyNotanSKUHyperionSystem9DataManagementServices?WhatdoesHyperionDMS

do?Itprovidescustomerswithaprovensetofproductsformanagingdata,financialdataquality,andmasterdataassociatedwiththeirBPMdeploymentsTheExtremes…CustomerwillpreparedataandmetadatatomatchHyperiontargetTechnicallynoneedforHyperionDMSproductsBPMAprovidessinglepointofentryCustomerwantsasolutionforpreparingdataandmetadatatomatchHyperiontargetImpliesdirectconnectivitytoERP/CRMSellDIMfordataandmetadatamovement?SIMPLECASECOMPLEXCASEFDMfitsforfinancialdataqualityMDMfitsformasterdatachangemanagementMostCommonITChangeManagementSolutions變動(dòng)管理缺乏過程控制IntheHallOnthePhoneIntheMailPre-MDMCustomerScenarioAccountsEntityChannelProductProjectLocationPeoplesoftOracleFinancialsSAPCustomPlanningEssbaseEssbaseEssbaseDWITAdminE-MailOracleAdminReviewSpreadsheetPlanningAdminEssbaseAdminSpreadsheetDifferentpeopleinvolvedInevitablemanualprocessError-proneNoauditabilityNoeffectivewaytorollbackchangesTimeandresourceconsumingBusinessUserETL

EAIOracleFinancialsSAPCustomBIToolsEssbaseEssbaseOLAPETL

EAIDWPost-MDMCustomerScenarioMDMServerHyperionMDMsolvestheproblemImpliesestablishingorimprovingcurrentprocessPeoplesoftBusinessUsers集中的變動(dòng)管理LegacyGLSAPCustomApplicationsOracleFinancialsPeoplesoftStagingODSDMETLEAIQuery&ReportingHyperionEssbaseHyperionPlanningHFMOtherReportingToolsHyperion

MDMServerBusinessProcessDMDWiSetupTreeMoverBAPI/RFCsCustom/ETLFlatFileWhatisHyperionDataIntegrationManagement?

AprovendataintegrationplatformBuiltforHyperionSystem9

LeveragesInformaticaPowerCentertechnologyHyperionSystem9DataIntegrationManagement?WhatdoesHyperionDataIntegrationManagementdo?

Access,integrate,transform,andmovedataandmetadata

BetweenHyperionSystem9andvirtuallyanysystem,atanyfrequency,andanyvolume新System9數(shù)據(jù)整合平臺(tái)RobustE