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

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