HyperionSystem9BI使管理和分析更简单

1、1会计学HyperionSystem9BI使管理和分析更简使管理和分析更简单单战略价值战略价值80s 90s今天今天BI 平台平台BI套件BPM 系统系统BI工具工具Data Designer/ModelerProject Manager Technical ArchitectsData Warehouse AdministratorBusiness Requirements Analyst Database Administrator Data Acquisition (ETL) DeveloperSource: Chart from Gartner ResearchTransactiona

2、lInfrastructureFunctionalityOrganizationBusinessCRMLegacyERPSCMPoint-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

3、types, BI methodology, Skills and Bi departmentKey trends: Globalization, Virtualization, TransparencyBI Applications:StrategicAnalyticalOperationalQuery and reporting:Standard, cannedAd hoc, user-drivenHyperion数据模型设计项目管理技术架构数据仓库管理业务需求分析数据库管理数据获取开发Source: Chart from Gartner Research交易交易架构架构功能功能组织组织业

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

5、right 2007, Hyperion. All rights reserved. 提高效率 减少业务风险 降低 TCO整合财务管理应用和BI平台的 BPM SystemINFORMATIONMANAGEMENTINFORMATION DELIVERYINFORMATIONPRODUCTIONOPERATIONALFINANCIALSCORECARDQUERYSystem 9整合了用户充分认可的各种整合了用户充分认可的各种Hyperion技术技术存在的查询和报表点击点击点点产生产生业务分析业务分析组件模板关系型关系型多维型多维型BPM系统系统先进的分析先进的分析 商业规则 预测 分摊 货币转

6、换 What-if?分析 分析大量数据 即时分析 数据挖掘 Navigation Sparse Data Set财务财务业务业务 继续全面利用强大的Essbase平台 财务智慧仪表板财务报表生产报表指标管理Office整合Ad Hoc查询和报表记分卡多维度分析工作台- 动态HTML技术开发客户端 Smart ViewOffice Add-InBI+ Core ServicesProduction Reporting ServicesInteractive Reporting ServicesFinancial Reporting ServicesEnterprise Metrics Servi

7、cesAnalytic ServicesPerformance Scorecard 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 Service

8、s Web-AppFinancial Mgmt Services Web-AppPlanning Services Web-AppFinancial Mgmt ServicesPlanning ServicesMDM ServicesHTTP Server客户端客户端服务器服务器数据库数据库外部数据源外部数据源一致的视觉一致的视觉基于浏览器基于浏览器x.508支持支持HTMLApplets可选可选Microsoft Office支持支持SOA J2EE架构 Web服务支持基于标准的创新基于标准的创新 XML for Analysis JOLAP Java Data Mining Interfa

9、ce XBRL跨平台跨平台 Windows/UNIX Tomcat/WLS/WAS可扩展可扩展集群:高可用性负载均衡所有主流数据库的支持所有主流数据库的支持多维和关系型数据库支持多维和关系型数据库支持各种数据源各种数据源客户端客户端服务器服务器数据库数据库外部数据源外部数据源一致的视觉一致的视觉基于浏览器基于浏览器x.508支持支持HTMLApplets可选可选Microsoft Office支持支持SOA J2EE架构 Web服务支持基于标准的创新基于标准的创新 XML for Analysis JOLAP Java Data Mining Interface XBRL跨平台跨平台 Wind

10、ows/UNIX Tomcat/WLS/WAS可扩展可扩展集群:高可用性负载均衡所有主流数据库的支持所有主流数据库的支持多维和关系型数据库支持多维和关系型数据库支持各种数据源各种数据源可扩展可扩展 更低的更低的TCO，更大的硬件利用，更大的硬件利用符合标准符合标准JDBCODBCXMLACWMEssbase BSOEssbase ASOIntelligenceSQRMetrics BuilderReportsAnalyzerMaster Data ManagementApplication Link AdvancedHyperion HubEssbase AnalyticsEnterprise

11、 AnalyticsInteractive ReportingProduction ReportingEnterprise MetricsFinancial ReportingWeb AnalysisMaster Data ManagementApplication Link AdvancedFoundation (Shared Services)Hyperion System 9 BI+HS 9 Foundation ServicesPerformance ScorecardStrategic Finance PlanningWorkforce PlanningFinancial Manag

12、ementPerformance ScorecardStrategic Finance PlanningWorkforce PlanningFinancial ManagementHyperion System 9 Apps+ 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

13、 - and billions of OLAP cubes. Information Age magazineAugust 2005World-Class Finance for Global Organizations“aggregate storage and sparse matrix data handling capabilities allow enterprise users to analyze across a much broader set of corporate data.”Madan Sheina, ComputerwireWorld-Class Finance f

14、or Global OrganizationsWhat is Hyperion DMS? A data infrastructure layer A family of products Comprised of products that are sold independently Not an SKUWhat does Hyperion DMSdo? It provides customers with a proven set of products for managing data, financial data quality, and master data associate

15、d with their BPM deploymentsCustomer will prepare data and metadata to match Hyperion targetTechnically no need for Hyperion DMS productsBPMA provides single point of entryCustomer wants a solution for preparing data and metadata to match Hyperion targetImplies direct connectivity to ERP/CRMSell DIM

16、 for data and metadata movement?SIMPLE CASECOMPLEX CASEFDM fits for financial data qualityMDM fits for master data change managementMost Common IT Change Management SolutionsIn the HallOn the PhoneIn the Mail1.Accounts2.Entity3.Channel4.Product5.Project6.Location PeoplesoftOracleFinancialsSAPCustomP

17、lanningEssbaseEssbaseEssbaseDWIT AdminE-MailOracleAdminReviewSpreadsheetPlanningAdminEssbaseAdminSpreadsheetBusinessUserETLEAIOracleFinancialsSAPCustomBI ToolsEssbaseEssbaseOLAPETLEAIDWMDM ServerPeoplesoftBusinessUsersLegacyGLSAPCustomApplicationsOracleFinancialsPeoplesoftStagingODSDMETLEAIQuery &am

18、p; ReportingHyperion EssbaseHyperion PlanningHFMOther Reporting ToolsHyperionMDM ServerBusiness ProcessDMDWiSetupTree MoverBAPI / RFCsCustom / ETLFlat FileWhat is Hyperion Data Integration Management? A proven data integration platform Built for Hyperion System 9 Leverages Informatica PowerCenter te

19、chnologyWhat 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 Robust ETL Powered by Informatica BPM Adapters Certified ERP / CRM AdaptersFinancial Management, Pl

20、anning, Essbase Analytics and HSF to reduce the data integration costs and data mapping complexities. Financial Data QualityAudit TrailsIntegrate SOX questionnairesStore current and historical mapping definitionsStore supporting documentsData Collectionand Transformation Read and interpret any G/L t

21、rial balance file Mapping validation against target system dimensions Data integrity checking against data validation rulesInternal Controls Source financial document archival Prepackaged audit and internal control reports Comprehensive role based securityRepeatableProcesses Single standard and defi

22、ned solution for any target application Standardized database schema Standard upward data certification processHyperion数据模型设计项目管理技术架构数据仓库管理业务需求分析数据库管理数据获取开发Source: Chart from Gartner Research交易交易架构架构功能功能组织组织业务业务CRMLegacyERPSCM调度调度实时实时ETT整合导向整合导向数据仓库数据仓库ODSBI平台、平台、EBIS、数据挖掘、数据挖掘、IT为为中心中心/用户驱动用户驱动组织驱动

23、组织驱动:绩效管理绩效管理, 聚焦移向前端办公室聚焦移向前端办公室信息使用习惯信息使用习惯 (内部的，外部的内部的，外部的)用户类型用户类型, BI方法论方法论, 技巧和技巧和BI 部门部门关键趋势关键趋势: 全球化、虚拟化、透明全球化、虚拟化、透明度度BI 应用应用:战略战略分析分析操作操作查询和报表查询和报表:标准、标准、Ad hoc、用户驱动、用户驱动HyperionINFORMATIONMANAGEMENTINFORMATION DELIVERYINFORMATIONPRODUCTION客户端客户端服务器服务器数据库数据库外部数据源外部数据源一致的视觉一致的视觉基于浏览器基于浏览器x.508支持支持HTMLApplets可选可选Microsoft Office支持支持SOA J2EE架构 Web服务支持基于标准的创新基于标准的创新 XML for Analysis JOLAP Java Data Mining Interface XBRL跨平台跨平台 Windows/UNIX Tomcat/WLS/WAS可扩展可扩展集群:高可用性负载均衡所有主流数据库的支持所有主流数据库的支持多维和关系型数据库支持多维和关系型数据库支持各种数据源各种数据源可扩展可扩展 更低的更低的TCO，更大的硬件利用，更大的硬件利用符合标准符合标准JDBCODBCX