480 likes | 846 Views
Hyperion System 9. Nick Moscaritolo Sr. Solutions Consultant Business Intelligence. ERP. CRM. DW. LEGACY. Hyperion System 9 Foundation Services. Lowers Total Cost of Ownership. Shared Services Manages licenses, maintenance and users from a single point Data & Application Integration
E N D
Hyperion System 9 Nick Moscaritolo Sr. Solutions Consultant Business Intelligence
ERP CRM DW LEGACY Hyperion System 9Foundation Services Lowers Total Cost of Ownership • Shared Services • Manages licenses, maintenance and users from a single point • Data & Application Integration • Enables sharing of information and leverages integration investments • Master Data Management • Synchronizes data across BPM applications and transactional systems
ERP CRM DW LEGACY WEB MICROSOFT OFFICE Hyperion System 9Workspace 1.1 Increases User Productivity • One Client • A single web based environment to deploy, train and use • Full Interaction • Users can work with applications, explore dataand create reports by the Web • MS Office Integration • Seamless connection between information and end user productivity tools
ERP CRM DW LEGACY WEB MICROSOFT OFFICE Hyperion System 9Applications+ Complete Applications Suite • Planning and Modeling • Improve accuracy and predictability of plans and forecasts • Financial Consolidations • Accelerates close and reporting cycles while reducing the costs of compliance • Performance Scorecarding • Aligns strategy with goals to create an accountable organization
ERP CRM DW LEGACY WEB MICROSOFT OFFICE Hyperion System 9BI+ Broadest BI Functionality • Reporting • Addressing any type of management, financial or production reporting • Dashboards • Highly interactive, multi-source dashboards • Analysis • Extensive capabilities for financial and operational analysis
Hyperion System 9Business Performance Management Integrates Financial Applications with Business Intelligence • Increase productivity with an intuitive and easy to use environment • Reduce business risk by providing timely and accurate information • Lower TCO by simplifying deployments with a single system
Hyperion System 9Whiteboard Files ERP / OLTP Excel DW Cube
Hyperion System 9Whiteboard Foundation Files ERP / OLTP Excel DW Cube
Hyperion System 9Whiteboard Foundation Master Data Management Files ERP / OLTP Excel DW Cube
Hyperion System 9Whiteboard Foundation Master Data Management Data & Integration Services Files ERP / OLTP Excel DW Cube
Hyperion System 9Whiteboard Management Reporting Foundation Master Data Management Data & Integration Services Files ERP / OLTP Excel DW Cube
Hyperion System 9Whiteboard Management Reporting Query & Analysis Foundation Master Data Management Data & Integration Services Files ERP / OLTP Excel DW Cube
Hyperion System 9Whiteboard Management Reporting Query & Analysis Advanced Analytics Foundation Master Data Management Data & Integration Services Files ERP / OLTP Excel DW Cube
Hyperion System 9Whiteboard Strategic Modules Management Reporting Query & Analysis Advanced Analytics Foundation Master Data Management Data & Integration Services Files ERP / OLTP Excel DW Cube
Hyperion System 9Whiteboard Strategic Modules Financial Applications Management Reporting Query & Analysis Advanced Analytics Foundation Master Data Management Data & Integration Services Files ERP / OLTP Excel DW Cube
Hyperion System 9Whiteboard Dashboards Strategic Modules Financial Applications Management Reporting Query & Analysis Advanced Analytics Foundation Master Data Management Data & Integration Services Files ERP / OLTP Excel DW Cube
Hyperion System 9Whiteboard Dashboards Strategic Modules Financial Applications Management Reporting Query & Analysis Advanced Analytics Foundation Master Data Management Data & Integration Services Files ERP / OLTP Excel DW Cube
Hyperion System 9Whiteboard Workspace Dashboards Strategic Modules Financial Applications Management Reporting Query & Analysis Advanced Analytics Foundation Master Data Management Data & Integration Services Files ERP / OLTP Excel DW Cube
Hyperion System 9Whiteboard Power View Interactive Workspace Dashboards Strategic Modules Financial Applications Management Reporting Query & Analysis Advanced Analytics Foundation Master Data Management Data & Integration Services Files ERP / OLTP Excel DW Cube
Hyperion System 9Whiteboard Power View Interactive Workspace Dashboards Strategic Modules Financial Applications Management Reporting Query & Analysis Advanced Analytics Foundation Master Data Management Data & Integration Services Files ERP / OLTP Excel DW Cube
What’s New in System 9 • Security • License Server • User Provisioning ACROSS modules • Integrated Enterprise Metrics • Integrated Balanced Scorecard • NEW Navigate Panel • Viewer, Schedule, Explore, Admin, Impact • NEW Zero Client Query Generation • MS Office Integration • Impact/Change Manager
Pre-System 9 vs. Hyperion System 9 3 User Roles (Power, Interactive, View) 2 Licensing Models (Named, CPU) 5 User Roles (Administrator, Developer, Analyst, Interactive, View) 5 Licensing Models (Named, Concurrent, CPU, Server, Standalone) Hyperion System 9 BI+ Interactive Reporting Intelligence SQR Production Reporting Reports Financial Reporting Analyzer Web Analysis Essbase ASO Enterprise Analytics Essbase BSO Essbase Analytics Metrics Builder Enterprise Metrics Hyperion System 9 Foundation Services Master Data Management Master Data Management Application Link Advanced Application Link Advanced Hyperion Hub Foundation (Shared Services)
Hyperion System 9Business Performance Management Integrates Financial Applications with Business Intelligence • Increase productivity with an intuitive and easy to use environment • Reduce business risk by providing timely and accurate information • Lower TCO by simplifying deployments with a single system
Scalable Service Oriented Architecture Standards-based • J2EE • .NET Development Scalable, High Performance • Distribute and replicate components • Services optimized for task-at-hand • 64 Bit Support Flexible User Models • High interactivity thin client for consumption • Rich studio products for authors Client Tier Web Tier Services Tier System 9 Services • - Financial Reporting • Interactive Reporting • Production Reporting • Web Analysis • Enterprise Metrics • Performance Scorecard DHTML Web HTTP Server J2EE App Server(s) Workspace Web-App Smart View Add-in Authentication & Authorization Repository & Directory Authoring Studio’s Licensing & Configuration
“Windows On Web” User Experience • Consistent • Any module of BI • Any user profile • Online & Disconnected • Interactive • Drag & Drop • Drill Down & Across • Pivot & Chart • Filter & Limit • Efficient • Zero Client • Web Environment
Seamless Microsoft Office Integration • Export fully formatted content to MS Office • Direct access import from Excel, Word, Powerpoint & Outlook • Live source connections • Pre-create board-room templates
Management ReportingProduction & Financial Reporting • Multiple Data Sources • Databases, Cubes, Files, SAP • Multiple Output Types • HTML, PDF, Databases • On Demand or Scheduled • Enterprise-wide Large-scale reporting • Used for Data Processing & ETL • Handles Complex Conditional Formatting • Pixel-Perfect Output includes • Bills, Invoices, Bar Codes, • Checks & Receipts • Out of the box financial functions • Financial report formatting • Planning and Forecasting • Book Quality Content
Ad-Hoc Query & AnalysisDesigned for Users to Help Themselves • 100% GUI with a full API • Relational DBs • Multidimensional DBs • Data Visualization Concepts • Pivots • Spreadsheets • Graphing & Charting • Ad-Hoc Reporting • Pinboards • Dashboard Building • Wizard w/ Templates • Offline “Local” Option • Disconnected cached option • Performance Spotlighting • Exception alerting
Advanced AnalyticsPowerful Enterprise Analysis • Use what you know • Integration through MS Office • Data & Content • Eliminates static spreadsheets • Refresh instantly with latest data • Extend spreadsheet analysis visually • Link “Related Content” and “Cell Notes” directly to the data • Perform “What If” analysis using Excel
Transparent User Access To Any Source Relational Multidimensional Financial Management Applications
SAP R/3 & SAP BW OLAP BAPI Certified Mixed Content Financial & Production Reporting Web Analysis & Interactive Integrated Live Dashboards Multiple Sources SAP BW, R/3, Relational, Files SAP Certified Reporting & Analysis
Self-Service Dashboard Creation Step By Step Wizard Driven CLICK POINT GENERATE New or Existing Queries & Reports Custom Templates
Single Point of User Provisioning • CREATE • Users • Groups • Roles • ASSIGN • Security • Users to Groups • Groups to Groups • User Common “Roles” • PROVISION USERS • Modular Access
Hyperion System 9One System For All Content Dashboards Interactive Reporting Production Reporting Financial Reporting Web Analysis Financial & Strategic Applications Enterprise Metrics MS Office Integration
Essbase Planning Essbase Essbase Spreadsheet Custom SAP Peoplesoft Oracle Financials Business User IT Admin Planning Admin Essbase Admin Oracle Admin E-Mail Master Data Management (MDM)Typical Situation • Many people/departments involved • Normally Manual process • Error-prone • No auditability • No effective way to rollback changes • Time and resource consuming DW • Accounts • Entity • Channel • Product • Project • Location ETLEAI Review Spreadsheet
BI Tools Essbase Essbase OLAP MDM Server Custom SAP Peoplesoft Oracle Financials Business Users Master Data Management (MDM)Solution • Hyperion MDM solves the problem • Establishes and/or improves current change process • Accountability DW ETLEAI
Change Management • Harvest Metadata • Automatic when publishing • Can Synchronize if needed • Analyze Impact • Identify documents effected • Automatic Update • Proliferate Changes • Additional Functionality • Automatic Document Refresh (ADR)
Summary Simplify to Broaden User Adoption • Consistent, intuitive user experience • Self service report & dashboard creation • Seamless integration and interaction with MS Office Standardize to Lower IT Costs • Broadest BI functionality on a single platform • Single point of provisioning and security • Standards-based, massively scalable architecture Synchronize Information To Ensure Consistency • Common metadata repository • Master Data Management • Automated impact management