Oracle Business Intelligence Applications 7.9.6 Implementation

Course Description

Participants will receive a technical overview and gain hands-on understanding of the Oracle Business Intelligence Applications (Version 7.9.6) including detailed coverage of the Data Warehouse Administration Console, the Oracle Business Analytics Warehouse (OBAW) Data Models, the Out of the Box (OOTB) Dashboards and Reports, and Informatica toolsParticipants will be familiarized with the procedures needed to properly install Oracle BI Applications including the Informatica PowerCenter ETL Infrastructure on Windows.Participants will be familiarized with advanced topics related to integration between BI Applications and the various Oracle Applications (E-Business Suite, PeopleSoft, and Siebel).Participants will gain substantial hands-on experience using the Data Warehouse Administration Console in a controlled lab environment where they load a Warehouse that will be verified by using the OOTB Dashboards and Reports built for Oracle BI Enterprise Edition (OBI EE). In addition participants will gain high-level working skills with Informatica PowerCenter tools by creating a custom ETL to load the Data Warehouse. Finally participants will customize OBI EE to create new Dashboard content using the data loaded by the custom ETL.Learn To: How to install Oracle BI Applications including the Informatica PowerCenter ETL Infrastructure on WindowsHow to create a custom ETL to load the Data Warehouse. Finally participants will customize OBI EE to create new Dashboard content using the data loaded by the custom ETLHow to load a Warehouse that will be verified by using the OOTB Dashboards and Reports built for Oracle BI Enterprise Edition (OBI EE)A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Skills Gained

• Gain an understanding of the Oracle Business Intelligence Applications (Version 7.9.6)
• Gain a familiarization with the procedures needed to properly install Oracle BI Applications including the Informatica PowerCenter ETL Infrastructure on Windows
• Gain a familiarization with advanced topics related to integration between BI Applications and the various Oracle Applications (E-Business Suite, PeopleSoft, and Siebel)
• Gain substantial hands-on experience using the Data Warehouse Administration Console
• Participants will gain high-level working skills with Informatica PowerCenter tools by creating a custom ETL to load the Data Warehouse
• Participants will customize OBI EE to create new Dashboard content using the data loaded by the custom ETL

Who Can Benefit

• Administrator
• Business Analysts
• Business Intelligence Developer
• Data Warehouse Administrator
• Data Warehouse Analyst
• Data Warehouse Developer
• Database Designers

Syllabus

Oracle BI Applications Overview

• Describe the Oracle Business Intelligence Applications
• Describe major application components
• Describe integration with transactional applications

BI Applications Architecture

• Describe the Oracle Business Intelligence Applications Architecture
• Understand basic integration between Oracle EBS and BI Applications

DAC Overview

• Use the tools and views of the Data Warehouse Administration Console (DAC)
• Describe DAC objects, how they relate to each other, and their roles in the Oracle Business Analytics Warehouse (OBAW) extract, transform, and load (ETL)

Order Management Analytics Overview

• Describe the functional aspects of the Order Management Analytic Application
• Describe at a high-level the technical aspects of the Order Management Analytic Application

DAC Execution (Order Management) – Warehouse Load

• Configure the DAC for a full load of the OBAW
• Start and monitor a full load of the OBAW from the DAC
• Describe the overall process for using the DAC

DAC Execution Review

• Describe aspects of an OBAW load using the DAC

Warehouse Load Confirmation – OBI EE

• Use Oracle BI EE to confirm the load of the OBAW
• Describe the components of the OBI EE infrastructure

Oracle Business Analytics Warehouse (OBAW) Overview

• Describe the contents of the Oracle Business Analytics Warehouse
• Describe the warehouse tables

OBAW Customization Overview

• Describe the recommended customization practices for the Oracle Business Analytics Warehouse (OBAW)
• Describe specific aspects of each customization approach

Informatica Overview and Custom ETL

• Use the various Informatica tools
• Describe Informatica components and artifacts, how they relate to each other, and their roles in the overall ETL process
• Describe the process for creating a Custom ETL process using the Informatica Tools

DAC Custom Configuration and Execution

• Describe the process for creating new artifacts in the DAC to support a Custom ETL process
• Execute a Custom ETL using the DAC

OBI EE Customization

• Describe the process modifying the OBI EE Repository to include new content in the OBAW
• Describe the process for incorporating new content into the OBI EE Dashboards

BI Applications Integration with Oracle Applications

• Describe the options for integrating Oracle Business Intelligence Applications with the various Oracle Applications

BI Apps Security and Flexfield Support

• Describe the options for security and access control for Oracle Business Intelligence Applications
• Describe the options for handling EBS Flexfields within the OBAW and BI EE frameworks