8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 1/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
A Look at the Technology Behind Oracle BI AppsMark Rittman, Director, Rittman Mead Consulting
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 2/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
Who Am I?
•Oracle BI&W Architecture and Development Specialist
•Co-Founder of Rittman Mead Consulting
‣Oracle BI&W 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 BI&DW SIG
•Speaker at IOUG and BIWA events
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 3/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
Rittman Mead Consulting
•Oracle BI&DW 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
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 4/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
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
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 5/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
Oracle Business Intelligence Applications
•Packaged set of ETL mappings, dimensional data warehouse and pre-built reports anddashboards
•Financial Analytics
•HR Analytics
•
Marketing Analytics•Order Management Analytics
•Sales Analytics
•Service Analytics
•Contact Center Analytics
•Supply Chain Analytics
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 6/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
Oracle BI Applications Core Proposition : Financial Analytics
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 7/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
Part of Oracle Business Intelligence Technology Stack
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 8/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
Estimated 5x Development Productivity Boost
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 9/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
Prebuilt Dashboards and Reports
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 10/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
Prebuilt OBIEE Repository
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 11/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
The Oracle BI Applications Business Model & Mapping Layer
•The Business Model and Mapping layer contains the complete, integrated logicaldata model for the OBAW
•Divided in to core and application-specificbusiness models
•Coverage of the business model isdetermined by the products selectedat installation time
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 12/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
DemonstrationThe OBIEE Repository with Oracle BI Applications Data Items
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 13/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
Oracle BI Applications Architecture
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 14/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
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
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 15/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
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
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 16/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
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 of the OBAW and INFA mappings
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 17/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
DemonstrationThe Oracle Data Warehouse Administration Console
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 18/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
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” toprocess 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
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 19/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
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 either Informatica or ODI, Informatica willcontinue to be supported
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 20/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
Customizing the Oracle Business Analytics Warehouse
•Although the OBAW comes with many star schemas and many ETL routines, you willprobably 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)
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 21/27
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 22/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
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
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 23/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
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
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 24/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
DemonstrationPre-Seeded and Customized Informatica Mappings
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 25/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
Summary
•The Oracle Business Intelligence Applications are a packaged DW + Analytics solutionfor ERP and other data
•The base install of the Oracle BI Apps provides a pre-built set of data warehouse factsand dimensions, ETL routines, RPD metadata and control routines for a number of ERPmodules
•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
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 26/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
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 [email protected]
•Thank you for attending, please don’t forget tocomplete the online evaluation
8/6/2019 A Look at the Technology Behind the Oracle BI Applications
http://slidepdf.com/reader/full/a-look-at-the-technology-behind-the-oracle-bi-applications 27/27
T : +44 (0) 8446 697 995 E : [email protected] W: www.rittmanmead.com
A Look at the Technology Behind Oracle BI AppsMark Rittman, Director, Rittman Mead Consulting