1Z0-526: Oracle Business Intelligence (OBI) Foundation 10 Essentials


Exam Number: 1Z0-526

Exam Title: Oracle Business Intelligence (OBI) Foundation 10 Essentials


Associated Certification Paths



Oracle 1Z0-526 Certification Details:


Exam Name Oracle Business Intelligence (OBI) Foundation 10 Essentials
Exam Code 1Z0-526
Exam Product Version BI Enterprise Edition (BI EE)
Exam Price USD $245
Duration 105 minutes
Number of Questions 70
Passing Score 61%
Validated Against: This exam has been validated against 10.1.3.
Format Multiple Choice
Recommended Practice 1Z0-526 Online Practice Exam
Recommended Training Oracle Business Intelligence Enterprise Edition Plus Implementation Boot Camp

Oracle 1Z0-526 Certification 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 Inteligence 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
  • Sucessfully 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 implementaion 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 1Z0-526 - Oracle Business Intelligence (OBI) Foundation 10 Essentials Exam Preparation: