Overview
- General Datawarehousing concepts
- Dimensional modeling basics
- Oracle Business Intelligence Application Overview
- Comparing the Architecture of OBI 11g with OBI 10g
- Describing the Oracle Business Intelligence Applications Architecture and components
- BI Server
- BI Answers
- Interactive Dashboards
- Delivers
ADMIN TOOL AND RPD MODELING
- Creating Repository Using Administrative Tool
- Repository Basics
- Building Physical Layer of Repository
- Building Physical Model and BMM Layer of a Repository
- Building the Presentation Layer of a Repository
- Testing & Validation of a Repository
- Calculations & Measures
- Creating Dimension Hierarchies
- Organizing Presentation Layer
- Working with Initialization Blocks and Variables
- Adding Multiple Sources
- Executing Direct Database Requests
- Working with Aggregates
- Working with Partition Tables
- Creating Time Series Measures
SCHEDULING AND DELIVERING
- Sending Alerts Using Delivers
- Scheduler Configuration
- Scheduling Reports
BI Published Reporting
- Data Model
- Sub Templates
- Style Templates
- Reports
DASHBOARD AND ANALYSIS
- Creating Reports
- Working with Filters
- Working with Condition
- Working with Pivot Table
- Building Views and Charts in Requests
- Configuring Interactive Dashboards and prompts
- Creating Sample Request and Adding to Interactive Dashboard
- Configuring Action Links
- KPI & Scorecards
SECURITY FEATURES
- Authentication & Authorization
- Object & Data Level Security
- Webcatalog Level Security
- Weblogic Console
- Enterprise Manager
- User Adminstration
- Upgrading RPD/WEBCAT from a earlier release
BI Apps Repository Overview
- Overview of out of the box rpd
- RPD Settings
- Data and object based security
- Dashboards Overview
If Possible we would like to show end to end OBIEE development cycle example in the last
- Adding new facts and dimensions in warehouse
- Extending existing facts and dimensions in warehouse
- Adding or extending new mappings
- Customizing DAC to run new fact and dimension mappings
- Adding new facts and dimensions in rpd and analytics
