Oracle OBIEE Server Administration

Course code: O1047

5 days £2,300.00

Oracle OBIEE Server Administration training course covers the key elements in the OBIEE suite, including tools to build interactive dashboards, perform ad hoc analysis, configure information deliveries, alerts an

Course content >

Who Should Attend?

  • Database Administrators
  • Data Warehouse Administrators
  • BI Developers
  • BI Power Users
  • Business Analysts
  • Data Modelers


Course Reviews

iTrain also offer all of these courses as closed courses on your site. Please call 020 7608 1835


Course Contents

The Oracle OBIEE Server Administration training course will provide meaningful real-time metrics, measurements and facts to your business users when you master the components in Oracle's Business Intelligence Enterprise Edition (OBIEE).

Our instructor-led courses cover the key elements in the OBIEE suite, including tools to build interactive dashboards, perform ad hoc analysis, configure information deliveries, alerts and produce reporting. This Administration course teaches the attendee how to set up and administer the three layers of an Oracle BI Repository - the Physical layer, the Business layer, and the Presentation layer. Attendees will learn to import schemas, design and build logical business models, and expose business models to users in Oracle BI Answers. Business users, data architects and developers - every member of your team will contribute to the success of your next BI project.

Whether you are planning to implement Oracle OBIEE and want to evaluate the product or you've implemented Oracle OBIEE and want to get the most from out of your investment, iTrain Oracle OBIEE courses are built to give you the knowledge and skills you need.

Training Course Contents


  • Learn how to use physical database objects as data sources
  • Learn how to convert those physical sources into a Business Model
  • Learn how to expose the business model to the user community
  • Learn how to implement a security model
  • Learn about caching for enhanced performance
  • Learn how to use advanced features of the tool

OBIEE Server and Repository

  • Configuration of the Oracle BI Server environment
  • Prerequisites- Hardware and Software Requirements for - Installing Oracle BI EE
  • Installing and configuring OBIEE
  • Physical Repository Design
  • Adding Multiple Sources of Data source
  • Compare oracle database data with ms excel datasheet
  • Metadata Layer Design
  • Building Presentation layer
  • Dimensions, Facts and Measures
  • Mapping to Star and Snowflake Schemas
  • Creating Repository
  • Repository Management
  • Multi User Development in OBIEE
  • Merging Multiple Repositories in OBIEE
  • Using Catalog Manager
  • About NQSConfig.ini and key configuration files in OBIEE
  • Using Aggregates and the Aggregate persistence wizard
  • Using Alias tables and Dynamic Physical Tables
  • Initialization Blocks
  • Session Variables and Repository Variables
  • Time Series Data
  • Dimension Hierarchies and Level Based Measures
  • Calculations on Fact Tables
  • Exploring Logical Join types

Security Concepts and Setup

  • Security and User Management Caching
  • Cache Management in OBIEE
  • Catalog Setup
  • Documentation
  • Configuration of BI Delivers
  • Configuring OBI Scheduler Tables
  • Configuring OBI Scheduler
  • Testing iBot
Contact us for more information