A Look at the Technology Behind Oracle BI Apps

1
A Look at the Technology Behind Oracle BI Apps

• Mark Rittman, Director, Rittman Mead Consulting

2
Who Am I?

• Oracle BIW Architecture and Development
  Specialist
• Co-Founder of Rittman Mead Consulting
• Oracle BIW Project Delivery Specialists
• 10 years with Discoverer, OWB etc
• Oracle ACE Director, ACE of the Year 2005
• Writer for OTN and Oracle Magazine
• Longest-running Oracle blog
• http//www.rittmanmead.com/blog
• Chair of UKOUG BIRT SIG
• Co-Chair of ODTUG BIDW SIG
• Speaker at IOUG and BIWA events

T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
3
Rittman Mead Consulting

• Oracle BIDW Project Specialists
• Consulting, Training, Support
• Works with you to ensure OBIEE andOracle BI
  Applications project success
• Small, focused team
• OWB, Oracle BI, DW technical specialists
• Clients in the UK, Europe, USA

T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
4
Oracle BI Training Days, London October 22nd -
24th 2008

• Three days of intensive BI Developer Training -
  OBIEE, BI Apps, Essbase, DW
• 10 Discount for attendees of this SIG Meeting,
  ask me for more details

T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
5
Oracle Business Intelligence Applications

• Packaged set of ETL mappings, dimensional data
  warehouse and pre-built reports and dashboards
• Financial Analytics
• HR Analytics
• Marketing Analytics
• Order Management Analytics
• Sales Analytics
• Service Analytics
• Contact Center Analytics
• Supply Chain Analytics

T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
6
Oracle BI Applications Core Proposition
Financial Analytics
T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
7
Part of Oracle Business Intelligence Technology
Stack
T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
8
Estimated 5x Development Productivity Boost
T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
9
Prebuilt Dashboards and Reports
T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
10
Prebuilt OBIEE Repository
T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
11
The Oracle BI Applications Business Model
Mapping Layer

• The Business Model and Mapping layercontains the
  complete, integrated logicaldata model for the
  OBAW
• Divided in to core and application-specificbusine
  ss models
• Coverage of the business model is determined by
  the products selectedat installation time

T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
12
Demonstration

• The OBIEE Repository, and Pre-built Dashboards
  Reports

13
Oracle BI Applications Architecture
T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
14
Predefined, Integrated Dimensional Data Warehouse

• Integrated, conformed dimensional data warehouse
• Allows modular deployment
• Lowest grain of information
• Prebuilt aggregates
• Deployable on Oracle, MS SQL,IBM DB/2 and
  Teradata
• History tracking
• Indexing

T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
15
The Oracle BI Applications ETL Process

• Oracle BI Applications comes with a set of
  pre-defined ETL routines
• Currently written using Informatica, in future
  also provided via Oracle DI
• Extracts data from Oracle EBS, Peoplesoft,
  Siebel, SAP
• Universal Adapter available for non-supported
  sources
• Controlled and orchestrated using the Oracle Data
  Warehouse Administration Console

T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
16
Oracle Data Warehouse Administration Console

• Control panel for running the OBAW load process
• ETL packaged into Execution Plans
• Tight integration with Informatica
• Run jobs, monitor progress
• The added value on top ofthe OBAW and INFA
  mappings

T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
17
Informatica PowerCenter 8.1.1

• Informatica PowerCenter 8.1.1 is a complete ETL
  toolkit
• Very much like Oracle Warehouse Builder, but
  applies to all sources and targets
• Uses an ETL hub to process and distribute data
• Server supported on Windows, Unix, Linux
• Client is Windows-only
• Five Key Informatica Client Tools
• Informatica Designer
• Informatica Workflow Manager
• Informatica Repository Manager
• Informatica Workflow Monitor

T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
18
Oracle Data Integrator

• A future release of the Oracle BI Applications
  will support ODI as the ETL tool
• Initially EBS to Oracle only, future releases
  will support all sources/targets
• Oracle heterogeneous ETL tool
• Acquired through Sunopsis Acquisition
• ELT approach
• Part of Oracle Fusion Middleware
• Customers can adopt eitherInformatica or ODI,
  Informatica willcontinue to be supported

T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
19
Customizing the Oracle Business Analytics
Warehouse

• Although the OBAW comes with many star schemas
  and many ETL routines, you will probably wish to
  extend and customize it to meet your neds
• Include flex-field data
• Adding data from a custom source
• Adding new facts, dimensions, hierarchies
• Data can come from many sources
• Sources with adapters and existing load routines
  you can customize
• Sources with adapters but no load routines
  (source unsupported for subject area)
• Unsupported sources (using the Universal Adapter)

T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
20
Customization Types

• OBAW customizations can be divided in to three
  categories
• Category 1 are where you add an additional column
  to an existing star schema
• Category 2 are where you add a new fact or
  dimension table
• Category 3 are where you addadditional rows to
  an existingfact or dimension, from
  anunsupported source

T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
21
Customizing and Creating New OBAW ETL Routines

• Whichever type of customization you perform,you
  will be working with two mappings per target
  fact or dimension
• An SDE (Source-Dependent Extract) mapto extract
  data from the source system
• An SIL (Source-Independent Layer) mapto load
  data into the fact or dimension
• Category 1 mappings involve customizingexisting
  SDE and SIL mappings
• Category 2 customizations involve creatingnew
  SDE and SIL mappings from scratch

T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
22
A Typical Informatica ETL Mapping

• Data extracted from sources using Mapplets,
  encapsulated business logic
• Data transformed using custom and pre-defined
  transformations
• Standard keys, tags added to data as it passes
  through ETL process
• Standard processes for adding surrogate keys,
  performing currency conversions etc
• Mapping is then run and executed from the DAC
  Console and repository

T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
23
Demonstration

• The Oracle BI Applications ETL Process

24
Summary

• The Oracle Business Intelligence Applications are
  a packaged DW Analytics solution for ERP and
  other data
• The base install of the Oracle BI Apps provides a
  pre-built set of data warehouse facts and
  dimensions, ETL routines, RPD metadata and
  control routines for a number of ERP modules
• You can extend and customize these mappings to
  bring in data not covered by the pre-built
  routines
• More details can be found on our website or in
  our Oracle BI Apps Developer Course

T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
25
Further Reading

• Other Presentations available on our website,
  http//www.rittmanmead.com
• Automating Business Decisions with Oracle
  Real-Time Decisions
• Data Modeling Techniques using Oracle BI Server
• Extending and Customizing the Oracle BI
  Applications Data Warehouse
• ODTUG Essbase Symposium Part 3 Oracle Business
  Intelligence Enterprise Edition
• We offer an intensive, three-day developer
  courseon Oracle BI Applications 7.9.5, ask for
  more details
• Oracle BI Training Days, October 22-24th 2008,
  London
• Contact me at mark.rittman_at_rittmanmead.com
• Thank you for attending, please dont forget to
  complete the online evaluation

T 44 (0) 8446 697 995 E
enquiries_at_rittmanmead.com W www.rittmanmead.com
26
A Look at the Technology Behind Oracle BI Apps

• Mark Rittman, Director, Rittman Mead Consulting