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

HyperionSystem9BI+

使管理和分析更簡單邵小衛(wèi)商務智能售前總監(jiān)海波龍中國區(qū)什么是商務智能？在90年代中期，GartnerGroup提出了BI概念商業(yè)智能(BI)是一組應用和技術工具集，可以用來收集、存儲、分析和提供數據訪問來幫助企業(yè)用戶作更好的業(yè)務決策。BI應用包括決策支持系統(tǒng)、查詢和報表、在線分析處理、統(tǒng)計分析、預測和數據挖掘是一個全面的概念，包括了OLAP、查詢工具、報表工具。“最終用戶的信息訪問和分析工具〞架構和實現(xiàn)都各自不相同商業(yè)智能關系型數據查詢工具報表工具OLAP數據集市/倉庫工具分析應用數據挖掘戰(zhàn)略價值BI與BPM？80’s–90’s今天BI平臺BI套件BPM系統(tǒng)BI工具BI架構帶來了很多機遇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時機？數據模型設計工程管理技術架構數據倉庫管理業(yè)務需求分析數據庫管理數據獲取開發(fā)Source:ChartfromGartnerResearch交易架構功能組織業(yè)務CRMLegacy…ERPSCM調度實時ETT整合導向數據倉庫ODSBI平臺、EBIS、數據挖掘、IT為中心/用戶驅動組織驅動:績效管理,聚焦移向前端辦公室信息使用習慣

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

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

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

的用戶感覺一致性

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

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

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

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

-動態(tài)HTML技術開發(fā)客戶端

SmartView

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

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

Applets可選MicrosoftOffice支持SOAJ2EE架構Web效勞支持基于標準的創(chuàng)新XMLforAnalysisJOLAPJavaDataMiningInterfaceXBRL跨平臺Windows/UNIXTomcat/WLS/WAS可擴展集群:高可用性

負載均衡所有主流數據庫的支持多維和關系型數據庫支持各種數據源HyperionSystem9

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

Applets可選MicrosoftOffice支持SOAJ2EE架構Web效勞支持基于標準的創(chuàng)新XMLforAnalysisJOLAPJavaDataMiningInterfaceXBRL跨平臺Windows/UNIXTomcat/WLS/WAS可擴展集群:高可用性

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

–更低的TCO，更大的硬件利用符合標準JDBCODBCXMLACWMSAP認證的報表和分析

SAPBWOLAPBAPI認證直接通過BAPI訪問到SAPBW對象Financialreporting,productionreporting

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

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

WebAnalysisHyperionSystem9BI+

InteractiveReporting

對關系型數據源進行Ad-hoc查詢和分析豐富的數據展現(xiàn)圖形和圖片旋轉透視表交通燈基于模板和向導創(chuàng)立儀表板為移動用戶提供離線能力通過突出顯示顯示指標HyperionSystem9BI+

ProductionReporting產生、管理和發(fā)布基于Web的海量的和展現(xiàn)質量的報表精確的格式能力參數化的報表自動預警和數據處理任務觸發(fā)流程和支持閉合循環(huán)交易和Web站點無縫整合支持關系型數據庫,業(yè)務數據源,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變動管理缺乏過程控制IntheHallOnthePhoneIntheMailPre-MDMCustomerScenarioAccountsEntityChannelProductProjectLocationPeoplesoftOracleFinancialsSAPCustomPlanningEssbaseEssbaseEssbaseDWITAdminE-MailOracleAdminReviewSpreadsheetPlanningAdminEssbaseAdminSpreadsheetDifferentpeopleinvolvedInevitablemanualprocessError-proneNoauditabilityNoeffectivewaytorollbackchangesTimeandresourceconsumingBusinessUserETL

EAIOracleFinancialsSAPCustomBIToolsEssbaseEssbaseOLAPETL

EAIDWPost-MDMCustomerScenarioMDMServerHyperionMDMsolvestheproblemImpliesestablishingorimprovingcurrentprocessPeoplesoftBusinessUsers集中的變動管理LegacyGLSAPCustomApplicationsOracleFinancialsPeoplesoftStagingODSDMETLEAIQuery&ReportingHyperionEssbaseHyperionPlanningHFMOtherReportingToolsHyperion

MDMServerBusinessProcessDMDWiSetupTreeMoverBAPI/RFCsCustom/ETLFlatFileWhatisHyperionDataIntegrationManagement?

AprovendataintegrationplatformBuiltforHyperionSystem9

LeveragesInformaticaPowerCentertechnologyHyperionSystem9DataIntegrationManagement?WhatdoesHyperionDataIntegrationManagementdo?

Access,integrate,transform,andmovedataandmetadata

BetweenHyperionSystem9andvirtuallyanysystem,atanyfrequency,andanyvolume新System9數據整合平臺RobustE