Oracle OBIEE 11g
6 Saturdays (9am to 11am) | Intermediate to Advanced | Course Notes
Course Content
Week 1 — OBIEE 11g Architecture & Repository Basics
- Overview of Oracle Business Intelligence Enterprise Edition (OBIEE) 11g architecture
- Understanding the BI Server, Presentation Server, and Scheduler components
- Introduction to the Administration Tool and repository (.rpd) files
- Setting up the development environment and connecting to data sources
- Creating a new repository and importing database metadata
- Working with physical tables, aliases, and foreign key relationships
- Validating and checking consistency of the repository
- Best practices for repository version control and backup
Week 2 — Physical, Business Model, and Presentation Layers
- Deep dive into the three-tier repository architecture
- Physical layer: Setting up connection pools, schemas, and native database joins
- Business Model and Mapping (BMM) layer: Creating logical business models
- Defining logical joins, dimensional hierarchies, and aggregation rules
- Presentation layer: Designing subject areas for end-user reporting
- Hiding and organizing columns for intuitive dashboard creation
- Importing and merging changes from multiple data sources
- Handling complex data modelling scenarios and star schemas
Week 3 — Measures, Hierarchies & Repository Variables
- Creating logical measures, calculated columns, and aggregation rules
- Implementing time series functions (Ago, ToDate, Period Rolling)
- Level-based measures and dimensional context awareness
- Building parent-child hierarchies and level-based hierarchies
- Understanding repository variables (session, static, system, and dynamic)
- Using initialization blocks to populate variables dynamically
- Implementing multi-language and multi-currency support
- Performance tuning of logical SQL generated by OBIEE
Week 4 — Interactive Dashboards & Advanced Analyses
- Creating analyses using Criteria, Columns, and Filters
- Advanced view types: Pivot tables, charts (bar, line, pie, scatter), and gauges
- Creating column selectors, view selectors, and action links
- Dashboard creation, dashboard prompts, and guided navigation
- Leveraging variables and dynamic content within dashboards
- Implementing drill-downs and navigating between reports
- Adding custom JavaScript and CSS to dashboards
- Best practices for dashboard layout and user experience design
Week 5 — Security, Cache Management & Performance Tuning
- Understanding OBIEE security architecture and WebLogic integration
- Managing users, groups, and application roles in the Enterprise Manager
- Implementing row-level and column-level data security using filters
- Query cache mechanism and cache management strategies
- Manual cache seeding, purging, and scheduling cache updates
- Monitoring and tuning query performance using usage tracking logs
- Aggregate persistence (Materialized Views) for accelerated reporting
- Identifying and resolving slow-running analyses
Week 6 — Deployment, Integration & Capstone Project
- Migrating repositories, web catalogs, and security configurations across environments
- Using BAR (BI Application Archive) files and the Migration Utility
- Integrating OBIEE with Oracle BI Publisher for pixel-perfect reporting
- Exposing OBIEE reports via web services and SOAP APIs
- Embedding OBIEE dashboards into external applications (iframe/SSO)
- Scheduling iBots, agents, and delivering reports via email
- Disaster recovery and high-availability best practices
- Capstone Project: Design and deploy a complete enterprise BI solution from scratch
Project: Build an end-to-end OBIEE analytical dashboard suite for a real-world business domain.
Starting Date: 4th July 2026
Course Fee: £2990
