Oracle Business Intelligence Foundation Certified Implementation Specialist

Oracle Business Intelligence 10 Foundation Essentials

Oracle Business Intelligence Foundation Suite delivers best in class reporting, ad hoc query, OLAP, dashboards, and scorecards on an architecturally integrated business intelligence foundation.

Oracle Business Intelligence10 Foundation Essentials (1Z0-526) exam tests your training and experience to ensure that you have a strong foundation and expertise in Oracle Business Intelligence Suite and Enterprise Edition Plus (OBIEE). The exam targets the intermediate-level implementation team member. Up-to-date training and field experience are recommended.

Oracle Partners passing this exam will be recognized as OPN Certified Specialists. This certification helps their companies qualify for the Oracle Business Intelligence Foundation Specialization.

Exam Number:
105 minutes
Associated Certifications:
Oracle Business Intelligence Foundation Certified Implementation Specialist

OPN Certified Specialist
Number of Questions:
Exam Price:
US $245

More on exam pricing
Passing Score

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


Recommended Training Additional Information & Resources Exam Topics Fraudulent Activity Policy

Recommended Training
Oracle Business Intelligence Foundation Essentials – Exam Study Guide (PDF)
OPN Guided Learning Path
Oracle Business Intelligence Foundation 10 Implementation Specialist
Boot Camps
Oracle BI EE 10 Implementation Boot Camp


Additional Information & Resources

Exam Retake Policy
Specialization Catalog (PDF) for all launched and planned Specializations
Product Mapping to Specialization (XLS) 
More Training Opportunities for Oracle Partners


Exam Topics

Oracle BI and EPM System Overview

  • Describe Oracle’s overall EPM System
  • Define and describe business analytics and business intelligence
  • Describe how OBIEE addresses business intelligence challenges
  • Identify and describe the Oracle Business Intelligence Enterprise Edition (OBIEE) products and components

OBI EE Architecture

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

Oracle BI Installation

  • Explain system requirements, supported platforms and installation pre-requisites
  • Successfully install OBIEE

BI EE User Interface Overview

  • Describe Oracle BI Answers, Dashboards and Delivers
  • Use Oracle Answers to construct, modify, and save BI requests
  • Use Oracle Answers to construct, modify, and save Filters
  • Use Oracle BI Presentation Catalog to create and modify catalog folders

Dashboards and Answers Development

  • Use Intelligence Dashboard UI objects to construct an Intelligence Dashboard
  • Configure delivery devices
  • Add delivery profiles
  • Build Analytics alerts
  • Create iBots

Dimensional Modeling

  • Describe Data Warehousing
  • Describe Dimensions, Facts and Hierarchies

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
  • Execute steps to 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

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

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

Using Non-Dimensional Data

  • Prototype using a spreadsheet
  • Model a non-dimensional data source

Implementation Methodology and Best Practices

  • Describe and apply a recommended approach for implementing Oracle BI
  • Identify various implementation phases
  • Employ Oracle recommended implementation best practices

Oracle BI Security

  • Define authentication and authorization
  • Describe the different levels at which security is enforced
  • Configure security using Security Manager
  • Configure query governing controls

Cache Management

  • Explain the purpose of cache in OBI
  • Configure caching and manage cache files
  • Develop caching strategies

Performance Tuning

  • Describe the request and data flow in Oracle BI
  • Identify sources of performance bottlenecks and best practices for making improvements

MS Office Integration

  • Use MS Office plug in for Oracle BI
  • Identify the required components to enable  
  • office integration
  • Install and configure MS office server and client for Oracle BI


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