5 Presidential Way, Lincoln, RI 02865
USA +1-931-996-2243 | UK +44-056-0370-0299 | India +91-98909-34759

ORACLE BI

ORACLE BI

ORACLE BI


Oracle BI Applications Advance


1. Oracle BI Apps Overview

What is BI and why organizations need BI
BI Architecture
Oracle BI Apps Functional Architecture
Oracle BI Apps Technical Architecture
Analytics supported By BI Apps
Overview of Components Involved in BI Apps
ETL Architecture
Data Extracting and Loading Process
OBIEE Vs OBIA
OBIA Security Integration


2. Oracle BI Apps Installation and Configuration

BI Apps Implementation Methodology
Pre Requisites (Software and Hardware)
Installation Overview(Methodology)
Meta Data Configurations
OBIEE
Informatica
Global Configurations of BI Apps


3. Human Resource Analytics

Human Resource Analytics specific Configuration
Physical Data Model Overview
Logical Data Model Overview
Configuration points


4. Supply Chain Management

Supply Chain Management Analytics specific Configuration
Physical Data Model Overview
Logical Data Model Overview
Configuration points


5. Financials

Financials Specific configuration
Physical Data Model Overview
Logical Data Model Overview
Configuration points


6. Naming Standards

ETL Naming Standards
OBIEE Naming Standards


7. Load Strategies

Full Load
Incremental Loads


8. Delete process

9. Slowly Chaining Dimensions

10. Customization Best Practices

Customization Best Practices with real time examples
Upgrade Strategies
Customization Example
Trouble Shooting


11. BI APPS Security Implementation

DATA WAREHOUSE ADMINISTRATION CONSOLE
Overview on DAC (Data warehouse Administration Console)
Architecture
Overview on DAC Client
Integrating Informatica with DAC
Integrating Databases(Physical Data Sources) with DAC
Creating Oracle Business Analytics warehouse for BI Apps
Source System Containers
Development process in DAC
Physical Folder
Logical Folder
Source System Folders
Task Phases
Subject Areas
Execution Plan
Task Groups
Configuration Tags
Source System Parameters and Task Level Parameters