1Z0-591: Oracle Business Intelligence (OBI) Foundation Suite 11g Essentials


Exam Number: 1Z0-591

Exam Title: Oracle Business Intelligence (OBI) Foundation Suite 11g Essentials


Associated Certification Paths



Oracle 1Z0-851 Certification Details:


Exam Name Oracle Business Intelligence (OBI) Foundation
Suite 11g Essentials
Exam Code 1Z0-591
Exam Product Version BI Enterprise Edition (BI EE)
Exam Price USD $245
Duration 120 minutes
Number of Questions 75
Passing Score 63% 
Validated Against This exam has been validated 11.1.1.5.
Format Multiple Choice
Recommended Practice 1Z0-591 Online Practice Exam
Recommended Training Oracle Business Intelligence Enterprise Edition Plus Implementation Boot Camp
Oracle Business Intelligence Foundation 11g Implementation Specialist

Oracle 1Z0-591 Certification Topics:


Oracle BI and EPM System Overview
  • Describe how OBIEE addresses business intelligence challenges
  • Describe the Oracle Business Intelligence Enterprise Edition (OBIEE) products
OBI EE Architecture
  • Describe major components of the OBIEE architecture
  • Describe the function of each component
Oracle BI Installation
  • Describe the Installation Architecture for OBI EE
  • Explain system requirements, supported platforms and installation pre-requisites
  • Install OBIEE
OBI EE User Interface Overview
  • Describe the components of OBI EE 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 OBI EE
  • Configure caching and manage cache files
  • Develop caching strategies
  • Describe the request and data flow in OBI EE
MS Office Integration
  • Use MS Office Plug-In for OBI EE
  • Describe the required components to enable office integration
  • Install and configure MS office server and client for OBI EE
Spatial Integration
  • Explain Spatial Intelligence and Integration
  • Add Map based visualization to OBI EE
Write Back within OBI EE
  • Describe Write Back capabilities
  • Configure Write Back with OBI EE
Essbase Integration
  • Implement Essbase as a Data Source
  • Configure BI Server Metadata for Essbase
  • Explain Essbase Integration

Oracle 1Z0-591 - Oracle Business Intelligence (OBI) Foundation Suite 11g Essentials Exam Preparation: