1 / 22

Quick and Easy Access to your Oracle Apps Data

Quick and Easy Access to your Oracle Apps Data . Stan Choflet Jaros Technologies 3-7-05. Proposed Agenda. Current Reporting Environment Alternative Solutions: the Market Best Practices The Data Warehouse Packaged Approach Value Proposition Best Practices Architecture, Functionality

hank
Download Presentation

Quick and Easy Access to your Oracle Apps Data

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. Quick and Easy Accessto your Oracle Apps Data Stan Choflet Jaros Technologies 3-7-05 Jaros Confidential

  2. Proposed Agenda • Current Reporting Environment • Alternative Solutions: the Market • Best Practices • The Data Warehouse • Packaged Approach Value Proposition • Best Practices Architecture, Functionality • Customer Examples • Technology Demonstration Jaros Confidential

  3. Range of Approaches Corporate Portals BI Tools Abstraction Cubes Data Marts ODS Views Transactional Systems Plumtree, BEA, Oracle, IBM Jaros Excelerator Jaros MicroStrategy Jaros Metadata Jaros ODS Jaros Insulation Views Jaros Confidential

  4. ERP Rollout BI Focus KeySites SmallerSites ERP/BI Evolution Data Warehouse Standard Reports ROI Custom Reports Data Marts Views Effort Customer Satisfaction Excel Time Jaros Confidential

  5. Data Growth/Performance Relationship Performance History Open Transactions Source: OuterBay Technologies Jaros Confidential

  6. Purge Purge Customer Example – Run Times Total Daily Run Time for Manufacturing Release Space Allocated for SO_LINES_ALL (including indexes) Jaros Confidential Source: Customer Study, OuterBay Technologies

  7. Typical Scenario Executive wants to know revenue and backlog (relative to forecast) and margin by reporting product line, by customer,month to date, quarter to date, year to date Sources of Data: Jaros Confidential

  8. AR OE FND INV CST Typical Reporting Process Staging PL/SQL Staging Reports Most significant portion of the effort is in writing PL/SQL Forecast Product Reporting Line Jaros Confidential

  9. Reporting Simplified Extraction, Transformation, and Load (ETL) CST INV FND OE AR Legacy Forecast, Reporting Product Line Jaros Confidential

  10. Star Schema - Reporting Simplified Time Dimension Reporting Product Line Dimension Revenue Fact Product Dimension Customer Dimension Jaros Confidential

  11. Gartner’s Best Practice BI Foundation • Key Concepts: • Single source of the truth • Don’t report on transaction sys • DW/ODS: Optimized reporting • Foundation for analytic apps • Multiple data sources • Lowest level of detail Jaros Confidential

  12. Jaros Company Overview Background / Experience • Oracle Applications, Database • Custom Data Warehouse Development • Manufacturing, Distribution Industry Experience Jaros Analytics Customers Jaros Analytics Coverage • GL, AP, AR • Purchasing • Orders, Shipments • Inventory, Costing • BOM, WIP, Master Scheduling/MRP • HR, Payroll (Beta) • Service & Contracts (Beta) • Planned: Fixed Assets, Projects, Advanced Security Model, MFG PRO Jaros Confidential

  13. Packaged Analytics Value Prop • EDW: Enterprise Visibility, Enterprise Efficiency • Dramatically TCO, Time, Risk • 2 day install, 6-8 week base implementation • Buy vs. Build: emerging market • Pre-built, Focused Content • 70-80% out of the box (Oracle Fin, OM, PO, Mfg, Inv) • Unique, Modern Approach • Architecture and Tools for Enterprise Integration • Near Real-Time Tactical Reporting • Extensibility of Architecture • Account Segments, Flexfields, Hierarchies, Business Rules • Custom, Legacy Integration “Jaros customers get what they want” Jaros Confidential

  14. Best Practices Architecture Financials Inventory/ Costing Purchasing Orders Shipping Mfg HR/Payroll Any BI Tool Data Marts & Analysis Areas AR Aging Working Capital Vendor On- Time Customer Performance Material Consumption Jaros ETL Operational Data Store (ODS) Near Real Time Tactical Reporting JarosETL Generic ERP API Views / Change Tracking Generic ERP API Legacy/ Spreadsheets Oracle Apps 10.7 Oracle Apps 11i MFG PRO Other ERP, CRM Jaros Confidential

  15. Data Marts: Analysis Areas • Financials • Account Margins • Costs, margins by COGS, revenue, and receivables accounts • AP Invoices Summary • AR Aging Detail with configurable buckets • AR DSO Snapshot • AR Sales (Summary with YTD, QTD, MTD growth vs. Goal, Plan) • GL, Drill to AP, AR subledgers • Purchasing • Variance Analysis (PPV. IPV) at PO receipt time • To sub element cost level by vendor, inventory org, account segment, etc. • PO Vendor On-Time Performance Summary • By request date and promise date • PO Vendor Outstanding Balances Summary • PO Vendor Payment History Summary Jaros Confidential

  16. Analysis Areas (Con’t) • Sales, Shipments, Customers • Net Bookings • Customer, Sales Rep, Product Analysis • List Price, Selling Price, COGS, Gross Margin, Discount Analysis • Open Orders including costing, margins • OM Customer Service Summary (on-time % by customer, item) • OM Lead Times Summary • Outstanding Work Orders (ability to deliver on time) • Supports ATO, PTO, kits, standard items; Flow and Discrete • Production and Efficiency • INV On-hand Snapshot (units w/ sub element costs) • INV Item Turns Snapshot with configurable Turns calculation • INV Obsolete Inventory Analysis Summary • MFG Usage (WIP, Sales Demand) • MFG Forecast vs. Actual Summary • WIP Analysis, Operational Variance Analysis, std vs. actual • BOM with Cost • Detailed BOM Analysis with Cost • Unit, Elemental, Sub-Element Cost Jaros Confidential

  17. Features • Multi-Currency Support • Global, Transacted, and Set of Books Currencies throughout • Ex: Drill from consolidated set of books to detail in USD • Cross Functional Analysis • Filter by 30+ conformed dimension tables • Drill Across Subject Areas • Near Real Time Updates • Historical Trending and Snapshots Jaros Confidential

  18. Best Practices % of user population: 85% 15% Static Docs Dashboards, Reports, Ad-hoc Query, Drill Down ROLAP or MOLAP DW/ODS – “Single Source of the Truth” Multiple Data Sources Jaros Confidential

  19. Enterprise Visibility Sales Finance Procurement Manufacturing Inventory JarosGlobal DW Oracle – US JarosEUR DW MFG PRO - US Oracle 1 – EUR Cullinet - US Oracle 2 – EUR JarosSo AM DW MFG PRO - EUR OracleBrazil Jaros Confidential

  20. Enterprise Sales Visibility - 13 ERP Systems JarosGlobal Sales DW Oracle1 MAPICS Legacy MAN-MAN 4th Shift Oracle2 Legacy 2 Jaros Confidential

  21. Jaros: Fastest Time to Results • Single Repository for Management Information • Company-wide, comprehensive • Integrate Oracle and non-Oracle data • Fin, OM, Mfg, Inv, PO out of the box • Easily Integrate non Oracle data • Portal for docs, pubs, links • Near real time and daily updates • Enterprise Portal/Dashboard • Tables, graphs, metrics, trends, drill down • Role-based security • Web, intra/extranet access • User friendly, customizable • Enterprise-class system • Highly available, high performance • User documentation for Oracle, extendable to others Jaros Confidential

  22. Jaros Demo Environment IE 6.0 Jaros Dashboard Discoverer 9iR2 Jaros EUL BEA WebLogic Server Oracle 9i, Jaros Data Marts ETL Oracle – 11.5.8 Vision Data Jaros Confidential

More Related