OBIEE 11g Bootcamp

Course Overview

Completely rewritten and updated for OBIEE 11g, this course is designed for customers who wish to quickly train up a team of developers so that they can deliver an end-to-end Oracle BIEE system. Over five intensive days, it covers all that you will need to know to deliver an initial OBIEE 11g system, and assumes no prior knowledge up-front. Course materials are in English, but we can deliver the course in other languages including Italian, French, German, Spanish, Portuguese and Greek using our own native-speaking trainers.

From installation through to deploying reports and dashboards, this course starts by covering architecture and deployment, creating repositories and catalogs, and sourcing data from relational and file sources. It then takes delegates through building analyses and dashboards, and using the new Scorecard & Strategy Management feature to create key performance indicators and scorecards. New features such as the Action Framework are covered in detail, together with areas such as security, deployment between environments, and performing systems managements tasks using Enterprise Manager and WLST scripting environment.

Who Should Attend

Developers, Consultants, Project Managers, Tech Leads, and DBAs

Previous Knowledge

None Required

Duration

5 Days

Course Agenda

OBIEE 11g Overview & Product Architecture

  • Overview of OBIEE

Creating Repositories From Relational Sources

  • Creating an Oracle BI Repostiroy from a star-schema Oracle RDBMS source
  • Parent-Child, Skipped Level and Ragged Hierarchies

Advanced Repository Modeling From Relational Sources

  • Lookup Tables and Double-Columns
  • Horizontal & Vertical Federation (Drill-Up and Drill-Across)
  • Server Variables
  • Modeling Transactional (3NF) Data Sources

Creating Analyses and Dashboards

  • Creating Simple Table & Title Views
  • Adding Filters & Prompts
  • Creating Pivot Table Views
  • Charts & Gauges
  • Conditional Formatting
  • View & Column Selectors
  • Narrative & Ticker View
  • Creating Basic Dashboards
  • Dashboards Prompts
  • Hierarchical Columns & OLAP Analysis
  • Master-Detail Linking
  • New Graphing Features in OBIEE 11g
  • Trellis Charts
  • Mapping & Spatial Analysis
  • Using Variables in Answers

Actionable Intelligence

  • Basic Action Links (Navigation Actions)
  • Creating Agents & Conditions

Creating Published Reports (BI Publisher)

  • BI Publisher Overview
  • BI Publisher User Interface
  • Online Data Modeler
  • Online Template Editor

System Management Using Oracle Enterprise Manager

  • Stopping, Starting and Restarting OBIEE 11g
  • FMW - Metrics, Logging and Diagnostics
  • Managing RPDs and Web Catalogs Using Enterprise Manager
  • Query Caching
  • Usage Tracking
  • The Aggregate Persistence Wizard
  • Write Back
  • Direct Database Requests

OBIEE 11g Security

  • Understanding the OBIEE 11g Security Model
  • Creating Users & Groups in the WLS LDAP Server
  • Creating & Working with Application Roles & Policies
  • Integrating with Microsoft Active Directory

High-Availability, Scaleout & Clustering

  • Understanding OBIEE and WLS Clustering Concepts
  • Vertical Scaleout
  • Horizontal Scaleout
  • Deploying for High-Availability