TRN 303 : Oracle BI Applications “Bootcamp”

Overview : This course is designed for customers and Oracle partners who wish to quickly bring a development team up to speed with the Oracle BI Applications, which uses Oracle BI EE 11g as the BI platform. Over three days, the basics of Oracle BI Applications development and administration is covered, teaching delegates how to install, configure and then load data into the Oracle BI Applications data warehouse using Oracle E-Business Suite 12.1.3 as a data source.

Duration : 3 Days

Course Delivery : Developers, consultants, project managers, technical leads, DBAs

Who Should Attend :End-users, developers, project managers

Prerequisites : none

Detailed Course Agenda :

Day 1

  1. Introduction to BI Applications

  2. Installation Overview, and Post-Install Configuration

  • Understanding the BI Apps Architecture
  • Review configuration tasks
  • Setting up the DAC
  • Setting up RPD and Web Catalog
  1. Performing the Initial Data Load
  • Creating an Execution Plan
  • Configuring an Execution Plan
  • Running the Execution Plan

Day 2

  1. Inside the Oracle BI Applications Warehouse
  • Understanding the data warehouse data model model
  • Table categories and types
  • Use of constraints, indexes, summaries
  • Running basic reports
  • Lineage and Metadata
  1. Customizing Existing ETL Routines, Facts and Dimensions
  • Understanding customization scenarios
  • Applying Category 1 customizations
  • Reflecting changes in the DAC Repository
  • Reflecting changes in the RPD

Day 3

  1. Adding New ETL Routines, Facts and Dimensions
  • Applying Category 2 customizations
  • Reflecting changes in the DAC
  • Creating new Informatica SDE mappings
  • Creating new Informatica SIL mappings
  • Adding new facts and dimensions to the RPD
  1. Optimization and Performance Tuning
  • Compression
  • Partitioning
  • Materialized Views

To book this course for your organization, to customize this course or for more information, contact for more details.

Website Design & Build: