220 likes | 322 Views
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
E N D
Quick and Easy Accessto your Oracle Apps Data Stan Choflet Jaros Technologies 3-7-05 Jaros Confidential
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
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
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
Data Growth/Performance Relationship Performance History Open Transactions Source: OuterBay Technologies Jaros Confidential
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
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
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
Reporting Simplified Extraction, Transformation, and Load (ETL) CST INV FND OE AR Legacy Forecast, Reporting Product Line Jaros Confidential
Star Schema - Reporting Simplified Time Dimension Reporting Product Line Dimension Revenue Fact Product Dimension Customer Dimension Jaros Confidential
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
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
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
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
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
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
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
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
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
Enterprise Sales Visibility - 13 ERP Systems JarosGlobal Sales DW Oracle1 MAPICS Legacy MAN-MAN 4th Shift Oracle2 Legacy 2 Jaros Confidential
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
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