1 / 0

Graphic Section Divider

Graphic Section Divider. CON9493 - Taking Oracle Essbase Beyond Finance. Gabby Rubin, Oracle Rajan Odayar , Rao Santhapur , ProQuest John Baker, Oracle Dmitry Kryuk , Google.

daphne
Download Presentation

Graphic Section Divider

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Graphic Section Divider
  2. CON9493 - Taking Oracle Essbase Beyond Finance Gabby Rubin, Oracle RajanOdayar, RaoSanthapur, ProQuest John Baker, Oracle Dmitry Kryuk, Google
  3. THE FOLLOWING IS INTENDED TO OUTLINE OUR GENERAL PRODUCT DIRECTION. IT IS INTENDED FOR INFORMATION PURPOSES ONLY, AND MAY NOT BE INCORPORATED INTO ANY CONTRACT. IT IS NOT A COMMITMENT TO DELIVER ANY MATERIAL, CODE, OR FUNCTIONALITY, AND SHOULD NOT BE RELIED UPON IN MAKING PURCHASING DECISIONS. THE DEVELOPMENT, RELEASE, AND TIMING OF ANY FEATURES OR FUNCTIONALITY DESCRIBED FOR ORACLE'S PRODUCTS REMAINS AT THE SOLE DISCRETION OF ORACLE.
  4. Program Agenda Introduction Improving Customer Experience - ProQuest Essbase outside of Finance - Oracle Project Management/Tasks Analysis - Google
  5. Complete Enterprise Business Intelligence Oracle Business Intelligence Foundation Suite Enterprise Business Intelligence Centralize semantic layer and definitions of all metrics, calculations, and measures for data-driven visualizations Increase operational effectiveness from reports to planning that eliminates cost redundancy PAST PRESENT FUTURE COMMON ENTERPRISE INFORMATION MODEL
  6. Oracle Business Intelligence Foundation Suite Single Enterprise-Scale Business Analytics Platform Unique Features Common Enterprise Information Model with physical, semantic and presentation layers Market-leading OLAP server for forward-looking analysis Single set of metrics across the enterprise Benefits Improve business performance by linking insight to action Consistent enterprise metrics for improved productivity Single analytic view across all data sources
  7. Oracle Business Intelligence Foundation Suite Oracle Essbase OBIEE EPM Microsoft Office Essbase provides a platform to build analytic applications which allows users to model, analyze, and interpret complex business scenarios Benefits Enables ‘speed of thought’ modeling of alternative scenarios Simplifies the forecasting and variance analysis processes Secure, shared, single version of the truth Centralized functions, calculations, aggregations Unique Features Ease of use for model creation and analysis Users use familiar tools to analyze – mainly Excel A centralized enterprise-scale solution Financial & time intelligence High performance for complex analysis Oracle Essbase Server Enterprise scale Optimized multidimensional storage Over 350 analytic functions Financial, time and calendar intelligence Multi user write-back Trickle feed
  8. RajanOdayar and RaoSanthapurProQuest
  9. Hyperion beyond finance: improving customer experiencerajanodayar: VP, Head Of GEMS, proquestSanthapur rao: Consulting Partner, Integratas, Inc.SEPTEMBER 26, 20132:00PM
  10. Proquest: For Confidence In Research Authoritative research content Critical discovery layers Vital management tools
  11. Across the most critical point in research process
  12. PQ Hyperion: What Business Problem are we solving? PQ Hyperion system can contribute even more to the business by leveraging Financial, Product, sales data more effectively, streamlining processes, and making data informed decisions as opposed to reliance on intuition and manual processes. What problems are we solving? Product Profitability Product Profitability Analysis Understand the impact of various items included in a product/Business Groups associated with developing and offering a specific product and assess a product's contribution to the bottom line Global sales Planning Enhance Data driven decision making in Sales, Income, Expense, Variable compensation, Customer and Products. Improved business intelligence and analytics with increased global mergers and acquisitions. Manage Sales and planning goals across new and existing business while creating and using new Annualized Sales and product Profitability metrics to realign the business.
  13. What Business Problem are We Solving? 1. Product Profitability 2. Global Sales Planning
  14. Initiative Objectives and Goals 1. Single Source 2. New Metrics
  15. Initiative Objectives and Goals 3. Empower Finance and Sales Teams
  16. Initiative Objectives and Goals 4. Expand Beyond Finance 5. Reuse Meta Data
  17. Architecture- Data Flow
  18. Use Case – Product Profitability
  19. Use Case – Product Profitability 1. Increased speed of data availability 2. Enabled CXOs to make data driven decisions 3. SmartView Efficient/Effective Month End Close
  20. Product Profitability Outline
  21. Solution Benefits 1. Profitability Analysis at Product Family and Cost Center Level 2. Reconciliation with FPA Cube 3. Product Family/Market Alignment now based on Product Profitability
  22. Use Case- Global Sales Planning CHALLENGE: Annualized Contract Value = Billed Sales … For Multi-year, non-standard contracts Variable Sales Compensation Reporting: Region, Market, Geography, Business Group, Territory Global Sales Cube: Consolidates DOR/WWPF Integrated with OIC/TM, OTC/Financial billings
  23. Global Sales Outline
  24. Use Case- Global Sales Planning Implement NEW Sales Metric (BdS): AnS: Annualized Sales BkS: Backlog Sales StS: Stub Sales (Non Standard) BdS: Billed Sales [BdS = AnS + BkS + StS] AnS now drives the Variable Compensation Plans Established trendline with prior years (2010 and 2011) Basis for unit and price assumptions for future budget
  25. Solution Benefits Single Source of Financial, Sales and Compensation Data Applies to products and sales regions Sales Reps and Finance can now validate compensation New Metrics Variance Analysis by product, market, region Interoperability EssbaseSalesforce (via ADF Fusion)
  26. John BakeDirectory, Oracle
  27. Taking Oracle Essbase Beyond Finance
  28. Dmitry KryukGoogle

  29. Taking Oracle Essbase Beyond Finance

    Dmitry Kryuk Sep-26, 2013
  30. Agenda Supported processes Google - lessons learned Project Management/Tasks Analysis Application Other ideas
  31. Supported Processes Month End/Actuals Process Accrual Forecast Product P&L Reporting Currency Conversion Allocations A few others
  32. Lessons learnt Consistent processes Minimize complexity
  33. Lessons learnt Learn best practices Minimize custom code
  34. Lessons learnt Develop custom solution? Enforce code quality Unit and regression testing Backward compatibility QA Utilize OOP methodology Documentation Knowledge transfer Resourcing
  35. Lessons learnt Proactively monitor and collect system metrics

  36. Project Management/Tasks Analysis Application

    Dmitry Kryuk Sep-26, 2013
  37. Overall Objectives Provide holistic view of bugs that the team is working on Provide visibility into progress of open bugs Identify areas where resources are over/under-utilized Enable resource managers to set expectations with business users and re-prioritize when necessary
  38. Why custom solution? Arguably not a business critical system Well accepted process of bugs updates with Google internal system No licenses No time for large-scale implementation Minimal investment Fun experiment
  39. Workflow
  40. Workflow App Engine - Bug Updates Issue Identified User interactions BigQuery Google Storage Gantt charts by resource/role/bug Analytics Essbase API Essbase Gantt charts by bug/role/resource Completion graphs
  41. Macro Recording
  42. Gantt chart by resource/role/bug
  43. Gantt chart by Bug/Role/Resource
  44. Analysis example
  45. Connecting the dots...
  46. Phases distribution
  47. Project Trend
  48. Dimensionality
  49. Dimensionality
  50. Other ideas Regressions to explain performance volatility Google spreadsheet integration

  51. Project Management/Tasks Analysis Application

    Dmitry Kryuk Sep-26, 2013
More Related