Oracle Business Intelligence Foundation Suite 11 Essentials

Oracle Business Intelligence Foundation Suite 11g Essentials

The Oracle Business Intelligence Foundation Suite 11g Essentials identifies professionals that are skilled in implementing solutions based on Oracle Business Intelligence Suite. The certification covers skills such as: installing OBIEE, building the BI Server metadata repository, building BI dashboards, constructing ad hoc queries, defining security settings and configuring and managing cache files. The exam targets the intermediate-level implementation team member. Up-to-date training and field experience are recommended.

This certification is available to all candidates, but it is geared toward members of the Oracle PartnerNetwork. OPN Members earning this certification will be recognized as Oracle Business Intelligence Foundation Suite 11 Specialization.

Exam Number:
2 hours
Exam Price:
US $245

More on exam pricing
Number of
Certifications Earned:
Oracle Business Intelligence Foundation Suite 11g Certified Implementation Specialist

OPN Certified Specialist

Passing score subject to change. View Details.
Exam Validation:
Exam validated against release 11g
Exam Format:
Multiple Choice


Recommended Training and Preparation Additional Information & Resources Exam Topics Fraudulent Activity Policy

Recommended Training
Oracle Business Intelligence Foundation Suite 11g Essentials Exam Study Guide (PDF)


Additional Information & Resources

Exam Retake Policy
Specialization Catalog (PDF) for all launched and planned Specializations
Product Mapping to Specialization (XLS)


Exam Topics

Oracle BI and EPM System Overview

  • Describe how OBIEE addresses business intelligence challenges
  • Describe the Oracle Business Intelligence Enterprise Edition (OBIEE) products

OBIEE Architecture

  • Describe major components of the OBIEE architecture
  • Describe the function of each component

Oracle BI Installation

  • Describe the Installation Architecture for OBIEE
  • Explain system requirements, supported platforms and installation pre-requisites
  • Install OBIEE

OBIEE User Interface Overview

  • Describe the components of OBIEE User Interface
  • Perform Oracle Analysis to construct, modify, and save BI requests
  • Build Dashboards
  • Create BI Delivers

Dimensional Modeling

  • Describe the differences between Transactional and Analytical Systems
  • Describe Data Warehousing
  • Build Dimensions, Facts and Hierarchies
  • Explain Dimensional Modeling

Oracle BI Repository Overview

  • Describe the three layers of the OBI Repository
  • Use the Administration Tool to view and modify the repository

Build Basic Repository

  • Define a System Data Source Name (DSN) for a data source
  • Build the Physical layer of the Repository
  • Build the Logical layer of the Repository
  • Build the Presentation layer of the repository

Repository Testing and Deployment

  • Describe techniques for testing a repository
  • Validate and test a repository

Complex Repository Modeling

  • Describe Derived Metrics and its use
  • Configure Derived metrics based on existing logical columns
  • Configure Derived metrics based on physical columns

Advanced Repository Modeling

  • Create Data Partitioning
  • Create Segmentation of Data
  • Create Time Series Data

Building a Repository with Multiple Sources

  • Add multiple sources to an existing logical table source for a dimension in the business model
  • Add a second table source to a dimension in the business model

Hierarchies and Level Based Measures

  • Create a dimensional hierarchy
  • Use level-based measures
  • Create a rank measure
  • Describe Aggregate tables and the purpose they serve
  • Create Aggregate tables in the OBI repository

Using Variables

  • Explain session variables
  • Describe repository variables
  • Describe initialization blocks
  • Implement a dynamic repository variable

Implementation Methodology and Best Practices

  • Describe the implementation phases

Oracle Business Intelligence Enterprise Edition Security

  • Describe authentication and authorization
  • Describe the different levels at which security is enforced
  • Configure security using Security Manager
  • Configure Query Governing controls

Cache Management & Performance Tuning

  • Explain the purpose of cache in OBIEE
  • Configure caching and manage cache files
  • Develop caching strategies
  • Describe the request and data flow in OBIEE

MS Office Integration

  • Use MS Office Plug-In for OBIEE
  • Describe the required components to enable office integration
  • Install and configure MS office server and client for OBIEE

Spatial Integration

  • Explain Spatial Intelligence and Integration
  • Add Map based visualization to OBIEE

Write Back within OBIEE

  • Describe Write Back capabilities
  • Configure Write Back with OBIEE

Essbase Integration

  • Implement Essbase as a Data Source
  • Configure BI Server Metadata for Essbase
  • Explain Essbase Integration


Oracle Certification Program Fraudulent Activity Policy
Oracle reserves the right to take action against any candidate involved in fraudulent activities, including, but not limited to, fraudulent use of vouchers, promotional codes, reselling exam discounts and vouchers, cheating on an exam, alteration of score reports, alteration of completion certificates, violation of exam retake policies or other activities deemed fraudulent by Oracle.

If Oracle determines, in its sole discretion, that fraudulent activity has taken place, it reserves the right to take action up to and including, but not limited to, decertification of a candidate's Oracle Certified Associate, Oracle Certified Professional and/or OCM credentials, temporary, indefinite or permanent ban of a candidate from Oracle certification programs, notification to a candidate's employer, and notification to law enforcement agencies. Candidates found committing fraudulent activities forfeit all fees previously paid to Oracle, or to Oracle's authorized vendors, and may be required to pay additional fees for services rendered.

View the Oracle Certification Program Candidate Agreement which requires your agreement before the start of each exam.



 E-mail this page  Printer View