Quick and easy access to your oracle apps data
Download
1 / 22

Quick and Easy Access to your Oracle Apps Data - PowerPoint PPT Presentation


  • 63 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Quick and Easy Access to your Oracle Apps Data' - hank


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Quick and easy access to your oracle apps data

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
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 bi evolution

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
Data Growth/Performance Relationship

Performance

History

Open Transactions

Source: OuterBay Technologies

Jaros Confidential


Customer example run times

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


Typical reporting process

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
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
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
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
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
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
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
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
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
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


ad