Oracle BI Applications 11g: Implementation using ODI (D82531)

Oracle Business Intelligence Applications Overview

• Oracle BI Applications components
• Business areas supported in Oracle BI Applications

Oracle BI Applications Architecture

• Oracle BI Applications components overview
• Oracle BI Applications architecture overview
• Oracle BI Applications product lifecycle overview

Oracle Business Analytics Warehouse Content

• Pre-built star schemas in Oracle Business Analytics Warehouse
• Oracle Business Analytics Warehouse naming conventions
• Overview of Oracle Business Analytics Warehouse tables
• System columns in Oracle Business Analytics Warehouse tables

Installing Oracle Business Intelligence Applications

• Preinstallation and deployment requirements
• Installing Oracle BI Applications prerequisites
• Installing Oracle BI Applications
• Performing post-installation system set up tasks

Understanding the ETL Process

• ETL phases and processing overview
• Using ODI Studio to explore prebuilt ETL metadata
• Full ETL and incremental ETL
• Change capture
• ETL versus ELT

Functional Configuration for Oracle BI Applications

• Functional configuration overview
• Terminology related to Oracle BI Applications configuration
• Configuration Manager overview
• Functional Setup Manager overview
• Creating an implementation project
• Assigning configuration tasks to developers

Administering and Maintaining Functional Configuration Data

• Functional configuration data overview
• Administering and maintaining domains and domain mappings
• Editing domain members
• Administering and maintaining data load parameters
• Administering and maintaining reporting parameters

Managing Load Plans

• Defining, generating, executing, and monitoring load plans
• Troubleshooting and restarting load plans
• Managing load plan parameters

Customizing the Oracle Business Analytics Warehouse

• Customization types and scenarios overview
• Overview of category1 and category 2 customizations
• Impact of patches on customizations
• Applying an update strategy

Building a Category 1 Customization

• Adding columns to existing tables in the OBAW
• Creating custom ETL mappings for a category 1 customization
• Enabling versioning for a category 1 customization
• Generating DDL scripts for a category 1 customization
• Creating and executing a load plan for a category 1 customization

Building a Category 2 Customization

• Adding a new dimension table to the OBAW
• Creating custom ETL mappings for a category 2 customization
• Enabling versioning for a category 2 customization
• Generating DDL scripts for a category 2 customization
• Creating and executing a load plan for a category 2 customization

Oracle BI Applications Security

• Tools used to manage Oracle BI Applications security
• Oracle BI Applications security levels
• Exploring default security settings for Oracle BI Applications
• Exploring ODI security

Managing Performance

• Optimizing performance overview
• Performance tuning recommendations